Question 1

A(n) _____ is software for creating,storing,maintaining,and accessing database files.

Accepted Answer

database management system (DBMS)

Question 2

In a(n) _____ data model,each record can have multiple parent and child records.

Accepted Answer

A)  network 
B)  hierarchical 
C)  operations 
D)  relational 
A)  network 
B)  hierarchical 
C)  operations 
D)  relational A

Question 3

The use of OR operator means that only one of the conditions in an SQL statement must be met.

Accepted Answer

A) True 
 B)False  True

Question 4

Although a database can consist of only a single file,it is usually a group of files.

Accepted Answer

A) True 
 B)False

Question 5

A _____ is usually a smaller version of a data warehouse,used by a single department or function.

Accepted Answer

A)  data domain 
B)  data mine 
C)  data dictionary 
D)  data mart 
A)  data domain 
B)  data mine 
C)  data dictionary 
D)  data mart

Question 6

As compared to data warehouses,consolidating information from different departments or functional areas is easier in data marts.

Accepted Answer

A) True 
 B)False

Question 7

Data warehouses are sometimes called "hypercubes" because they_____.

Accepted Answer

A)  are function oriented 
B)  store multidimensional data 
C)  capture raw transaction data 
D)  manage transactions 
A)  are function oriented 
B)  store multidimensional data 
C)  capture raw transaction data 
D)  manage transactions

Question 8

The network data model is similar to the hierarchical data model because records are organized in the same way.

Accepted Answer

A) True 
 B)False

Question 9

Describe the features and benefits of an object-oriented database.

Accepted Answer

Like object-oriented programming,object-

Question 10

List and describe the features of data in a data warehouse in contrast to data in a database.

Accepted Answer

Data in a data warehouse is described as

Question 11

The _____ component of a database management system (DBMS) is used to add,delete,modify,and retrieve records from a database.

Accepted Answer

A)  data manipulation 
B)  application generation 
C)  data definition 
D)  data administration 
A)  data manipulation 
B)  application generation 
C)  data definition 
D)  data administration

Question 12

A database engine converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS).

Accepted Answer

A) True 
 B)False

Question 13

In a relational model,the rows are called attributes and the columns are called tuples.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following statements is true of big data?

Accepted Answer

A)  It is a consequence of geometric decay of data in data warehouses. 
B)  It can be efficiently processed and managed by conventional computing methods. 
C)  Its three dimensions are value, density, and uniformity. 
D)  It is a result of exponential growth of data in both public and private organizations. 
A)  It is a consequence of geometric decay of data in data warehouses. 
B)  It can be efficiently processed and managed by conventional computing methods. 
C)  Its three dimensions are value, density, and uniformity. 
D)  It is a result of exponential growth of data in both public and private organizations.

Question 15

With the indexed sequential access method (ISAM),records cannot be accessed randomly.

Accepted Answer

A) True 
 B)False

Question 16

The indexed sequential access method (ISAM) is slow and becomes increasingly useful as the number of records becomes larger.

Accepted Answer

A) True 
 B)False

Question 17

What are some of the sources of external data?

Accepted Answer

Some of the sources of external data are

Question 18

An advantage that a database has over a flat file system is that more information can be generated from the same data.

Accepted Answer

A) True 
 B)False

Question 19

_____ is information about data-its content,quality,condition,origin,and other characteristics.

Accepted Answer

A)  Metadata 
B)  Big data 
C)  Summary data 
D)  Raw data 
A)  Metadata 
B)  Big data 
C)  Summary data 
D)  Raw data

Question 20

What is the function of a distributed database management system (DDBMS)?

Accepted Answer

A distributed database managem

A(n) _____ is software for creating,storing,maintaining,and accessing database files.

In a(n) _____ data model,each record can have multiple parent and child records.

The use of OR operator means that only one of the conditions in an SQL statement must be met.

Although a database can consist of only a single file,it is usually a group of files.

A _____ is usually a smaller version of a data warehouse,used by a single department or function.

As compared to data warehouses,consolidating information from different departments or functional areas is easier in data marts.

Data warehouses are sometimes called "hypercubes" because they_____.

The network data model is similar to the hierarchical data model because records are organized in the same way.

Describe the features and benefits of an object-oriented database.

List and describe the features of data in a data warehouse in contrast to data in a database.

The _____ component of a database management system (DBMS) is used to add,delete,modify,and retrieve records from a database.

A database engine converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS).

In a relational model,the rows are called attributes and the columns are called tuples.

Which of the following statements is true of big data?

With the indexed sequential access method (ISAM),records cannot be accessed randomly.

The indexed sequential access method (ISAM) is slow and becomes increasingly useful as the number of records becomes larger.

What are some of the sources of external data?

An advantage that a database has over a flat file system is that more information can be generated from the same data.

_____ is information about data-its content,quality,condition,origin,and other characteristics.

What is the function of a distributed database management system (DDBMS)?

Information Systems: an Overview

Computers: the Machines Behind Computing

Personal,legal,ethical,and Organizational Issues of Information Systems

Protecting Information Resources

Data Communication: Delivering Information Anywhere and Anytime

The Internet,intranets,and Extranets

E-Commerce

Global Information Systems

Building Successful Information Systems

Enterprise Systems

Management Support Systems

Intelligent Information Systems

Emerging Trends,technologies,and Applications

Filters

Exam 3: Database Systems,data Warehouses,and Data Marts

A(n) _____ is software for creating,storing,maintaining,and accessing database files.

In a(n) _____ data model,each record can have multiple parent and child records.

The use of OR operator means that only one of the conditions in an SQL statement must be met.

Although a database can consist of only a single file,it is usually a group of files.

A _____ is usually a smaller version of a data warehouse,used by a single department or function.

As compared to data warehouses,consolidating information from different departments or functional areas is easier in data marts.

Data warehouses are sometimes called "hypercubes" because they_____.

The network data model is similar to the hierarchical data model because records are organized in the same way.

Describe the features and benefits of an object-oriented database.

List and describe the features of data in a data warehouse in contrast to data in a database.

The _____ component of a database management system (DBMS) is used to add,delete,modify,and retrieve records from a database.

A database engine converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS).

In a relational model,the rows are called attributes and the columns are called tuples.

Which of the following statements is true of big data?

With the indexed sequential access method (ISAM),records cannot be accessed randomly.

The indexed sequential access method (ISAM) is slow and becomes increasingly useful as the number of records becomes larger.

What are some of the sources of external data?

An advantage that a database has over a flat file system is that more information can be generated from the same data.

_____ is information about data-its content,quality,condition,origin,and other characteristics.

What is the function of a distributed database management system (DDBMS)?

Information Systems: an Overview

Computers: the Machines Behind Computing

Personal,legal,ethical,and Organizational Issues of Information Systems

Protecting Information Resources

Data Communication: Delivering Information Anywhere and Anytime

The Internet,intranets,and Extranets

E-Commerce

Global Information Systems

Building Successful Information Systems

Enterprise Systems

Management Support Systems

Intelligent Information Systems

Emerging Trends,technologies,and Applications

Filters