SQL QUIZ
1 .
Which of the following SQL statements will generate an error when executed.

Correct Answer : Option (D)

IF NOT EXISTS CREATE DATABASE `STUDENTS`;
  Show Answer
2 .
Which of the following scripts will run successfully?

Correct Answer : Option (A)

SELECT `customer name` FROM customers WHERE cat_id = 12 ORDER BY cat_id;
  Show Answer
3 .
The SQL WHERE clause:

Correct Answer : Option (B)

limits the row data are returned.
  Show Answer
4 .
Which of the following is the original purpose of SQL?

Correct Answer : Option (D)

All of the above.
  Show Answer
5 .
The wildcard in a WHERE clause is useful when?

Correct Answer : Option (B)

An exact match is not possible in a SELECT statement.
  Show Answer
6 .
What type of join is needed when you wish to include rows that do not have matching values?

Correct Answer : Option (C)

Outer join
  Show Answer
7 .
What type of join is needed when you wish to return rows that do have matching values?

Correct Answer : Option (D)

All of the above.
  Show Answer
8 .
Which of the following is true concerning a procedure?

Correct Answer : Option (C)

They include procedural and SQL statements.
  Show Answer
9 .
A CASE SQL statement is which of the following?

Correct Answer : Option (A)

A way to establish an IF-THEN-ELSE in SQL.
  Show Answer
10 .
Which of the following statements is true concerning routines and triggers?

Correct Answer : Option (A)

Both consist of procedural code.
  Show Answer