Answer / anindya basu

The different types of queries are:
a. DDL- e.g. Create, Alter, Rename, Drop, Truncate etc.
b. DML - e,g, Insert, Update, and De;e
c. DCL - Grant, Revoke etc.
d. TCL - Begin Tran, Commit Tran, Rollback Tran
e. DQL - Select

What are constraints? Explain different types of constraints?

26 Answers   Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro,

---

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

0 Answers  

---

Is Sql non procedural query language?

1 Answers   Verifone,

---

Tell me what is the order in which the sql query is executed?

0 Answers  

---

How to assign new column names in a view?

0 Answers  

---

How to override dml statements with triggers?

0 Answers  

---

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

0 Answers  

---

What are the system database in sql server 2005?

0 Answers  

---

How can you control the amount of free space in your index pages?

0 Answers  

---

How to read data in a table with "select" statements?

0 Answers  

---

what's the difference between a primary key and a unique key? : Sql server database administration

0 Answers  

---

How maney row would be print after join if A table have 100 rows and B table have 50 rows...

9 Answers   Hewitt,

---