Introduction to SQL - General Questions (3)

17.

The SQL -92 wildcards are ____ and ____ .

A.	asterisk (*); percent sign (%)
B.	percent sign (%); underscore (_)
C.	underscore(_); question mark (?)
D.	question mark (?); asterisk (*)

Answer: Option B

Explanation:

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

18.

The HAVING clause does which of the following?

A.	Acts like a WHERE clause but is used for groups rather than rows.
B.	Acts like a WHERE clause but is used for rows rather than columns.
C.	Acts like a WHERE clause but is used for columns rather than groups.
D.	Acts EXACTLY like a WHERE clause.

Answer: Option A

Explanation:

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

19.

In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

A.	all columns of the table are to be returned.
B.	all records meeting the full criteria are to be returned.
C.	all records with even partial criteria met are to be returned.
D.	None of the above is correct.

Answer: Option A

Explanation:

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

20.

Which of the following are the five built-in functions provided by SQL?

A.	COUNT, SUM, AVG, MAX, MIN
B.	SUM, AVG, MIN, MAX, MULT
C.	SUM, AVG, MULT, DIV, MIN
D.	SUM, AVG, MIN, MAX, NAME

Answer: Option A

Explanation:

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

21.

The result of a SQL SELECT statement is a(n) ________ .

A.	report
B.	form
C.	file
D.	table

Answer: Option D

Explanation:

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

22.

A subquery in an SQL SELECT statement is enclosed in:

A.	braces -- {...}.
B.	CAPITAL LETTERS.
C.	parenthesis -- (...) .
D.	brackets -- [...].

Answer: Option C

Explanation:

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

23.

Which of the following is the correct order of keywords for SQL SELECT statements?

A.	SELECT, FROM, WHERE
B.	FROM, WHERE, SELECT
C.	WHERE, FROM,SELECT
D.	SELECT,WHERE,FROM

Answer: Option A

Explanation:

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

24.

The SQL keyword(s) ________ is used with wildcards.

A.	LIKE only
B.	IN only
C.	NOT IN only
D.	IN and NOT IN

Answer: Option A

Explanation:

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

1
2
3
4
5