Advanced SQL
Which of the following is true concerning triggers?

You do not create them with SQL.
They cannot cascade (cause another trigger to fire).
They execute against only some applications that access a database.
They have an event, condition, and action.

ANSWER DOWNLOAD EXAMIANS APP

Advanced SQL
Embedded SQL is which of the following?

Hard-coded SQL statements in a procedure.
Hard-coded SQL statements in a program language such as Java.
The process of making an application capable of generating specific SQL code on the fly.
Hard-coded SQL statements in a trigger.

ANSWER DOWNLOAD EXAMIANS APP

Advanced SQL
Which of the following is a correlated subquery?

Uses the result of an inner query to determine the processing of an inner query.
Uses the result of an outer query to determine the processing of an outer query.
Uses the result of an outer query to determine the processing of an inner query.
Uses the result of an inner query to determine the processing of an outer query.

ANSWER DOWNLOAD EXAMIANS APP