quiz review #1

Question 1

Database Cardinality refers to:
A) The number of columns allowed in an entity
B) The number of records in an entity
C) The number of records allowed in a relationship between entities
D) The number of entities allowed in a database

Answer 1

C) The number of records allowed in a relationship between entities

Question 2

Which of the following best defines the term normalization?
A) The process of removing anomalies and redundancies from database design
B) When you cannot enter data because other data is required
C) When you must edit the same information in several places
D) When removing data accidentally causes the loss of other data

Answer 2

A) The process of removing anomalies and redundancies from database design

Question 3

A poorly normalized database can lead to:

A)Difficulties inserting data
B)
Difficulties updating data
C)
Difficulties deleting data
D) All of these

Answer 3

D) All of these

Question 4

Which of the following are important to consider when choosing a database management system?
A) Compatibility with your software and hardware
B) Hardware and software requirements
C) Familiarity and expertise of staff
D) All of these

Answer 4

D) All of these