Answer Posted / shivashanker

it will display the total number of tables in the schema.

Differentiate pl/sql and sql?

1062

---

Can we use distinct and group by together?

1050

---

Can instead of triggers be used to fire once for each statement on a view?

960

---

what tools available for managing mysql server? : Sql dba

1076

---

How delete all data from table in sql?

1014

---

Which data type is a composite type?

985

---

Can we use having without group by in sql?

982

---

What is the difference between explicit and implicit cursors in oracle?

1062

---

Why we use joins in sql?

975

---

Is primary key clustered or nonclustered?

1009

---

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1085

---

What is pl sql code?

1045

---

How can you select unique records from a table?

1070

---

Why do we use procedures?

953

---

How to write a query to show the details of a student from students table whose

993

---