Question 1

A relational database is less dependent on the hardware and its particular operating system.

Accepted Answer

A) True 
 B)False

Question 2

The process of sequentially executing operations on each record in a large batch is called data integration.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following technologies is better equipped than relational databases to handle big data?

Accepted Answer

A) MySQL 
B) Hadoop 
C) ETL 
D) SQL Server 
A) MySQL 
B) Hadoop 
C) ETL 
D) SQL Server

Question 4

How does metadata differ for different types of information?

Accepted Answer

Metadata is data about data, and it clar

Question 5

The data collected by online pop-up surveys can be considered to be high-quality data.

Accepted Answer

A) True 
 B)False

Question 6

What is the main drawback of using unstructured information?

Accepted Answer

A) It hinders creativity. 
B) It is expensive to maintain. 
C) It cannot be used to store numerical information. 
D) It makes retrieving information very difficult. 
A) It hinders creativity. 
B) It is expensive to maintain. 
C) It cannot be used to store numerical information. 
D) It makes retrieving information very difficult.

Question 7

Which database architecture is popularly used for organizing complex data types such as graphics and multimedia?

Accepted Answer

A) stratified database 
B) object-oriented database 
C) network database 
D) relational database 
A) stratified database 
B) object-oriented database 
C) network database 
D) relational database

Question 8

Database architecture that has multidimensional data grouped in logical dimensions, such as sales by product, city, region, and country, is called ________.

Accepted Answer

A) data cubes 
B) operational database 
C) data warehouse appliance 
D) data mining 
A) data cubes 
B) operational database 
C) data warehouse appliance 
D) data mining

Question 9

Which of the following ensures that there will be minimum redundancy in a relational database?

Accepted Answer

A) foreign keys 
B) autonumbers 
C) functionally independent attributes 
D) one to one relationships 
A) foreign keys 
B) autonumbers 
C) functionally independent attributes 
D) one to one relationships

Question 10

Which of the following database architectures works well for one-to-many relationships, but is not effective with many-to-many relationships?

Accepted Answer

A) network database 
B) hierarchical database 
C) object-oriented database 
D) cluster database 
A) network database 
B) hierarchical database 
C) object-oriented database 
D) cluster database

Question 11

An organization's data warehouse contains information drawn from multiple sources that can be used for analysis, intelligence gathering, and strategic planning.

Accepted Answer

A) True 
 B)False

Question 12

In an organization, each employee might work for one or more projects, as well as for different managers. In such a case, the best approach by a database manager would be to create multiple records for the employee.

Accepted Answer

A) True 
 B)False

Question 13

One of the disadvantages of interactive voice response (IVR)is that it cannot handle massive call volumes.

Accepted Answer

A) True 
 B)False

Question 14

A central data repository containing information drawn from multiple sources that can be used for analysis, intelligence gathering, and strategic planning is called a ________.

Accepted Answer

A) data warehouse 
B) data dictionary 
C) data model 
D) database shard 
A) data warehouse 
B) data dictionary 
C) data model 
D) database shard

Question 15

Databases in which people outside the enterprise enter and manage most of the records are termed as ________.

Accepted Answer

A) outsourced databases 
B) external databases 
C) data warehouses 
D) databases without boundaries 
A) outsourced databases 
B) external databases 
C) data warehouses 
D) databases without boundaries

Question 16

________ refers to collections of data that are so enormous in size, so varied in content, and so fast to accumulate that they are difficult to store and analyze using traditional approaches.

Accepted Answer

A) Big data 
B) Data cube 
C) Meta data 
D) Shard 
A) Big data 
B) Data cube 
C) Meta data 
D) Shard

Question 17

In a table, a field can contain either numeric data or text but not a combination of both.

Accepted Answer

A) True 
 B)False

Question 18

An attribute of an entity in a table is called a ________.

Accepted Answer

A) record 
B) subset 
C) field 
D) character 
A) record 
B) subset 
C) field 
D) character

Question 19

Which of the following is a disadvantage of using shadow systems?

Accepted Answer

A) longer time to retrieve information 
B) lack of stability and security 
C) requirement of tools that are not easily available 
D) lack of documentation and support 
A) longer time to retrieve information 
B) lack of stability and security 
C) requirement of tools that are not easily available 
D) lack of documentation and support

