Introduction to 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

16. DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.

A. True
B. False

Correct Answer:  B. False
Advertisement

17. The result of every SQL query is a table.

A. True
B. False

Correct Answer:  A. True
Advertisement

18. COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.

A. True
B. False

Correct Answer:  A. True
Advertisement

19. SUM, AVG, MIN, and MAX can only be used with numeric columns.

A. True
B. False

Correct Answer:  B. False
Advertisement

20. Most companies keep at least two versions of any database they are using.

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?