Blog

A command used in Oracle to display how the query optimizer intends to access indexes, use parallel servers, and join tables to prepare query results is the:

All of the following are the main goals of normalization EXCEPT:

The normal form which deals with multivalued dependencies is called:

The most commonly used form of join operation is the:

A(n) ________ constraint is a type of constraint that addresses whether an instance of a supertype must also be an instance of at least one subtype.

In a supertype/subtype hierarchy, subtypes that are lower in the hierarchy inherit attributes from not only their immediate supertype but from all ________ in the hierarchy.

A(n) ________ constraint is a type of constraint that addresses whether an instance of a supertype must also be an instance of at least one subtype.

The most commonly used form of join operation is the:

The first part of an SQL query to be read is the ________ statement.

A mechanism in a ResultSet object in Java that points to the current row of data is called a: