An image file stores past transactions that may no longer be needed, is usually stored offline, and can be accessed on an as-needed basis.
A -
True
B -
False
2-
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.
A -
True
B -
False
3-
SQL, the standard language for accessing data in tables in relational databases, stands for Standard Query Language.
A -
True
B -
False
4-
An object-oriented database is mainly used to support multimedia applications or complex systems involving graphics, video and sound.
A -
True
B -
False
5-
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.
A -
True
B -
False
6-
The leader in the database market and a system that can handle diverse data needs is the relational DBMS.
A -
True
B -
False
7-
The normalization process is performed primarily to increase the database's storage efficiency.
A -
True
B -
False
8-
The most efficient tables in a relational database in terms of storage space have redundant data and few null values.
A -
True
B -
False
9-
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.
A -
True
B -
False
10-
A method for improving data access that involves physically arranging the records on the storage medium is called clustering.
