Answer / Vinay Kumar Sahu

SQL (Structured Query Language) provides various commands for managing and manipulating databases. Some common SQL commands include SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, and GRANT.

What is composite primary key in sql?

1 Answers  

---

What is a REF CURSOR? Compare strong and week ref cursor types.

6 Answers  

---

what is a cursor

9 Answers   IBM, TCS, Wipro,

---

What is extent clause in table space?

1 Answers   TCS,

---

Define a temp table?

1 Answers  

---

Is left join faster than inner join?

1 Answers  

---

When we give SELECT * FROM EMP; How does oracle respond?

24 Answers   Accenture, HCL, Infosys,

---

how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00

3 Answers  

---

What is Difference Between delete and Truncate?

9 Answers  

---

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

---

What is duration in sql profiler trace?

1 Answers  

---

how do you know if your mysql server is alive? : Sql dba

1 Answers  

---