Question 1

Early mainframe DBMS packages used the _______________ structure, in which all records are dependent and arranged in multilevel structures, consisting of one root record and any number of subordinate levels.

Accepted Answer

A)  network 
B)  relational 
C)  hierarchical 
D)  object-oriented

Question 2

The _______________ model is the most widely used database structure today.

Accepted Answer

A)  network 
B)  object-oriented 
C)  relational 
D)  hierarchical

Question 3

To solve the problems encountered with the file processing approach, the _______________ management approach was conceived. It is the foundation of modern methods of managing organizational data.

Accepted Answer

The answer of To solve the problems encountered with the...

Question 4

In the relational database model, all data elements within the database are viewed as being stored in the form of simple two-dimensional tables, sometimes referred to as _______________.

Accepted Answer

A)  records 
B)  rows 
C)  columns 
D)  relations

Question 5

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

Accepted Answer

The answer of The tables in a relational database are...

Question 6

In _______________, the data in a data warehouse are analyzed to reveal hidden patterns and trends in historical business activity.

Accepted Answer

The answer of In _______________, the data in a data...

Question 7

The _______________ operation is used to create a subset of the columns contained in the temporary tables created by the select and join operations.

Accepted Answer

A)  link 
B)  relate 
C)  project 
D)  merge

Question 8

According to the textbook case, the innovation of the open-source product Hadoop is _______________.

Accepted Answer

A)  that it has not been sued by Google 
B)  that it actually works 
C)  that it has no proprietary predecessor 
D)  its algorithms run contrary to contemporary mathematics

Question 9

Data models represent _______________ views of the data and relationships of the database.

Accepted Answer

The answer of Data models represent _______________ views of the...

Question 10

A database with a network data structure can easily handle a many-to-many data relationship, whereas a hierarchical model cannot.

Accepted Answer

A) True 
 B)False

Question 11

The duplication process basically identifies one database as a _______________ and then duplicates that database at a prescribed time so that each distributed location has the same data.

Accepted Answer

The answer of The duplication process basically identifies one database...

Question 12

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

Accepted Answer

A)  object-oriented 
B)  relational 
C)  network 
D)  hierarchical

Question 13

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

Accepted Answer

A)  field 
B)  record 
C)  file 
D)  relation

Question 14

In a(n) _______________ database structure, all of the relationships among records are one-to-many, because each data element is related to only one element above it.

Accepted Answer

A)  hierarchical 
B)  relational 
C)  network 
D)  object-oriented

Question 15

_______________ are used to model the relationships among the many entities involved in business processes.

Accepted Answer

A)  Entity-relationship diagrams 
B)  Data-flow diagrams 
C)  Schema diagrams 
D)  Subschema diagrams

Question 16

A(n) _______________ is an integrated collection of logically related data elements.

Accepted Answer

A)  master file 
B)  program base 
C)  database 
D)  integrated file

Question 17

_______________ databases have become the most popular structure for analytical databases that support online analytical process (OLAP) applications, in which fast answers to complex queries are expected.

Accepted Answer

A)  Relational 
B)  Object-oriented 
C)  Inter-relational 
D)  Multidimensional

Question 18

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

Accepted Answer

A)  Data in operational databases is ever changing; data in data warehouses is static 
B)  Data in operational databases is static; data in data warehouses is ever changing 
C)  Data in operational databases can be cataloged; data in data warehouses cannot 
D)  None of the choices are correct.

Question 19

The _______________ database structure is considered one of the key technologies of a new generation of Web-based applications.

Accepted Answer

A)  hierarchical 
B)  relational 
C)  object-oriented 
D)  multidimensional

Question 20

A _______________ is an integrated collection of logically related data elements.

Accepted Answer

The answer of A _______________ is an integrated collection of...

Exam 5: Data Resource Management