Define constraints and give an example of their use?

1039

---

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

939

---

How can a user-defined datatype be created?

985

---

Explain timestamp datatype?

963

---

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

961

---

Can an automatic recovery be initiated by a user?

1004

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

1042

---

Can a table be created inside a trigger?

965

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1036

---

Explain different backup plans?

938

---

When would you prefer to have a minimum number of indexes?

900

---

What specific conditions database should meet, before you can bulk copy data into it using bcp?

982

---

Can a trigger be created on a view?

952

---

What are the restraints imposed on the table design by a merge replication?

1033

---

What is raid, and how it can influence database performance?

1052

---