Answer Posted / gourvendra singh

select count(1) from tab will give the total number of
tables,views and synonms present in the current schema.

Can we use join in subquery?

775

---

What are sql indexes?

740

---

Which are the different types of indexes in sql?

748

---

What is the usage of sql functions?

814

---

Write an sql query to select all records from the table?

752

---

---

What operators deal with null?

813

---

How many joins can you have in sql?

687

---

what is a trigger in mysql? Define different types of trigger. : Sql dba

730

---

What is autocommit sql?

706

---

What is the maximum number of rows in sql table?

741

---

How to create an array in pl/sql?

771

---

What are the basic techniques of indexing?

778

---

What are the types of sql commands?

741

---

What does trigger mean in slang?

733

---

What is %rowtype in pl sql?

684

---