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

11. Outer join is the same as equi-join, except one of the duplicate columns is eliminated in the result table.

A. True
B. False

Correct Answer: B. False
Advertisement

12. A correlated subquery is where the outer query depends on data from the inner query.

A. True
B. False

Correct Answer: B. False
Advertisement

13. A function returns one value and has only output parameters.

A. True
B. False

Correct Answer: B. False
Advertisement

14. With the UNION clause, each query involved must output the same number of columns, and they must be UNION compatible.

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?