Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1068

---

Explain the dbcc pintable command when would you use it?

972

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1117

---

Is it true, that there is no difference between a rule and a check constraint?

1116

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

1102

---

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

955

---

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1109

---

Explain a checkpoint?

1089

---

What is the exact numeric data type in sql?

1058

---

Which table keeps the locking information?

987

---

How many types of cursor type are there?

1169

---

How can you list all the columns in a database?

975

---

What is the difference between deallocate cursor and close cursor?

1338

---

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

1033

---

Using the customer, and order table in northwind database, please write a query to produce xml?

1119

---