Question 1

For each database, there:

Accepted Answer

A)  is only one physical view of data. 
B)  are only two logical views of data. 
C)  are multiple physical views of data. 
D)  is only one logical view of data. 
A)  is only one physical view of data. 
B)  are only two logical views of data. 
C)  are multiple physical views of data. 
D)  is only one logical view of data.

Question 2

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

Accepted Answer

A)  database engine 
B)  data-driven site 
C)  static site 
D)  database mine 
A)  database engine 
B)  data-driven site 
C)  static site 
D)  database mine

Question 3

Which of the following components of a data model describes methods and calculations that can be performed on data, such as updating and querying data?

Accepted Answer

A)  Data structure 
B)  Operations 
C)  Integrity rules 
D)  File structure 
A)  Data structure 
B)  Operations 
C)  Integrity rules 
D)  File structure

Question 4

Which of the following file structures is similar to a book index that lists page numbers where certain topics can be found?

Accepted Answer

A)  The indexed sequential access method 
B)  The indexed network access structure 
C)  The indexed random access file structure 
D)  The indexed hierarchical access method 
A)  The indexed sequential access method 
B)  The indexed network access structure 
C)  The indexed random access file structure 
D)  The indexed hierarchical access method

Question 5

In a(n) _____, records in files are organized and processed in numerical order. ​

Accepted Answer

A)  sequential access file structure 
B)  random access file structure 
C)  indexed access file structure 
D)  direct access file structure 
A)  sequential access file structure 
B)  random access file structure 
C)  indexed access file structure 
D)  direct access file structure

Question 6

Explain how information in a database is observed through the physical view and the logical view.

Accepted Answer

Answers will vary.Before designing a dat

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Data in a database is used for analytical purposes, whereas data in a data warehouse is used for capturing and managing transactions.

Accepted Answer

A) True 
 B)False

Question 9

Discuss how data was stored in flat files in the past. Explain the disadvantages associated with the flat file organization.

Accepted Answer

Answers will vary.In the past, data was

Question 10

The _____ method for accessing files is effective when a large number of records are processed less frequently, perhaps on a quarterly or yearly basis.

Accepted Answer

A)  sequential access file structure 
B)  random access file structure 
C)  indexed sequential access 
D)  physical view access 
A)  sequential access file structure 
B)  random access file structure 
C)  indexed sequential access 
D)  physical view access

Question 11

In the context of the operators used in a query by example (QBE) form, the _____ is used when only one of the conditions in the QBE form must be met.

Accepted Answer

A)  NOT operator 
B)  AND operator 
C)  OR operator 
D)  NOR operator 
A)  NOT operator 
B)  AND operator 
C)  OR operator 
D)  NOR operator

Question 12

Briefly explain the responsibilities of a database administrator (DBA).

Accepted Answer

Answers will vary.A DBA's responsibiliti

Question 13

A database administrator (DBA) is responsible for _____.

Accepted Answer

A)  developing recovery procedures in case data is lost or corrupted 
B)  keeping an organization's computer network up to date 
C)  writing computer programs that allow a system to perform a specific task 
D)  designing and implementing an organization's information systems 
A)  developing recovery procedures in case data is lost or corrupted 
B)  keeping an organization's computer network up to date 
C)  writing computer programs that allow a system to perform a specific task 
D)  designing and implementing an organization's information systems

Question 14

The advantage of the _____is that both sequential and random access can be used to access records, depending on the number being accessed. ​

Accepted Answer

A)  indexed sequential access method 
B)  progressive access method 
C)  direct random access method 
D)  random-serialized access method 
A)  indexed sequential access method 
B)  progressive access method 
C)  direct random access method 
D)  random-serialized access method

Question 15

The variety dimension of big data refers to the combination of _____.

Accepted Answer

A)  data warehouses and data marts 
B)  object-oriented data models and relational data models 
C)  structured data and unstructured data 
D)  data definition and data manipulation 
A)  data warehouses and data marts 
B)  object-oriented data models and relational data models 
C)  structured data and unstructured data 
D)  data definition and data manipulation

Question 16

In the context of the input component of a data warehouse, _____ collect, integrate, and process data that can be used by all functional areas in an organization.

Accepted Answer

