how you can list all the tables in a database?

1026

---

What is a mixed extent?

1026

---

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

1056

---

What stored procedure would you use to view lock information?

976

---

What are information schema views?

988

---

What is an entity-relationship diagram (erd)?

1214

---

What is the difference between for auto and for nested?

1004

---

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

967

---

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

1064

---

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

945

---

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

1036

---

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?

1103

---

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

915

---

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

1029

---

How you can minimize the deadlock situation?

1042

---