Exercise: Advanced Sql

Questions for: Advanced Sql

Subqueries can be nested multiple times.
A:
True
B:
False
C:
D:
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
There should be one condition within the WHERE clause for each pair of tables being joined.
A:
True
B:
False
C:
D:
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
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
C:
D:
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Triggers are stored blocks of code that have to be called in order to operate.
A:
True
B:
False
C:
D:
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Which of the following is true concerning triggers?
A:
You do not create them with SQL.
B:
They execute against only some applications that access a database.
C:
They have an event, condition, and action.
D:
They cannot cascade (cause another trigger to fire).
Answer: C
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz