FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Database Systems,data Centers,and Business Intelligence

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

_____ databases rely upon concurrency control by locking database records to ensure that other transactions do not modify the database until the first transaction succeeds or fails,and as a result,can suffer from slow performance.

A) Query by Example (QBE)
B) Access
C) Structured Query Language (SQL)
D) Data manipulation language (DML)

E) B) and C)
F) A) and C)

Correct Answer

verified

Show Answer

Question 22

Short Answer

Review LaterAdd Note

Review Later

The _____ is a simple but highly useful way to organize data into collections of two-dimensional tables called relations.

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

One of the primary advantages of a relational database is that it reduces data redundancy and allows data to be organized more logically.

A database installed on a personal computer is typically meant for a single user.

Small,midsize,and large businesses need _____ database management systems (DBMSs)to share information throughout the organization over a network.

In a relational database,_____ is the ability to combine two or more tables through common data attributes to form a new table with only the unique data attributes.

The _____ is a specific language,provided with a database management system (DBMS),which allows users to access and modify the data,to make queries,and to generate reports.

A(n)_____ is a detailed description of all data used in a database.

Briefly describe the hierarchy of data.

A data model is a diagram of data attributes and their relationships.

Which of the following statements is true of a database?

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

A(n) _____ is a basic building block of most information,consisting of upper-case letters,lowercase letters,numeric digits,or special symbols.

_____ is a data visualization technique in which data is represented as networks where the vertices are the individual data points and the edges are the connections among them.

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

Business intelligence is gained through industrial espionage and the gathering of this information often includes illegal or unethical means.

In a relational database model,the range of allowable values for a data attribute is called its _____.

A collection of fields about a specific object is a record.

Today,most organizations use the traditional approach to data management,where multiple information systems share a pool of related data.

_____ is one aspect of business intelligence and encompasses information about competitors and the ways that knowledge affects strategy,tactics,and operations.