SQL for Database Construction – True or False

1. The SQL statement used to create a view is CREATE VIEW.

A. True
B. False

Show Answer

2. The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.

A. True
B. False

Show Answer

3. SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.

A. True
B. False

Show Answer

4. Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.

A. True
B. False

Show Answer

5. The SQL CHECK constraint is fully defined by the SQL-92 standard and is consistently implemented by all DBMS vendors.

A. True
B. False

Show Answer