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

A. True
B. False

Show Answer

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

A. True
B. False

Show Answer

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

Show Answer

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

Show Answer

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

A. True
B. False

Show Answer