INF 214 Quiz 2

Question 1

Data inconsistencies are abnormalities when all changes in redundant data was not made correctly:
Why/why not?

Answer 1

False

Data anomolies

Question 2

One example of a DBMS function is security management:

Answer 2

True

Question 3

A data model is an abstraction and you cannot draw required data out of the data model

Answer 3

True

Question 4

In a table, a row shows a single entity occurrence within an entity set:

Answer 4

True

Question 5

A superkey is also a candidate key:

Answer 5

False

Can also be a composite key

Question 6

UNION finds the rows that appear in both tables and puts them in the new table:

Answer 6

False

Intersect

Question 7

A natural join causes referential integrity problems:

Answer 7

False

An outer join

Question 8

The relationship may represent an event that links the entities or merely a logical affinity that exists between the entities

Answer 8

True

Question 9

An ERD represents the conceptual database as viewed by end user:

Answer 9

True