How do I tune a sql query?

0 Answers  

---

what is the output of this query selet * from employee where 1=2 ??

11 Answers  

---

how do you control the max size of a heap table? : Sql dba

0 Answers  

---

What is replication id?

0 Answers  

---

what is csv? : Sql dba

0 Answers  

---

---

What are the types of functions in sql?

0 Answers  

---

What is pl sql and why it is used for?

0 Answers  

---

If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING

10 Answers   HCL, TCS,

---

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

4 Answers   CGI, IBM,

---

Explain what is sql*plus?

0 Answers  

---

what is 'mysqldump'? : Sql dba

0 Answers  

---

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

---