Exam 9: Data Management Layer Design

To improve the access speed of a database, similar records in a table are stored together in primary key order. This optimizing access speed process is called _____.

Most NoSQL data stores were created to address problems associated with storing large amounts of distributed data in __________.

SQL, the standard language for accessing data in tables in relational databases, stands for Standard Query Language.

The process of adding redundancy back into a physical data model is known as denormalization.

Denormalization is performed before the object storage is optimized.

A method for improving data access that involves physically arranging the records on the storage medium is called clustering.

An image file stores past transactions that may no longer be needed, is usually stored off-line, and can be accessed on an as-needed basis.

A(n) _____ is less expensive and easier for novice users to use, but it does not have the features that are necessary to support mission-critical or large scale systems.

When looking for a specific object of interest, on average 25% of a sequential access file will have to be searched in order to find that object.

Why would an analyst both normalize and denormalize the design of the data management layer?

If the data model does not have any repeating fields it is in _____.

Mapping from the problem domain to the data management objects in an RDBMS format is a straightforward one-to-one mapping.

Explain the term Indexing.