Question 1

NoSQL technologies are used to manage sets of data that don't require the flexibility of tables and relations.

Accepted Answer

A) True 
 B)False

Question 2

Every record in a file should contain at least one key field.

Accepted Answer

A) True 
 B)False

Question 3

A DBMS makes the:

Accepted Answer

A) physical database available for different logical views. 
B) relational database available for different logical views. 
C) physical database available for different analytic views. 
D) relational database available for different analytic views. 
E) logical database available for different analytic views. 
A) physical database available for different logical views. 
B) relational database available for different logical views. 
C) physical database available for different analytic views. 
D) relational database available for different analytic views. 
E) logical database available for different analytic views.

Question 4

In data mining,which of the following involves using a series of existing values to determine what other future values will be?

Accepted Answer

A) Associations 
B) Sequences 
C) Classifications 
D) Clustering 
E) Forecasting 
A) Associations 
B) Sequences 
C) Classifications 
D) Clustering 
E) Forecasting

Question 5

What makes data mining an important business tool? What types of information does data mining produce? In what type of circumstance would you advise a company to use data mining?

Accepted Answer

Data mining is one of the data analysis

Question 6

DBMS have a data definition capability to specify the structure of the content of the database.

Accepted Answer

A) True 
 B)False

Question 7

Detecting and correcting data in a database or file that are incorrect,incomplete,improperly formatted,or redundant is called:

Accepted Answer

A) data auditing. 
B) defragmentation. 
C) data scrubbing. 
D) data optimization. 
E) data normalization. 
A) data auditing. 
B) defragmentation. 
C) data scrubbing. 
D) data optimization. 
E) data normalization.

Question 8

Which of the following would you use to find patterns in user interaction data recorded by a web server?

Accepted Answer

A) Web usage mining 
B) Web server mining 
C) Web structure mining 
D) Web content mining 
E) Web protocol mining 
A) Web usage mining 
B) Web server mining 
C) Web structure mining 
D) Web content mining 
E) Web protocol mining

Question 9

The select operation:

Accepted Answer

A) combines relational tables to provide the user with more information than is otherwise available. 
B) creates a subset consisting of columns in a table. 
C) identifies the table from which the columns will be selected. 
D) creates a subset consisting of all records in the file that meet stated criteria. 
E) creates a subset consisting of rows in a table. 
A) combines relational tables to provide the user with more information than is otherwise available. 
B) creates a subset consisting of columns in a table. 
C) identifies the table from which the columns will be selected. 
D) creates a subset consisting of all records in the file that meet stated criteria. 
E) creates a subset consisting of rows in a table.

Question 10

HTML has become the preferred method of communicating with back-end databases because it is a cross-platform language.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is software that handles all application operations between browser-based computers and a company's back-end business applications or databases?

Accepted Answer

A) Database server software 
B) Application server software 
C) Web browser software 
D) Data mining software 
E) Web server software 
A) Database server software 
B) Application server software 
C) Web browser software 
D) Data mining software 
E) Web server software

Question 12

Which of the following is the most prominent data manipulation language today?

Accepted Answer

A) Access 
B) DB2 
C) SQL 
D) Crystal Reports 
E) NoSQL 
A) Access 
B) DB2 
C) SQL 
D) Crystal Reports 
E) NoSQL

Question 13

Legacy systems are used to populate and update data warehouses.

Accepted Answer

A) True 
 B)False

Question 14

The term data governance refers to the policies and processes for managing the integrity and security of data in a firm.

Accepted Answer

A) True 
 B)False

Question 15

Data cleansing not only corrects errors but also:

Accepted Answer

A) establishes logical relationships between data. 
B) structures data. 
C) normalizes data. 
D) removes duplicate data. 
E) enforces consistency among different sets of data. 
A) establishes logical relationships between data. 
B) structures data. 
C) normalizes data. 
D) removes duplicate data. 
E) enforces consistency among different sets of data.

Question 16

The join operation:

Accepted Answer