Question 20

Which of the following databases resembles an organizational chart?

Accepted Answer

A) network database 
B) hierarchical database 
C) stratified database 
D) cluster database 
A) network database 
B) hierarchical database 
C) stratified database 
D) cluster database

A relational database is less dependent on the hardware and its particular operating system.

The process of sequentially executing operations on each record in a large batch is called data integration.

Which of the following technologies is better equipped than relational databases to handle big data?

How does metadata differ for different types of information?

The data collected by online pop-up surveys can be considered to be high-quality data.

What is the main drawback of using unstructured information?

Which database architecture is popularly used for organizing complex data types such as graphics and multimedia?

Database architecture that has multidimensional data grouped in logical dimensions, such as sales by product, city, region, and country, is called ________.

Which of the following ensures that there will be minimum redundancy in a relational database?

Which of the following database architectures works well for one-to-many relationships, but is not effective with many-to-many relationships?

An organization's data warehouse contains information drawn from multiple sources that can be used for analysis, intelligence gathering, and strategic planning.

In an organization, each employee might work for one or more projects, as well as for different managers. In such a case, the best approach by a database manager would be to create multiple records for the employee.

One of the disadvantages of interactive voice response (IVR)is that it cannot handle massive call volumes.

A central data repository containing information drawn from multiple sources that can be used for analysis, intelligence gathering, and strategic planning is called a ________.

Databases in which people outside the enterprise enter and manage most of the records are termed as ________.

________ refers to collections of data that are so enormous in size, so varied in content, and so fast to accumulate that they are difficult to store and analyze using traditional approaches.

In a table, a field can contain either numeric data or text but not a combination of both.

An attribute of an entity in a table is called a ________.

Which of the following is a disadvantage of using shadow systems?

Which of the following databases resembles an organizational chart?

Information Systems and People

Information Systems and Strategy

Information and Communications Technologies: The Enterprise Architecture

Information Systems for the Enterprise

The Web, E-Commerce, and M-Commerce

Business Intelligence and Decision Making

Collaborating With Technology

Knowledge Management and E-Learning

Ethics, Privacy, and Security

Systems Development and Procurement

Project Management and Strategic Planning

Filters

Exam 4: Databases and Datawarehouses

A relational database is less dependent on the hardware and its particular operating system.

The process of sequentially executing operations on each record in a large batch is called data integration.

Which of the following technologies is better equipped than relational databases to handle big data?

How does metadata differ for different types of information?

The data collected by online pop-up surveys can be considered to be high-quality data.

What is the main drawback of using unstructured information?

Which database architecture is popularly used for organizing complex data types such as graphics and multimedia?

Database architecture that has multidimensional data grouped in logical dimensions, such as sales by product, city, region, and country, is called ________.

Which of the following ensures that there will be minimum redundancy in a relational database?

Which of the following database architectures works well for one-to-many relationships, but is not effective with many-to-many relationships?

An organization's data warehouse contains information drawn from multiple sources that can be used for analysis, intelligence gathering, and strategic planning.

In an organization, each employee might work for one or more projects, as well as for different managers. In such a case, the best approach by a database manager would be to create multiple records for the employee.

One of the disadvantages of interactive voice response (IVR)is that it cannot handle massive call volumes.

A central data repository containing information drawn from multiple sources that can be used for analysis, intelligence gathering, and strategic planning is called a ________.

Databases in which people outside the enterprise enter and manage most of the records are termed as ________.

________ refers to collections of data that are so enormous in size, so varied in content, and so fast to accumulate that they are difficult to store and analyze using traditional approaches.

In a table, a field can contain either numeric data or text but not a combination of both.

An attribute of an entity in a table is called a ________.

Which of the following is a disadvantage of using shadow systems?

Which of the following databases resembles an organizational chart?

Information Systems and People

Information Systems and Strategy

Information and Communications Technologies: The Enterprise Architecture

Information Systems for the Enterprise

The Web, E-Commerce, and M-Commerce

Business Intelligence and Decision Making

Collaborating With Technology

Knowledge Management and E-Learning

Ethics, Privacy, and Security

Systems Development and Procurement

Project Management and Strategic Planning

Filters