Question 1

Both Oracle and Microsoft Access use SQL to retrieve information from the database.

Accepted Answer

A) True 
 B)False

Question 2

What is the purpose of a DBMS's data definition function?

Accepted Answer

A) Storing and managing the data in the database 
B) Storing definitions of data elements 
C) Normalizing the database 
D) Structuring the database 
A) Storing and managing the data in the database 
B) Storing definitions of data elements 
C) Normalizing the database 
D) Structuring the database

Question 3

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:

Accepted Answer

A) normalization. 
B) data scrubbing. 
C) data cleansing. 
D) data administration. 
A) normalization. 
B) data scrubbing. 
C) data cleansing. 
D) data administration.

Question 4

Common Gateway Interface is a specification for processing data on a Web server.

Accepted Answer

A) True 
 B)False

Question 5

An example of a pre-digital database is a:

Accepted Answer

A) library's card-catalog. 
B) cash register receipt. 
C) doctor's office invoice. 
D) list of sales totals on a spreadsheet. 
A) library's card-catalog. 
B) cash register receipt. 
C) doctor's office invoice. 
D) list of sales totals on a spreadsheet.

Question 6

A firm's information policy lays out who is responsible for updating and maintaining the information in a database system.

Accepted Answer

A) True 
 B)False

Question 7

Explain what big data refers to. What benefits does it have, and what challenges does it pose?

Accepted Answer

Big data is datasets with volumes so hug

Question 8

Within a corporate information services department, the task of creating the physical database and its logical relations are responsibilities of the ________ function.

Accepted Answer

A) database administration 
B) data administration 
C) server administration 
D) data modeling 
A) database administration 
B) data administration 
C) server administration 
D) data modeling

Question 9

Which of the following best describes the importance of creating an accurate data model for your business's database?

Accepted Answer

A) It is not essential, as the data model itself is modified by the database continuously. 
B) Critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve 
C) Essential, as table relationships cannot be created without an accurate data model 
D) Somewhat important, as the type of data model will define what kinds of data will be stored 
A) It is not essential, as the data model itself is modified by the database continuously. 
B) Critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve 
C) Essential, as table relationships cannot be created without an accurate data model 
D) Somewhat important, as the type of data model will define what kinds of data will be stored

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

List and describe three main capabilities or tools of a DBMS.

Accepted Answer

A DBMS includes capabilities and tools f

Question 12

A data warehouse may include information from legacy systems.

Accepted Answer

A) True 
 B)False

Question 13

A DBMS makes the:

Accepted Answer

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

Question 14

List at least two ways that a business's data can become redundant or inconsistent.

Accepted Answer

Data redundancy and inconsistency can oc

Question 15

The two key services of Hadoop are HDFS and in-memory computing.

Accepted Answer

A) True 
 B)False

Question 16

The use of different terms for identifying data in a firm's various information systems is an example of redundant data.

Accepted Answer

A) True 
 B)False

Question 17

What types of relationships are possible in a relational database? Describe and give an example of each.

Accepted Answer

There are three types of relationships:

Question 18

An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the:

Accepted Answer

A) data dictionary. 
B) data definition diagram. 
C) entity-relationship diagram. 
D) relationship dictionary. 
A) data dictionary. 
B) data definition diagram. 
C) entity-relationship diagram. 
D) relationship dictionary.

Question 19

In a relational database, a record is also called a(n):

Accepted Answer

A) tuple. 
B) row. 
C) entity. 
D) field. 
A) tuple. 
B) row. 
C) entity. 
D) field.

Question 20

Pre-configured hardware-software systems that use both relational and non-relational technology optimized for analyzing large datasets are referred to as:

Accepted Answer

A) Hybrid DBMS. 
B) Hadoop. 
C) BI. 
D) Analytic platforms. 
A) Hybrid DBMS. 
B) Hadoop. 
C) BI. 
D) Analytic platforms.

Both Oracle and Microsoft Access use SQL to retrieve information from the database.

What is the purpose of a DBMS's data definition function?

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:

Common Gateway Interface is a specification for processing data on a Web server.

An example of a pre-digital database is a:

A firm's information policy lays out who is responsible for updating and maintaining the information in a database system.

Explain what big data refers to. What benefits does it have, and what challenges does it pose?

Within a corporate information services department, the task of creating the physical database and its logical relations are responsibilities of the ________ function.

Which of the following best describes the importance of creating an accurate data model for your business's database?

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

List and describe three main capabilities or tools of a DBMS.

A data warehouse may include information from legacy systems.

A DBMS makes the:

List at least two ways that a business's data can become redundant or inconsistent.

The two key services of Hadoop are HDFS and in-memory computing.

The use of different terms for identifying data in a firm's various information systems is an example of redundant data.

What types of relationships are possible in a relational database? Describe and give an example of each.

An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the:

In a relational database, a record is also called a(n):

Pre-configured hardware-software systems that use both relational and non-relational technology optimized for analyzing large datasets are referred to as:

Business Information Systems in Your Career

Global E-Business and Collaboration

Achieving Competitive Advantage With Information Systems

Ethical and Social Issues in Information Systems

It Infrastructure: Hardware and Software

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Improving Decision Making and Managing Knowledge

Building Information Systems and Managing Projects

Filters

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

Both Oracle and Microsoft Access use SQL to retrieve information from the database.

What is the purpose of a DBMS's data definition function?

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:

Common Gateway Interface is a specification for processing data on a Web server.

An example of a pre-digital database is a:

A firm's information policy lays out who is responsible for updating and maintaining the information in a database system.

Explain what big data refers to. What benefits does it have, and what challenges does it pose?

Within a corporate information services department, the task of creating the physical database and its logical relations are responsibilities of the ________ function.

Which of the following best describes the importance of creating an accurate data model for your business's database?

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

List and describe three main capabilities or tools of a DBMS.

A data warehouse may include information from legacy systems.

A DBMS makes the:

List at least two ways that a business's data can become redundant or inconsistent.

The two key services of Hadoop are HDFS and in-memory computing.

The use of different terms for identifying data in a firm's various information systems is an example of redundant data.

What types of relationships are possible in a relational database? Describe and give an example of each.

An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the:

In a relational database, a record is also called a(n):

Pre-configured hardware-software systems that use both relational and non-relational technology optimized for analyzing large datasets are referred to as:

Business Information Systems in Your Career

Global E-Business and Collaboration

Achieving Competitive Advantage With Information Systems

Ethical and Social Issues in Information Systems

It Infrastructure: Hardware and Software

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Improving Decision Making and Managing Knowledge

Building Information Systems and Managing Projects

Filters