Advanced SQL – True or False

1. Triggers are stored blocks of code that have to be called in order to operate.

A. True
B. False

Correct Answer: B. False

2. The joining technique is useful when data from several relations are to be retrieved and displayed and the relationships are not necessarily nested.

A. True
B. False

Correct Answer: A. True

3. There should be one condition within the WHERE clause for each pair of tables being joined.

A. True
B. False

Correct Answer: A. True

4. Subqueries can be nested multiple times.

A. True
B. False

Correct Answer: A. True

5. The code to create triggers and routines is stored in only one location and is administered centrally.

A. True
B. False

Correct Answer: A. True

Leave A Comment?

four − one =