Question 1

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)  data generation 
C)  data definition 
D)  data administration 
A)  data manipulation 
B)  data generation 
C)  data definition 
D)  data administration

Question 2

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 3

Which of the following approaches to set up a distributed database management system (DDBMS) combines the fragmentation approach and the replication approach?

Accepted Answer

A)  The optimization approach 
B)  The allocation approach 
C)  The encapsulation approach 
D)  The normalization approach 
A)  The optimization approach 
B)  The allocation approach 
C)  The encapsulation approach 
D)  The normalization approach

Question 4

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 
E)  Select 
A)  sequential access file structure 
B)  random access file structure 
C)  indexed access file structure 
D)  direct access file structure 
E)  Select

Question 5

When using query by example (QBE) in the data manipulation component of a database management system (DBMS), the _____ is used when all 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 6

In a relational database model, a(n) _____ searches data in a table and retrieves records based on certain criteria.

Accepted Answer

A)  insert operation 
B)  join operation 
C)  find operation 
D)  select operation 
A)  insert operation 
B)  join operation 
C)  find operation 
D)  select operation

Question 7

__________, used in object-oriented databases, refers to new objects being created faster and more easily by entering new data in attributes.

Accepted Answer

A)  Inheritance 
B)  Encapsulation 
C)  Fragmentation 
D)  Counterbalance 
E)  Select 
A)  Inheritance 
B)  Encapsulation 
C)  Fragmentation 
D)  Counterbalance 
E)  Select

Question 8

Which of the following statements is true of a database?

Accepted Answer

A)  It allows more than one program to use the same data. 
B)  It comprises data that cannot be linked. 
C)  It consists of a segregated set of files. 
D)  It is a crucial tool for managing overseas subsidiaries. 
A)  It allows more than one program to use the same data. 
B)  It comprises data that cannot be linked. 
C)  It consists of a segregated set of files. 
D)  It is a crucial tool for managing overseas subsidiaries.

Question 9

In a(n) _____, nodes with the same parents are called twins or siblings.

Accepted Answer

A)  hierarchical model 
B)  network model 
C)  relational model 
D)  object-based model 
A)  hierarchical model 
B)  network model 
C)  relational model 
D)  object-based model

Question 10

The _____ component of a database management system (DBMS) is used for tasks such as backup and recovery, security, and change management.

Accepted Answer

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

Question 11

The use of the OR operator in a query form, when using query by example (QBE), means that only one of the conditions must be met.

Accepted Answer

A) True 
 B)False

Question 12

In contrast to the query languages used to interact with a relational database, interaction with an object-oriented database takes places via methods, which are called by sending a message to an object.

Accepted Answer

A) True 
 B)False

Question 13

Labor and population statistics are examples of sources for internal data that are accessed by a database.

Accepted Answer

A) True 
 B)False

Question 14

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 15

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

Accepted Answer

A)  Tax records 
B)  Sales records 
C)  Distribution networks 
D)  Economic indicators 
A)  Tax records 
B)  Sales records 
C)  Distribution networks 
D)  Economic indicators

Question 16

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 17

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 18

A _____ acts as an interface to a database, retrieving data for users and allowing users to enter data in the database.

Accepted Answer

A)  data-driven Web site 
B)  flat Web page 
C)  stationary Web page 
D)  static Web site 
A)  data-driven Web site 
B)  flat Web page 
C)  stationary Web page 
D)  static Web site

Question 19

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 20

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

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

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

Which of the following approaches to set up a distributed database management system (DDBMS) combines the fragmentation approach and the replication approach?

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

When using query by example (QBE) in the data manipulation component of a database management system (DBMS), the _____ is used when all the conditions in the QBE form must be met.

In a relational database model, a(n) _____ searches data in a table and retrieves records based on certain criteria.

__________, used in object-oriented databases, refers to new objects being created faster and more easily by entering new data in attributes.

Which of the following statements is true of a database?

In a(n) _____, nodes with the same parents are called twins or siblings.

The _____ component of a database management system (DBMS) is used for tasks such as backup and recovery, security, and change management.

The use of the OR operator in a query form, when using query by example (QBE), means that only one of the conditions must be met.

In contrast to the query languages used to interact with a relational database, interaction with an object-oriented database takes places via methods, which are called by sending a message to an object.

Labor and population statistics are examples of sources for internal data that are accessed by a database.

Data warehouses are sometimes called hypercubes because they _____.

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

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?

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

A _____ acts as an interface to a database, retrieving data for users and allowing users to enter data in the database.

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.

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

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

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

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

Which of the following approaches to set up a distributed database management system (DDBMS) combines the fragmentation approach and the replication approach?

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

When using query by example (QBE) in the data manipulation component of a database management system (DBMS), the _____ is used when all the conditions in the QBE form must be met.

In a relational database model, a(n) _____ searches data in a table and retrieves records based on certain criteria.

__________, used in object-oriented databases, refers to new objects being created faster and more easily by entering new data in attributes.

Which of the following statements is true of a database?

In a(n) _____, nodes with the same parents are called twins or siblings.

The _____ component of a database management system (DBMS) is used for tasks such as backup and recovery, security, and change management.

The use of the OR operator in a query form, when using query by example (QBE), means that only one of the conditions must be met.

In contrast to the query languages used to interact with a relational database, interaction with an object-oriented database takes places via methods, which are called by sending a message to an object.

Labor and population statistics are examples of sources for internal data that are accessed by a database.

Data warehouses are sometimes called hypercubes because they _____.

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

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?

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

A _____ acts as an interface to a database, retrieving data for users and allowing users to enter data in the database.

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.

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

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