SQL for Database Construction – True or False


Warning: Undefined variable $ext in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/show-hidecollapse-expand/bg_show_hide.php on line 281

Warning: Undefined variable $ext in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/show-hidecollapse-expand/bg_show_hide.php on line 281

Warning: Undefined variable $ext in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/show-hidecollapse-expand/bg_show_hide.php on line 281

Warning: Undefined variable $ext in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/show-hidecollapse-expand/bg_show_hide.php on line 281

Warning: Undefined variable $ext in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/show-hidecollapse-expand/bg_show_hide.php on line 281

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

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

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

Leave A Comment?