Final exam review part 3

Question 1

A type of data integrity constraint that ensures each row in a table has a unique identifier (primary key).

Answer 1

Entity integrity

Question 2

A clause in a SQL SELECT statement used to filter rows based on specified conditions.

Answer 2

WHERE clause

Question 3

When you design a table you should allow nulls if…

a. a value is not required by business rules
b. the value could be unknown at a particulate point of time
c. a and b
d. none of the above

Answer 3

c. a and b

Question 4

A set of rules designed to reduce or eliminate various anomalies is called

a. normal form
b. an anomaly
c. SDLC
d. logical design

Answer 4

a. normal form

Question 5

Which type of data model takes into account the limitations of a specific RDBMS

a. logical
b. physical
c. conceptual
d. enterprise

Answer 5

b. physical

Question 6

In a business, which one of the following is an example of an attribute

a. Bill’s employment record
b. All the employees
c. Employee’s address
d. This week’s orders

Answer 6

c. Employee’s address

Question 7

A surrogate key should be considered when

a. a relationship is M:N
b. a composite key is required
c. the key contains a lengthy text field
d. an index needs to be created

Answer 7

c. the key contains a lengthy text field