SQL QUIZ
1 .
A view is which of the following?

Correct Answer : Option (A)

A virtual table that can be accessed via SQL commands
  Show Answer
2 .
The SQL keyword(s) ________ is used with wildcards.

Correct Answer : Option (B)

LIKE only
  Show Answer
3 .
Which of the following is one of the basic approaches for joining tables?

Correct Answer : Option (D)

All of the above
  Show Answer
4 .
Which of the following statements is true concerning subqueries?

Correct Answer : Option (A)

Involves the use of an inner and outer query.
  Show Answer
5 .
The command to eliminate a table from a database is:

Correct Answer : Option (B)

DROP TABLE CUSTOMER;
  Show Answer
6 .
Which of the following is the correct order of keywords for SQL SELECT statements?

Correct Answer : Option (A)

SELECT, FROM, WHERE
  Show Answer
7 .
Which of the following is a correlated subquery?

Correct Answer : Option (B)

Uses the result of an outer query to determine the processing of an inner query.
  Show Answer
8 .
ON UPDATE CASCADE ensures which of the following?

Correct Answer : Option (B)

Data Integrity
  Show Answer
9 .
A subquery in an SQL SELECT statement is enclosed in:

Correct Answer : Option (B)

parenthesis -- (...) .
  Show Answer
10 .
SQL data definition commands make up a(n) ________ .

Correct Answer : Option (A)

DDL
  Show Answer