Exam 5: Data Resource Management

The tables in a relational database are flat files, which have rows and columns. Each column represents a _______________.

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

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

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

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

All of the relationships between the data elements in a relationally organized database need to be specified when the database is created.

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

The network model can easily handle ad hoc requests for information, whereas the hierarchical model cannot.

Variable-length records contain:

Databases contain data elements that describe both entities and the _______________ among entities.

Which of the following is true of data in a data warehouse?

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

What type of databases are employees using when they access online data banks, whether those data banks are free or paid for through subscriptions?

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

Database management packages based on the _______________ model can link data elements from various tables to provide information to users.

Distributed databases can reside on network servers on the World Wide Web, on corporate intranets, or on corporate extranets.

All of the following contribute to problems when using a file management approach except:

According to the text, most data warehouses will run _______________ in a column format.

The object-oriented database model supports _______________. That is, new objects can be automatically created by replicating some or all of the characteristics of one or more parent objects.

A database of data definitions and specifications is called a metadata repository, or a _______________.