Introduction to SQL - General Questions (2)

9.

Which one of the following sorts rows in SQL?

A.	SORT BY
B.	ALIGN BY
C.	ORDER BY
D.	GROUP BY

Answer: Option C

Explanation:

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

10.

Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

A.	SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
B.	SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
C.	SELECT NAME IN CUSTOMER WHERE STATE = 'V';
D.	SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

Answer: Option D

Explanation:

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

11.

The Microsoft Access wildcards are ____ and ____ .

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

Answer: Option D

Explanation:

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

12.

When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

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

Answer: Option D

Explanation:

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

13.

SQL query and modification commands make up a(n) ________ .

A.	DDL
B.	DML
C.	HTML
D.	XML

Answer: Option B

Explanation:

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

14.

Which of the following do you need to consider when you make a table in SQL?

A.	Data types
B.	Primary keys
C.	Default values
D.	All of the above.

Answer: Option D

Explanation:

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

15.

The benefits of a standard relational language include which of the following?

A.	Reduced training costs
B.	Increased dependence on a single vendor
C.	Applications are not needed.
D.	All of the above.

Answer: Option A

Explanation:

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

16.

To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

A.	ONLY
B.	UNIQUE
C.	DISTINCT
D.	SINGLE

Answer: Option C

Explanation:

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

1
2
3
4
5