how you can list all the tables in a database?

1022

---

What is a mixed extent?

1010

---

After removing a table from database, what other related objects have to be dropped explicitly?

1050

---

What stored procedure would you use to view lock information?

973

---

What are information schema views?

976

---

What is an entity-relationship diagram (erd)?

1206

---

What is the difference between for auto and for nested?

999

---

Why it is recommended to avoid referencing a floating point column in the where clause?

960

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1058

---

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

941

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1031

---

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

1100

---

If a table does not have a unique index, can a cursor be opened on it?

912

---

Indexes are updated automatically is the full-text index also updated automatically?

1025

---

How you can minimize the deadlock situation?

1037

---