1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?

10 Answers   Perot Systems,

---

what is the importence of the trigger in sqlserver2000?

1 Answers   ATI,

---

What is meant by referential integrity?

0 Answers   Blue Star,

---

What is difference between materialized view and view?

0 Answers  

---

Can two tables have the same primary key?

0 Answers  

---

---

How can we call UDF(User Define Function) using C# code in ASP.net ?

1 Answers  

---

What are alternate keys?

0 Answers  

---

what is a transaction and what are acid properties? : Sql server database administration

0 Answers  

---

What is a primary key?

0 Answers  

---

How can you insert null values in a column while inserting the data?

0 Answers  

---

When is the use of update_statistics command?

0 Answers  

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---