SQL for Database Construction – True or False

6. SQL Server does not support the BEFORE trigger.

A. True
B. False

Show Answer

7. A updatable view has its own data.

A. True
B. False

Show Answer

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

A. True
B. False

Show Answer

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

A. True
B. False

Show Answer

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

Show Answer