how you can list all the tables in a database?

1072

---

What is a mixed extent?

1080

---

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

1108

---

What stored procedure would you use to view lock information?

1021

---

What are information schema views?

1036

---

What is an entity-relationship diagram (erd)?

1317

---

What is the difference between for auto and for nested?

1069

---

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

1018

---

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

1128

---

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

1002

---

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

1103

---

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?

1149

---

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

961

---

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

1073

---

How you can minimize the deadlock situation?

1089

---