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;

What is cursor and its types?

561

---

What are different types of statements supported by sql?

609

---

In what condition is it good to disable a trigger?

556

---

Explain what is table in a database?

577

---

how to create a test table in your mysql server? : Sql dba

496

---

---

Explain isolation levels. : Transact sql

579

---

Explain foreign key in sql?

621

---

How to disable a trigger name update_salary?

678

---

How to pipe multiline string to isql?

580

---

What is database sql?

541

---

What is data abstraction in sql?

513

---

Can we use commit inside a trigger?

529

---

what is data control language? : Sql dba

588

---

What do you mean by rowid?

538

---

define sql insert statement ? : Sql dba

550

---