Explain what physical independence means.

1.Question :(TCO 2) Explain what physical independence means.

2.Question :(TCO 1) Data constitutes the building blocks of _____________.

information

processing

applications

programming

3.Question :(TCO 1) The DBMS allows you to extrapolate information from your data by using a

________________.

query language

table generator

security system

access control

4.Question :(TCO 1) The lowest level in a database hierarchy is the ____________ or value as it is often

referred.

record

table

row

data

5.Question :(TCO 2) In Oracle, a ____________________ is automatically constrained to be UNIQUE and NOT

NULL.

Foreign Key

Primary Key

Candidate Key

emp_id

6.Question :(TCO 2) Within a table, the primary key must be unique so that it will identify each row. When

this is the case, the table is said to exhibit ___________.

referential integrity

entity integrity

enforced integrity

minimum integrity

7.Question :(TCO 2) A primary key _________________________.

consists of only one field

has the value for all records

must contain a unique value for each record within the table

is defined automatically

8.Question :(TCO 2) If a foreign key contains either matching values or nulls, the table(s) that make use

of such a foreign key is/are said to exhibit __________ integrity.

referential

restrictive

secondary

redundant

9.Question :(TCO 5) The ___________ model is both software and hardware dependent.

conceptual

logical

condensed

physical

10.Question :(TCO 5) The product of a logical model is the _____________.

EERM

ERD

ORM

DDL