Exam 5: Data Resource Management

According to one database pioneer, the future development of databases and data warehouses will depend on _______________.

Database _______________ involves using transaction processing systems and other tools to add, delete, update, and correct the data in a database.

SQL is an acronym for _______________. It is an international standard query language found in many DBMS packages.

In file processing systems, application programs typically contain references to the specific format of the stored data.

Boolean logic was developed during the latter part of the 1900s.

A group of related records is a data file, or a _______________.

Large organizations usually place control of enterprise-wide database development in the hands of _______________.

Boolean logic consists of three logical operators: AND, OR, and _______________.

_______________ relationship diagrams are used to model the relationships among the many entities involved in business processes.

A large database system is often distributed into smaller databases based on some logical relationship between the data and the location of the databases.

A group of related records is a data file, or a _______________.

A _______________ is an overall logical view of the relationships among the data elements in a database.

A _______________ is an overall logical view of the relationships needed to support specific end-user application programs that will access the database.

The tables in a relational database are flat files, which have rows and columns. Each row presents a single _______________ in the file.

All of the fields used to describe the attributes of an entity are grouped to form a _______________.

Which of the following is true of data marts?

In file processing systems, it was easy for data elements, such as stock numbers and customer addresses, to be defined differently by different end users and applications.

In the relational database model, all data elements within the database are viewed as being stored in the form of simple, two-dimensional tables, sometimes referred to as _______________.

A weakness in the hierarchical model is that it cannot handle _______________ data relationships.

In a traditional file processing approach, each business application is designed to use one or more specialized data files containing only specific types of data records.