Introduction to SQL - General Questions

1.

SQL is:

A.	a programming language.
B.	an operating system.
C.	a data sublanguage.
D.	a DBMS.

Answer: Option C

Explanation:

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

2.

________ was adopted as a national standard by ANSI in 1992.

A.	Oracle
B.	SQL
C.	Microsoft Access
D.	DBase

Answer: Option B

Explanation:

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

3.

A subquery in an SQL SELECT statement:

A.	can only be used with two tables.
B.	can always be duplicated by a join.
C.	has a distinct form that cannot be duplicated by a join.
D.	cannot have its results sorted using ORDER BY.

Answer: Option C

Explanation:

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

4.

The SQL keyword BETWEEN is used:

A.	for ranges.
B.	to limit the columns displayed.
C.	as a wildcard.
D.	None of the above is correct.

Answer: Option A

Explanation:

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

5.

vThe SQL statement that queries or reads data from a table is ________ .

A.	SELECT
B.	READ
C.	QUERY
D.	None of the above is correct.

Answer: Option A

Explanation:

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

6.

SQL can be used to:

A.	create database structures only.
B.	query database data only.
C.	modify database data only.
D.	All of the above can be done by SQL.

Answer: Option D

Explanation:

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

7.

To define what columns should be displayed in an SQL SELECT statement:

A.	use FROM to name the source table(s) and list the columns to be shown after SELECT.
B.	use USING to name the source table(s) and list the columns to be shown after SELECT.
C.	use SELECT to name the source table(s) and list the columns to be shown after USING.
D.	use USING to name the source table(s) and list the columns to be shown after WHERE.

Answer: Option A

Explanation:

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

8.

To sort the results of a query use:

A.	SORT BY.
B.	GROUP BY.
C.	ORDER BY.
D.	None of the above is correct.

Answer: Option C

Explanation:

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

1
2
3
4
5