SQL for Database Construction – True or False

6. SQL Server does not support the BEFORE trigger.

A. True
B. False

Correct Answer:  A. True
Advertisement

7. A updatable view has its own data.

A. True
B. False

Correct Answer:  B. False
Advertisement

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

A. True
B. False

Correct Answer:  B. False
Advertisement

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

A. True
B. False

Correct Answer:  A. True
Advertisement

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
Advertisement

Leave A Comment?