ADVANCED SQL QUIZ

RDBMS store database definition information in system-created tables.

This information often cannot be updated by a user.

All of these

This information can be accessed using SQL.

Does not start with the word SELECT.

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

Involves the use of an inner and outer query.

All of these

Cartesian join

Equi-join

Outer join

Natural join

True

False

Equi-join

Natural join

Outer join

All of these

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 procedure.

Hard-coded SQL statements in a trigger.

False

True

False

True

Three

Two

One

All of these

True

False