Exam 9: Data Management Layer Design

Key-value data stores is a type of NOSQL data stores, and they essentially provide a distributed index (primary key) to where a BLOB (binary, large object) is stored

When the analyst is evaluating a data model to ensure that all fields in a record depend fully on the entire primary key, the analyst is making sure that the data model conforms to the second normal form.

Which of the following is NOT a characteristic of current object-relational databases?

Explain the term denormalization.

The most efficient tables in a relational database in terms of storage space have no redundant data and very few null values because the presence of these suggest that space is being wasted, and more data to store means higher data storage hardware costs.

Look-up files store core information that is important to the business and to the application, and are usually kept for long periods of time with new records appended to the end of the file.

The applicability of NOSQL data stores is limited and they are NOT applicable to traditional business transaction processing systems.

A data model that does not contain repeating fields and that the data models leads to tables containing fields that are dependent on a whole primary key is in _____ normal form.

A master file holds information temporarily so that it can be used to update other master files.

An audit file contains information about how data changes over time; it records before and after images of data as it is altered so that it can be validated later.

What is the role of the following file types: master, look-up, transaction, audit, and history?

Information in a file's records that specifies the location of related records is called a marker.

It is difficult to find professionals with the necessary skill set for RDBMS.

The size of a database is determined by the _____.

The object persistence format that supports simple data types only is OODBMS.

Normalization is a process that applies a series of rules to a logical data model to determine how well the model is formed.

The normalization process is performed primarily to increase the database's storage efficiency.

The Relational DBMS only supports simple data types, but the Object Relational DBMS supports both simple and complex data types.

Finding a specific object in a sequential access file is relatively easy to do.

Describe the differences between Relational DB and NoSQL Data Store.