Introduction to SQL – True or False

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