Answer Posted / rutujagabhane

select* from tab; gives you the o/p as a table containing rows and columns. The rows contain the name of table ,select count(1) from tab returns the no or rows in tab .
Indirectly the statement returns no of tables in tab;

Differentiate pl/sql and sql?

743

---

define sql delete statement ? : Sql dba

745

---

Does sql profiler affect performance?

733

---

What is before and after trigger?

691

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

871

---

---

Mention what is the function that is used to transfer a pl/sql table log to a database table?

662

---

Explain raise_application_error.

830

---

what is a tablespace? : Sql dba

766

---

Is a foreign key always unique?

679

---

What is the meaning of disabling a trigger?

826

---

which tcp/ip port does sql server run on? : Sql dba

706

---

What is nosql vs sql?

875

---

What is mutating table error?

882

---

What are the different types of sql commands?

786

---

what is online transaction processing (oltp)? : Sql dba

713

---