SQL for Database Construction – True or False

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

A. True
B. False

Correct Answer:  A. True
Advertisement

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

A. True
B. False

Correct Answer:  B. False
Advertisement

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

A. True
B. False

Correct Answer:  A. True
Advertisement

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

A. True
B. False

Correct Answer:  B. False
Advertisement

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

Correct Answer:  B. False
Advertisement

Leave A Comment?