Answer Posted / rahul koshti

This results the total count of tables,views,synonyms and
sequences present in a schema.

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1040

---

What are the main features of cursor?

1038

---

How do I find duplicates in sql?

873

---

Why is a trigger used?

885

---

What do you understand by exception handling in pl/sql?

961

---

How would you pass hints to the sql processor?

919

---

What is implicit cursor in pl sql?

1023

---

How do you add a column to a table?

992

---

Difference between global and parameter variables?

1903

---

What's the difference between a primary key and a clustered index?

946

---

Why truncate is used in sql?

932

---

what are the different tables present in mysql? : Sql dba

922

---

What is string data type in sql?

1045

---

Explain the methods used to protect source code of pl/sql.

956

---

What does trigger mean in slang?

998

---