Introduction to SQL - General Questions (4)

25.

Which of the following is valid SQL for an Index?

A.	CREATE INDEX ID;
B.	CHANGE INDEX ID;
C.	ADD INDEX ID;
D.	REMOVE INDEX ID;

Answer: Option A

Explanation:

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

26.

SQL data definition commands make up a(n) ________ .

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

Answer: Option A

Explanation:

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

27.

ON UPDATE CASCADE ensures which of the following?

A.	Normalization
B.	Data Integrity
C.	Materialized Views
D.	All of the above.

Answer: Option B

Explanation:

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

28.

The command to eliminate a table from a database is:

A.	REMOVE TABLE CUSTOMER;
B.	DROP TABLE CUSTOMER;
C.	DELETE TABLE CUSTOMER;
D.	UPDATE TABLE CUSTOMER;

Answer: Option B

Explanation:

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

29.

A view is which of the following?

A.	A virtual table that can be accessed via SQL commands
B.	A virtual table that cannot be accessed via SQL commands
C.	A base table that can be accessed via SQL commands
D.	A base table that cannot be accessed via SQL commands

Answer: Option A

Explanation:

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

30.

The wildcard in a WHERE clause is useful when?

A.	An exact match is necessary in a SELECT statement.
B.	An exact match is not possible in a SELECT statement.
C.	An exact match is necessary in a CREATE statement.
D.	An exact match is not possible in a CREATE statement.

Answer: Option B

Explanation:

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

31.

Which of the following is the original purpose of SQL?

A.	To specify the syntax and semantics of SQL data definition language
B.	To specify the syntax and semantics of SQL manipulation language
C.	To define the data structures
D.	All of the above.

Answer: Option D

Explanation:

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

32.

The SQL WHERE clause:

A.	limits the column data that are returned.
B.	limits the row data are returned.
C.	Both A and B are correct.
D.	Neither A nor B are correct.

Answer: Option B

Explanation:

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

1
2
3
4
5