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 a data manipulation language?

1070

---

what is bcp? When does it used? : Sql dba

1027

---

What is difference between stored procedure and trigger?

1242

---

Does pdo prevent sql injection?

988

---

Name the different types of indexes in sql and define them.

1220

---

what are different types of collation sensitivity? : Sql dba

1114

---

What are the differences between in and exists clause?

1160

---

What is error ora-01000: maximum open cursors exceeded

1205

---

What is rank function in sql?

1068

---

How to run sql functions in pl/sql?

1119

---

How do you declare a variable in pl sql?

1066

---

What is benefit of creating memory optimized table?

1030

---

What is pragma in pl sql?

1180

---

List and explain the different types of join clauses supported in ansi-standard sql?

1400

---

Can I create table without primary key?

1041

---