SQL for Database Construction – True or False

6. SQL Server does not support the BEFORE trigger.

A. True
B. False

Correct Answer:  A. True

7. A updatable view has its own data.

A. True
B. False

Correct Answer:  B. False

8. The SQL DELETE statement is used to delete both the table structure and table data.

A. True
B. False

Correct Answer:  B. False

9. Common types of SQL CHECK constraints include range checks and limiting columns values.

A. True
B. False

Correct Answer:  A. True

10. If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.

A. True
B. False

Correct Answer:  A. True

Leave A Comment?

4 × four =