Answer / Soni Kumari

"In SQL, there are three levels of collation sensitivity: Case sensitive (uppercase and lowercase characters are treated as distinct), Case insensitive (uppercase and lowercase characters are treated as the same), and Accent sensitive (accented and non-accented characters are treated as distinct)"

What is procedure and function?

1 Answers  

---

Can I create table without primary key?

1 Answers  

---

How to process query result in pl/sql?

1 Answers  

---

What is a left join?

1 Answers  

---

why use cursors?

5 Answers   Oracle,

---

What is sql query optimization?

1 Answers  

---

How do you remove duplicates without using distinct in sql?

1 Answers  

---

Is sql pronounced sequel or sql?

1 Answers  

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---

Why should I use postgresql?

1 Answers  

---

What is different between union and minus?

7 Answers   Accenture, TCS,

---

Is a table valued function object?

1 Answers  

---