FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Database Systems and Applications

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

A database administrator (DBA) must have a clear understanding of the fundamental business of an organization, be proficient in the use of selected database management systems, and stay abreast of emerging technologies and new design approaches.

Correct Answer

verified

Show Answer

Question 2

Short Answer

Review LaterAdd Note

Review Later

A(n) _____ is a diagram of entities and their relationships.

Correct Answer

verified

Show Answer

Question 3

Short Answer

Review LaterAdd Note

A(n) ______ is an individual responsible for defining and implementing consistent principles for a variety of data issues.

A(n) ______ is an individual who is expected to have a clear understanding of the fundamental business of an organization, be proficient in the use of selected database management systems, and stay abreast of emerging technologies and new design approaches.

The smallest piece of data used by a computer is a(n) _____.

A data warehouse stores historical data that has been extracted from operational systems and external sources.

To use the database approach to data management, no additional software is required.

The _____ model has become the most popular database model.

A collection of fields all related to a single object, activity, or individual is a(n) _____.

_____ is a special-purpose programming language for accessing and manipulating data stored in a relational database.

_____ is a method of dealing with a situation in which two or more users or applications need to access the same record at the same time.

A _____ is a description that involves "telling" the database management system (DBMS) the logical and physical structure of the data and the relationships among the data for each user.

A database administrator is an important nontechnical position responsible for defining and implementing consistent principles for a variety of data issues, including setting data standards and data definitions that apply across all the databases in an organization.

When organizing a database, one of the key considerations includes determining who will have access to the collected data.

The position of a _____ is a nontechnical position responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization.

In the context of relational database model, projecting involves eliminating columns in a table.

One of the final steps in installing and using a large database involves "telling" the database management system (DBMS) the logical and physical structure of the data and the relationships among the data for each user.

A database management system (DBMS) serves as an interface between an application program and a database.

Online analytical processing involves the automated discovery of patterns and relationships in a data warehouse.

The specific value of an attribute is called a data entity.