Answer / Uvesh Ali

SQL tuning involves optimizing SQL statements to improve database performance. This can involve techniques such as index creation, query restructuring, data normalization, and removing redundant data.

What is difference between server and database?

1 Answers  

---

What is database schema name?

1 Answers  

---

How do you select an index for a table

1 Answers  

---

hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com

1 Answers   HP,

---

Integrity constraints means..? how many and what are they?

4 Answers   AZTEC,

---

How to do Data integrity testing? Who does this testing (Developer or tester)?

1 Answers  

---

sparse lookup and where its options we find in OCI and db2?

1 Answers   TCS,

---

What is the difference between data source and database?

1 Answers  

---

Explain the table term used in database.

1 Answers  

---

What are different types of data models available? Explain with example?

1 Answers   Accenture,

---

Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?

1 Answers   3i Infotech,

---

can any one explain about normalization forms with clear explanation in interview point of view. thanks for ur answers.

1 Answers  

---