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

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.

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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

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

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

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

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

The _____ model has become the most popular database model.

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

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

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.

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.

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

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

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.

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

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.

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

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.