Database - Introduction to SQL

Exercise :: 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

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

27. 

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

A. True
B. False

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

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

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

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

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

30. 

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

A. True
B. False

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.