Database - Advanced SQL

Exercise :: 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

Answer: Option B

Explanation:

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

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

Answer: Option A

Explanation:

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

3. 

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

A. True
B. False

Answer: Option A

Explanation:

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

4. 

Subqueries can be nested multiple times.

A. True
B. False

Answer: Option A

Explanation:

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

5. 

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

A. True
B. False

Answer: Option A

Explanation:

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