Answer Posted / amol

Be very careful when deleting records. You cannot undo this
statement! but in mysql...

what are the advantages and disadvantages of views in a database? : Sql dba

1041

---

How many types of triggers exist in pl/sql?

1064

---

Can we create clustered index without primary key?

962

---

What is sp_helptext?

1060

---

Why are cursors used?

1116

---

How to rename a column in the output of sql query?

1070

---

Mention what is the use of function "module procedure" in pl/sql?

1047

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1434

---

What are stored procedures in mysql?

1015

---

how do you tune the slow running queries in oracle db , explain the methodology

2705

---

What is data definition language?

1088

---

What do you mean by “trigger” in sql?

1069

---

Why we use pl sql?

955

---

what is the difference between join and union? : Sql dba

1109

---

how can we know the count/number of elements of an array? : Sql dba

1060

---