Answer / Amt Dinesh Kumar Asthana

You can check the MySQL server version by running the command 'SELECT VERSION();' in a MySQL client.

Store procedure will return a value?

4 Answers   eMids,

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

1 Answers   Wipro,

---

How do I get sql certification?

1 Answers  

---

Are subqueries faster than joins?

1 Answers  

---

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1 Answers  

---

Is it possible to update views?

1 Answers  

---

Please let me know if UNION ALL and Natural Join does the same operation and are same...

7 Answers   iGate,

---

What is nvl function?

4 Answers   Cap Gemini,

---

What are the disadvantages of not performing database normalization?

1 Answers  

---

what is sql optimization

1 Answers   Fidelity,

---

What are basic techniques of indexing?

1 Answers  

---

Describe sql comments?

1 Answers  

---