Physical database design decisions must be made carefully because of impacts on:

a$)$ data accessibility

b$)$ response times

c$)$ security

d$)$ all of them

e$)$ none of them

$2-$ An attribute $($or attributes$)$ that uniquely identifies each row in a relation is called a:

a$)$ column

b$)$ foreign key

c$)$ primary key

d$)$ duplicate key

e$)$ none of them

$3-$ The relational data model consists of which component$($s$)?$

a$)$ data structure

b$)$ data manipulation

c$)$ data integrity

d$)$ all of them

e$)$ none of them

$4-$ An attribute in a relation serving as the primary key of another relation is called a:

a$)$ link attribute

b$)$ foreign attribute

c$)$ foreign key

d$)$ link key

e$)$ none of them

S$-$ A primary key that consists of more than one attribute is called:

a$)$ foreign

b$)$ composite

c$)$ multivalued

d$)$ cardinal

e$)$ none of them

$6-$ Which of the following are properties of relations in a well$-$designed database?

a$)$ each attribute has a unique name

b$)$ no two rows in a relation are identical

c$)$ there are no multivalued attributes in a relation

d$)$ all of them

e$)$ none of them

$7-$ The states that no primary key attribute may be null.

a$)$ entity integrity constraint

b$)$ referential integrity rule

c$)$ partial specialization rule

d$)$ range domain rule

e$)$ none of them

$8-$ A rule stating that each foreign key value must match a primary key value in the other relation is called:

a$)$ referential integrity constraint

b$)$ key match rule

c$)$ entity key group rule

d$)$ foreign$/$primary match rule

e$)$ none of them

$9.$ In the $SQL$ language, the statement is used to make table definitions.

a$)$ create session

b$)$ create table

c$)$ create index

d$)$ select

e$)$ from

$10-$ Which of the following are anomalies that can be caused by redundancies in tables?

a$)$ insertion

b$)$ deletion

c$)$ modification

d$)$ all of them

e$)$ none of them

$11-$A relation that contains minimal redundancy and allows easy use is considered to be:

a$)$ clean

b$)$ complete

c$)$ complex

d$)$ simple

e$)$ well$-$structured