how you can list all the tables in a database?

1067

---

What is a mixed extent?

1078

---

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

1103

---

What stored procedure would you use to view lock information?

1017

---

What are information schema views?

1030

---

What is an entity-relationship diagram (erd)?

1310

---

What is the difference between for auto and for nested?

1064

---

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

1016

---

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

1123

---

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

997

---

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

1098

---

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?

1144

---

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

959

---

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

1065

---

How you can minimize the deadlock situation?

1083

---