A join that is based upon equality between values in two common columns with the same name and where one duplicate column has been removed is called a(n):

The most important challenge of customizing a purchased data model is:

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;

Which of the following is a principal type of authorization table?

Program-data dependence is caused by:

The ________ DBA view shows information about all users of the database in Oracle.

An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n):

An audit trail of database changes is kept by a:

A primary key whose value is unique across all relations is called a(n):

The SQL command ________ adds one or more new columns to a table.