Database Management System Practice Test 3

1. Data that can be modeled as dimension attributes and measure attributes are called _______ data.

Singledimensional

Dimensional

Multidimensional

Measured

2. Which prefixes are available to Oracle triggers?

: new only

Both :new and : old

Neither :new nor : old

: old only

3. Which of the following can be addressed by enforcing a referential integrity constraint?

Information on the customer must be known before anything can be sold to that customer

Then entering an order quantity, the user must input a number and not some text (i.e., 12 rather than ‘a dozen’)

All phone numbers must include the area code

Certain fields are required (such as the email address, or phone number) before the record is accepted

4. The default extension for an Oracle SQL*Plus file is:

.txt

.sql

.pls

.ora

5. Which one of the following uniquely identifies the elements in the relation?

Primary key

Foreign key

Secondary Key

Composite key

6. If you were collecting and storing information about your music collection, an album would be considered a(n) _____

Instance

Entity

Attribute

Relation

7. ______ is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

Domain Constraints

Entity Integrity Constraints

Domain Integrity Constraints

Referential Integrity Constraints

8. Drop Table cannot be used to drop a table referenced by a _________ constraint.

Local Key

Foreign Key

Composite Key

Primary Key

9. An expression in the domain relational calculus is of the form

{ x1, x2, . . . , xn | x1, x2, . . . , xn}

{x1, x2, . . . , xn | < x1, x2, . . . , xn > }

{< x1, x2, . . . , xn > | P(x1, x2, . . . , xn)}

{P(x1, x2, . . . , xn) | < x1, x2, . . . , xn > }

10. An entity set that does not have sufficient attributes to form a primary key is termed a __________

Strong entity set

Variant set

Variable set

Weak entity set