Database Design Quiz 25 Questions

Question 1
A highly organized collection of data is a database management system.

True
False

Question 2
Financial data residing in a database is not a corporate resource.

True
False

Question 3
Modality is the maximum number of entity occurrences involved in a relationship.

True
False

Question 4
Unary relationships contain one entity type.

True
False

Question 5
In a database, if there is more than one candidate key one MUST be identified as a primary key.

True
False

Question 6
A concurrency problem is defined as multiple data sets stored in the database.

True
False

Question 7
The most significant problem with data redundancy in a database is data integrity.

True
False

Question 8
Data redundancy can result in requiring unnecessary storage space for the database.

True
False

Question 9
 

Many-many relationships should be converted to associative entities on an Entity-Relationship diagram.

 True

 False

Question 10
 

There are two modes of data access known as sequential and direct access.

 True

 False

Question 11
 

Data within a database is typically controlled and manipulated by:

 
  A.
MY SQL Workbench
 
  B.
Database Management Software
 
  C.
MS Word
 
  D.
MS Excel
 

Question 12
 

A unique identifier of an entity is ____

 
  A.
Relationship
 
  B.
Cardinality
 
  C.
Attribute
 
  D.
Binary
 

Question 13
 

In an M-M relationship, the combination of or the association between two entities is known as ____

 
  A.
Cardinality
 
  B.
Modality
 
  C.
Associative entity
 
  D.
Intersection data
 

Question 14
 

A ________ relationship associates occurrences of an entity type with other occurrences of the same entity type.

 
  A.
Binary
 
  B.
Tertiary
 
  C.
Unary
 
  D.
Secondary
 

Question 15
 

How many entity types are involved in a tertiary relationship?

 
  A.
1
 
  B.
2
 
  C.
3
 
  D.
4
 

Question 16
 

The means by which an analyst records, documents, and diagrams the business environment is known as ________.

 
  A.
Relationship Identification
 
  B.
Data Association
 
  C.
Data Analysis
 
  D.
Data modeling
 

Question 17

In a DBMS, Referential Integrity contains three rules which are:

 
  A.
Restrict
 
  B.
Cascade
 
  C.
Set-to-null
 
  D.
Read
 
  E.
All of the above
 
  F.
A, B, and C
 

Question 18
 

The process of arranging attributes of entities in a given business environment into database structures is known as:

 
  A.
Physical Database design
 
  B.
Database structuring
 
  C.
Logical Database design
 
  D.
Relationship mapping
 

Question 19
 

Each row of a database is known as a ______

 
  A.
File
 
  B.
Field
 
  C.
Entity
 
  D.
Record
 

Question 20
 

An entity’s attribute in a database management system is referred to as a ________.

 
  A.
Record
 
  B.
Relationship
 
  C.
Field
 
  D.
Row
 

Question 21
 

A foreign key is defined as _________.

 
  A.
The key attribute of an entity
 
  B.
An identifier of the relationship
 
  C.
Primary key of an entity
 
  D.
Primary key of a relation that appears in another relation
 

Question 22

An attribute or field that uniquely appears in every row of the relation is known as ____.

 
  A.
Key field
 
  B.
Primary Key
 
  C.
Foreign Key
 
  D.
Intersection ID
 

Question 23

Each table column in a database entity is commonly known as a ____________.

 
  A.
Record
 
  B.
Relationship
 
  C.
Field
 
  D.
Primary Key
 

Question 24

The purpose of a database is to _____________.

 
  A.
Eliminate redundancy
 
  B.
Centralize data
 
  C.
Integrate data logically
 
  D.
All of the above
 
  E.
None of the above
 

Question 25

In your own words write the definition of referential integrity.