what tools available for managing mysql server? : Sql dba

0 Answers  

---

Show the two pl/sql cursor exceptions.

0 Answers  

---

Which is faster union or join?

0 Answers  

---

Where not exists in sql?

0 Answers  

---

Delete duplicate records in the emp table.

6 Answers   Oracle,

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

0 Answers  

---

what is the difference between a web-garden and a web-farm? : Sql dba

0 Answers  

---

Explain select statements in sql?

0 Answers  

---

How to run sql commands in sql*plus?

0 Answers  

---

What is trigger types of trigger?

0 Answers  

---

Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  

---

In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

---