Advanced SQL – 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. Triggers are stored blocks of code that have to be called in order to operate.

A. True
B. False

Correct Answer: B. False
Advertisement

2. The joining technique is useful when data from several relations are to be retrieved and displayed and the relationships are not necessarily nested.

A. True
B. False

Correct Answer: A. True
Advertisement

3. There should be one condition within the WHERE clause for each pair of tables being joined.

A. True
B. False

Correct Answer: A. True
Advertisement

4. Subqueries can be nested multiple times.

A. True
B. False

Correct Answer: A. True
Advertisement

5. The code to create triggers and routines is stored in only one location and is administered centrally.

A. True
B. False

Correct Answer: A. True
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?