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

Correct Answer:  B. False

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

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

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

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

A. True
B. False

Correct Answer:  B. False

Leave A Comment?

eleven + six =