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

26. Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.

A. True
B. False

Correct Answer:  B. False
Advertisement

27. The keyword LIKE can be used in a WHERE clause to refer to a range of values.

A. True
B. False

Correct Answer:  B. False
Advertisement

28. The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.

A. True
B. False

Correct Answer:  B. False
Advertisement

29. The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.

A. True
B. False

Correct Answer:  A. True
Advertisement

30. The wildcard asterisk (*) is the SQL-92 standard for indicating “any sequence of characters.”

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?