What are the advantages of indexing?

0 Answers  

---

what are the different type of normalization? : Sql dba

0 Answers  

---

i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk

1 Answers   Aspire,

---

Is coalesce faster than isnull?

0 Answers  

---

How do I partition in sql?

0 Answers  

---

---

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

---

What is file based approach?

0 Answers  

---

how to create a test table in your mysql server? : Sql dba

0 Answers  

---

how a reference cursor works?what all adnvantages are gained with it..specify the situation?

4 Answers   TCS,

---

From an Employee table, how will you display the record which has a maximum salary?

29 Answers   Cap Gemini, Exilant, Synechron,

---

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  

---

How will we see framework of a table?

2 Answers   Accenture,

---