Blog

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:

What would the following view contain for values? Create view CustomerOrders as Select CustID, Count(*) as TotOrders, Sum(ordertotal) as ValueFrom customer inner join sale on customer.customer_id = sale.customer_id;