Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

1040

---

How would you choose between a clustered and a non-clustered index?

1019

---

How raid can influence database performance?

1085

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

1014

---

Explain for xml explicit mode?

1025

---

How can you check the level of fragmentation on a table?

1087

---

Explain an automatic checkpoint

1015

---

If no size is defined while creating the database, what size will the database have?

1035

---

How you would rewrite the sql query to return the customerid sorted numerically?

1046

---

What you can do to delete a table without the delete trigger firing?

1012

---

What is the difference between insensitive and scroll cursor?

1239

---

Why transaction is important?

1021

---

in the physical file layout, where should the transaction log be stored in relation to the data file?

1040

---

What are the approximate numeric data types?

987

---

What is a partitioned view?

1051

---