Exam 9: Data Management Layer Design

Most object-oriented programming languages support sequential and random access files.

A(n) _____ can support large volumes of data and support applications that run an entire company.

The size of a database is determined by the _____.

Nicole and her team of skillful systems analysts have been hired to create a database system for an educational software package that supports the study of medicine and the human body. A sample application will include a narrative exploration and graphical "tour" of the heart. As part of Nicole's team, the type of database that you would you recommend is a relational database.

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

Describe the differences between an ORDBMS and an OODBMS, and list the advantages of using an OODBMS over an OODBMS.

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 _____.

In order to reduce the number of joins that must be performed in a query and to increase the speed of data access, the data analyst will _____ the physical model.

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

A master file stores core information that is important to the business, is normally kept for long periods of time, and is regularly updated.

The accountants at the Sears store in a local city have noticed that the appliance department is regularly short when items sold are compared to sales. The accountants feel that something is wrong and these systems must be checked for accuracy. The audit file system will reveal if appliances may have been stolen.

The data stores that are described as NoSQL typically support SQL.

The Object Relational DBMS has all advantages from both the Relational DBMS and the Object-Oriented DBMS.

Which one in the following list is an example of NOSQL data store .

A mini-table that contains values from one or more columns in a table and the location of the values within the table is called a(n) _____.

A file that stores information on who, when, and how data was altered is an audit file.

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

What is the concept of referential integrity? Why is it important in databases?

Optimization is a process whereby a series of rules are applied to a logical data model to determine how well-formed it is; these rules help analysts identify entities that are not represented correctly.

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