How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 Answers   Credit Suisse, GCU, Symphony, TCS,

---

Explain relational data?

0 Answers  

---

WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?

3 Answers  

---

What is use of dbcc commands?

0 Answers  

---

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

0 Answers  

---

---

What kind of problems occurs if we do not implement proper locking strategy?

0 Answers  

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 Answers   Accenture, Merrill Lynch, Wipro,

---

Can you give an example of Stored Procedure?

4 Answers   Wipro,

---

Which virtual table does a trigger use?

3 Answers  

---

How can sql server instances be hidden? : sql server security

0 Answers  

---

What are the differences between union, intersect, and minus operators?

0 Answers  

---