A) combines relational tables to provide the user with more information than is otherwise available. 
B) identifies the table from which the columns will be selected. 
C) creates a subset consisting of columns in a table. 
D) organizes elements into segments. 
E) creates a subset consisting of rows in a table. 
A) combines relational tables to provide the user with more information than is otherwise available. 
B) identifies the table from which the columns will be selected. 
C) creates a subset consisting of columns in a table. 
D) organizes elements into segments. 
E) creates a subset consisting of rows in a table.

Question 17

You can manipulate data on a web server by using a CGI script.

Accepted Answer

A) True 
 B)False

Question 18

You can use text mining tools to analyze unstructured data,such as memos and legal cases.

Accepted Answer

A) True 
 B)False

Question 19

The logical and physical views of data are separated in a DBMS.

Accepted Answer

A) True 
 B)False

Question 20

Microsoft Access's data dictionary displays all of the following information about a field except the:

Accepted Answer

A) size of the field. 
B) format of the field. 
C) description of the field. 
D) type of the field. 
E) the organization within the organization that is responsible for maintaining the data. 
A) size of the field. 
B) format of the field. 
C) description of the field. 
D) type of the field. 
E) the organization within the organization that is responsible for maintaining the data.

NoSQL technologies are used to manage sets of data that don't require the flexibility of tables and relations.

Every record in a file should contain at least one key field.

A DBMS makes the:

In data mining,which of the following involves using a series of existing values to determine what other future values will be?

What makes data mining an important business tool? What types of information does data mining produce? In what type of circumstance would you advise a company to use data mining?

DBMS have a data definition capability to specify the structure of the content of the database.

Detecting and correcting data in a database or file that are incorrect,incomplete,improperly formatted,or redundant is called:

Which of the following would you use to find patterns in user interaction data recorded by a web server?

The select operation:

HTML has become the preferred method of communicating with back-end databases because it is a cross-platform language.

Which of the following is software that handles all application operations between browser-based computers and a company's back-end business applications or databases?

Which of the following is the most prominent data manipulation language today?

Legacy systems are used to populate and update data warehouses.

The term data governance refers to the policies and processes for managing the integrity and security of data in a firm.

Data cleansing not only corrects errors but also:

The join operation:

You can manipulate data on a web server by using a CGI script.

You can use text mining tools to analyze unstructured data,such as memos and legal cases.

The logical and physical views of data are separated in a DBMS.

Microsoft Access's data dictionary displays all of the following information about a field except the:

Information Systems in Global Business Today

Global E-Business and Collaboration

Information Systems,organizations,and Strategy

Ethical and Social Issues in Information Systems

It Infrastructure and Emerging Technologies

Telecommunications,the Internet,and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets,digital Goods

Managing Knowledge

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters

Exam 6: Foundations of Business Intelligence: Databases and Information Management

NoSQL technologies are used to manage sets of data that don't require the flexibility of tables and relations.

Every record in a file should contain at least one key field.

A DBMS makes the:

In data mining,which of the following involves using a series of existing values to determine what other future values will be?

What makes data mining an important business tool? What types of information does data mining produce? In what type of circumstance would you advise a company to use data mining?

DBMS have a data definition capability to specify the structure of the content of the database.

Detecting and correcting data in a database or file that are incorrect,incomplete,improperly formatted,or redundant is called:

Which of the following would you use to find patterns in user interaction data recorded by a web server?

The select operation:

HTML has become the preferred method of communicating with back-end databases because it is a cross-platform language.

Which of the following is software that handles all application operations between browser-based computers and a company's back-end business applications or databases?

Which of the following is the most prominent data manipulation language today?

Legacy systems are used to populate and update data warehouses.

The term data governance refers to the policies and processes for managing the integrity and security of data in a firm.

Data cleansing not only corrects errors but also:

The join operation:

You can manipulate data on a web server by using a CGI script.

You can use text mining tools to analyze unstructured data,such as memos and legal cases.

The logical and physical views of data are separated in a DBMS.

Microsoft Access's data dictionary displays all of the following information about a field except the:

Information Systems in Global Business Today

Global E-Business and Collaboration

Information Systems,organizations,and Strategy

Ethical and Social Issues in Information Systems

It Infrastructure and Emerging Technologies

Telecommunications,the Internet,and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets,digital Goods

Managing Knowledge

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters