Question 1

In the relational database model, each row of a table represents a(n) _____.

Accepted Answer

The answer of In the relational database model, each row...

Question 2

The _____ model has become the most popular database model.

Accepted Answer

The answer of The _____ model has become the most...

Question 3

In the context of a database management system (DBMS), a(n) _____ interacts with other programs or applications and only indirectly interacts with people or users.

Accepted Answer

The answer of In the context of a database management...

Question 4

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

Accepted Answer

The answer of A description that tells the database management...

Question 5

A(n) _____ is designed to store and retrieve data in a manner that does not rigidly enforce the atomic conditions associated with the relational database model in order to provide faster performance and greater scalability.

Accepted Answer

The answer of A(n) _____ is designed to store and...

Question 6

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

Accepted Answer

The answer of A(n) _____ is a diagram of entities...

Question 7

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

Accepted Answer

The answer of In a relational database model, the range...

Question 8

A business intelligence _____ is a data visualization tool that displays the current status of the key performance indicators (KPIs) for an organization.

Accepted Answer

The answer of A business intelligence _____ is a data...

Question 9

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.

Accepted Answer

The answer of A(n) ______ is an individual who is...

Question 10

Data modeling done at the level of an entire enterprise is called _____.

Accepted Answer

The answer of Data modeling done at the level of...

Question 11

Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, MySQL, and Sybas are databases based on the _____ model.

Accepted Answer

The answer of Oracle, IBM DB2, Microsoft SQL Server, Microsoft...

Question 12

In a relational database model, _____ involves combining two or more tables.

Accepted Answer

The answer of In a relational database model, _____ involves...

Question 13

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

Accepted Answer

The answer of _____ is a method of dealing with...

Question 14

A(n) _____ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

Accepted Answer

The answer of A(n) _____ is a collection of instructions...

Question 15

______ use basic graphical symbols to show an organization of and relationships between data.

Accepted Answer

The answer of ______ use basic graphical symbols to show...

Question 16

_____ is the process of detecting and then correcting or deleting incomplete, incorrect, inaccurate, irrelevant records that reside in a database.

Accepted Answer

The answer of _____ is the process of detecting and...

Question 17

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

Accepted Answer

The answer of A(n) ______ is an individual responsible for...

Question 18

A(n) _____ is a database management system that stores the entire database in random access memory (RAM).

Accepted Answer

The answer of A(n) _____ is a database management system...

Question 19

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

Accepted Answer

The answer of A(n) _____ is a detailed description of...

Question 20

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

Accepted Answer

The answer of The _____ is a specific language, provided...

Quiz 5: Database Systems and Applications