ADVANCED SQL QUIZ

False

True

Hard-coded SQL statements in a trigger.

The process of making an application capable of generating specific SQL code on the fly.

Hard-coded SQL statements in a program language such as Java.

Hard-coded SQL statements in a procedure.

True

False

True

False

Involves the use of an inner and outer query.

All of these

Cannot return the same result as a query that is not a subquery.

Does not start with the word SELECT.

All of these

RDBMS store database definition information in system-created tables.

This information can be accessed using SQL.

This information often cannot be updated by a user.

You do not create them with SQL.

They have an event, condition, and action.

They cannot cascade (cause another trigger to fire).

They execute against only some applications that access a database.

False

True

One

Two

Three

All of these

False

True