Advanced SQL
Which of the following is true concerning systems information in an RDBMS?

All of these
This information can be accessed using SQL.
This information often cannot be updated by a user.
RDBMS store database definition information in system-created tables.

ANSWER DOWNLOAD EXAMIANS APP

Advanced SQL
Which of the following is a correlated subquery?

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 inner query.
Uses the result of an outer query to determine the processing of an outer query.
Uses the result of an inner query to determine the processing of an outer query.

ANSWER DOWNLOAD EXAMIANS APP

Advanced SQL
Embedded SQL is which of the following?

Hard-coded SQL statements in a procedure.
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 trigger.

ANSWER DOWNLOAD EXAMIANS APP