how can we use a composite key for two tables and how can we represent it

1 Answers   BoA,

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

0 Answers   HP,

---

Explain what role entity and relationship play in an ER diagram.

0 Answers  

---

Difference between connected and disconnected database in .net with sql server?

0 Answers   Infosys,

---

Explain Trigger with an example?

2 Answers  

---

---

Name 3 ways to get an accurate count of the number of records in a table?

0 Answers  

---

List some major differences between triggers and stored procedures?

0 Answers  

---

Do you know what is lock escalation?

0 Answers  

---

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 Answers  

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

0 Answers  

---

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

---