A)  online analytical processing systems 
B)  online transaction management systems 
C)  enterprise resource planning systems 
D)  data mining analysis systems 
A)  online analytical processing systems 
B)  online transaction management systems 
C)  enterprise resource planning systems 
D)  data mining analysis systems

Question 17

In object-oriented databases, grouping objects along with their attributes and methods into a class is called _____. ​

Accepted Answer

A)  encapsulation 
B)  fragmentation 
C)  allocation 
D)  optimization 
A)  encapsulation 
B)  fragmentation 
C)  allocation 
D)  optimization

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

In the context of the types of data in a database, which of the following is a source of external data?

Accepted Answer

A)  Tax records 
B)  Sales records 
C)  Transaction records 
D)  Personnel records 
A)  Tax records 
B)  Sales records 
C)  Transaction records 
D)  Personnel records

Question 20

Briefly explain the role of business analytics (BA) in decision making and compare it to business intelligence (BI).

Accepted Answer

Answers will vary.BA uses data and stati

For each database, there:

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

Which of the following components of a data model describes methods and calculations that can be performed on data, such as updating and querying data?

Which of the following file structures is similar to a book index that lists page numbers where certain topics can be found?

In a(n) _____, records in files are organized and processed in numerical order.

Explain how information in a database is observed through the physical view and the logical view.

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

Data in a database is used for analytical purposes, whereas data in a data warehouse is used for capturing and managing transactions.

Discuss how data was stored in flat files in the past. Explain the disadvantages associated with the flat file organization.

The _____ method for accessing files is effective when a large number of records are processed less frequently, perhaps on a quarterly or yearly basis.

In the context of the operators used in a query by example (QBE) form, the _____ is used when only one of the conditions in the QBE form must be met.

Briefly explain the responsibilities of a database administrator (DBA).

A database administrator (DBA) is responsible for _____.

The advantage of the _____is that both sequential and random access can be used to access records, depending on the number being accessed.

The variety dimension of big data refers to the combination of _____.

In the context of the input component of a data warehouse, _____ collect, integrate, and process data that can be used by all functional areas in an organization.

In object-oriented databases, grouping objects along with their attributes and methods into a class is called _____.

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

In the context of the types of data in a database, which of the following is a source of external data?

Briefly explain the role of business analytics (BA) in decision making and compare it to business intelligence (BI).

Information Systems: An Overview

Computers: The Machines Behind Computing

Personal, Legal, Ethical and Organizational Issues of Information Systems

Protecting Information Resources

Data Communication

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

For each database, there:

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

Which of the following components of a data model describes methods and calculations that can be performed on data, such as updating and querying data?

Which of the following file structures is similar to a book index that lists page numbers where certain topics can be found?

In a(n) _____, records in files are organized and processed in numerical order. ​

Explain how information in a database is observed through the physical view and the logical view.

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

Data in a database is used for analytical purposes, whereas data in a data warehouse is used for capturing and managing transactions.

Discuss how data was stored in flat files in the past. Explain the disadvantages associated with the flat file organization.

The _____ method for accessing files is effective when a large number of records are processed less frequently, perhaps on a quarterly or yearly basis.

In the context of the operators used in a query by example (QBE) form, the _____ is used when only one of the conditions in the QBE form must be met.

Briefly explain the responsibilities of a database administrator (DBA).

A database administrator (DBA) is responsible for _____.

The advantage of the _____is that both sequential and random access can be used to access records, depending on the number being accessed. ​

The variety dimension of big data refers to the combination of _____.

In the context of the input component of a data warehouse, _____ collect, integrate, and process data that can be used by all functional areas in an organization.

In object-oriented databases, grouping objects along with their attributes and methods into a class is called _____. ​

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

In the context of the types of data in a database, which of the following is a source of external data?

Briefly explain the role of business analytics (BA) in decision making and compare it to business intelligence (BI).

Information Systems: An Overview

Computers: The Machines Behind Computing

Personal, Legal, Ethical and Organizational Issues of Information Systems

Protecting Information Resources

Data Communication

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

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

In a(n) _____, records in files are organized and processed in numerical order.

The advantage of the _____is that both sequential and random access can be used to access records, depending on the number being accessed.

In object-oriented databases, grouping objects along with their attributes and methods into a class is called _____.