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

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

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

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

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

Leave A Comment?

1 + five =