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

Warning: Undefined variable $in_same_cat in /www/wwwroot/mtexam.com/public_html/wp-content/plugins/EXP.GKFEED.COM/function.php on line 27

Warning: Undefined variable $excluded_categories in /www/wwwroot/mtexam.com/public_html/wp-content/plugins/EXP.GKFEED.COM/function.php on line 27

Leave A Comment?