How do triggers work?

0 Answers  

---

What are three major types of constraints?

0 Answers  

---

How to view existing indexes on an given table using sys.indexes?

0 Answers  

---

What is the use of RDBMS?

0 Answers   Wipro,

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

---

How m-m relationships are implemented?

2 Answers  

---

Do you know spatial data types - geometry and geography in sql server 2008?

0 Answers  

---

Explain error and transaction handling in sql server?

0 Answers  

---

What is deadlock and how to avoid the deadlocks.

3 Answers   TCS, Wipro,

---

I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 Answers  

---

What is the difference between ddl and dml?

0 Answers  

---

could u plz explain about joins and views?

2 Answers  

---