Question 1

A one-to-one relationship between two entities is symbolized in a diagram by a line that ends:

Accepted Answer

A)  in two short marks. 
B)  in one short mark. 
C)  with a crow's foot. 
D)  with a crow's foot topped by a short mark. 
E)  with a crow's foot topped by two short marks. 
A)  in two short marks. 
B)  in one short mark. 
C)  with a crow's foot. 
D)  with a crow's foot topped by a short mark. 
E)  with a crow's foot topped by two short marks. A

Question 2

Most back-end databases are able to interpret HTML commands.

Accepted Answer

A) True 
 B)False  False

Question 3

What are some of the benefits of using the cloud as a database platform?

Accepted Answer

Cloud-based data management services are ideal for smaller to medium-sized businesses looking to establish database capabilities without paying for expensive in-house database products. Companies can use public cloud-based services or they can use a private cloud to share hardware and software between users, reducing the number of servers, DBMS, and storage devices required.

Question 4

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 5

You are working in the IT department of a small paper supply company and planning a new database that monitors employee benefits and productivity. What would be the relationship you need to establish between Employee_ID in the Employee table and Parking_spot_number in the Perks table?

Accepted Answer

A)  One-to-many 
B)  One-to-one 
C)  Many-to-many 
D)  Many-to-one 
E)  One-to-all 
A)  One-to-many 
B)  One-to-one 
C)  Many-to-many 
D)  Many-to-one 
E)  One-to-all

Question 6

OLAP is a key tool of BI.

Accepted Answer

A) True 
 B)False

Question 7

The project 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)  organizes elements into segments. 
D)  identifies the table from which the columns will be selected. 
E)  stores definitions of data elements. 
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)  organizes elements into segments. 
D)  identifies the table from which the columns will be selected. 
E)  stores definitions of data elements.

Question 8

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)  It is critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve. 
C)  It is essential, as table relationships cannot be created without an accurate data model. 
D)  It is somewhat important, as the type of data model will define what kinds of data will be stored. 
E)  It is unnecessary, as a well-designed database should not require one. 
A)  It is not essential, as the data model itself is modified by the database continuously. 
B)  It is critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve. 
C)  It is essential, as table relationships cannot be created without an accurate data model. 
D)  It is somewhat important, as the type of data model will define what kinds of data will be stored. 
E)  It is unnecessary, as a well-designed database should not require one.

Question 9

MongoDB and SimpleDB are both examples of:

Accepted Answer

A)  open-source databases. 
B)  SQL databases. 
C)  NoSQL databases. 
D)  cloud databases. 
E)  big data databases. 
A)  open-source databases. 
B)  SQL databases. 
C)  NoSQL databases. 
D)  cloud databases. 
E)  big data databases.

Question 10

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

Accepted Answer

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

Question 11

What is the first step you should take in managing data for a firm?

Accepted Answer

A)  Identify the data needed to run the business. 
B)  Cleanse the data before importing it to any database. 
C)  Normalize the data before importing to a database. 
D)  Audit your data quality. 
E)  Remove redundancy. 
A)  Identify the data needed to run the business. 
B)  Cleanse the data before importing it to any database. 
C)  Normalize the data before importing to a database. 
D)  Audit your data quality. 
E)  Remove redundancy.

Question 12

MySQL is a:

Accepted Answer

A)  DBMS for mobile devices. 
B)  programming language. 
C)  mainframe relational DBMS. 
D)  DBMS for desktop systems. 
E)  popular open-source DBMS. 
A)  DBMS for mobile devices. 
B)  programming language. 
C)  mainframe relational DBMS. 
D)  DBMS for desktop systems. 
E)  popular open-source DBMS.

Question 13

Which of the following is the type of logical database model that treats data as if they were stored in two-dimensional tables?

Accepted Answer

A)  Two-tiered DBMS 
B)  Pre-digital DBMS 
C)  Open source DBMS 
D)  Hierarchical DBMS 
E)  Relational DBMS 
A)  Two-tiered DBMS 
B)  Pre-digital DBMS 
C)  Open source DBMS 
D)  Hierarchical DBMS 
E)  Relational DBMS

Question 14

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

Accepted Answer

Data mining uncovers hidden relationship

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

A)  tuple. 
B)  key field. 
C)  entity. 
D)  field. 
E)  table. 
A)  tuple. 
B)  key field. 
C)  entity. 
D)  field. 
E)  table.

Question 17

Identify and describe the three basic operations used to extract useful sets of data from a relational database?

Accepted Answer

The select operation creates a subset co

Question 18

In a table for customers, the information about a single customer would reside in a single:

Accepted Answer

A)  field. 
B)  entity. 
C)  column. 
D)  table. 
E)  row. 
A)  field. 
B)  entity. 
C)  column. 
D)  table. 
E)  row.

Question 19

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 20

Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions are known as:

Accepted Answer

A)  DSS. 
B)  business intelligence. 
C)  OLAP. 
D)  data mining. 
E)  in-memory computing. 
A)  DSS. 
B)  business intelligence. 
C)  OLAP. 
D)  data mining. 
E)  in-memory computing.

A one-to-one relationship between two entities is symbolized in a diagram by a line that ends:

Most back-end databases are able to interpret HTML commands.

What are some of the benefits of using the cloud as a database platform?

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

You are working in the IT department of a small paper supply company and planning a new database that monitors employee benefits and productivity. What would be the relationship you need to establish between Employee_ID in the Employee table and Parking_spot_number in the Perks table?

OLAP is a key tool of BI.

The project operation:

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

MongoDB and SimpleDB are both examples of:

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

What is the first step you should take in managing data for a firm?

MySQL is a:

Which of the following is the type of logical database model that treats data as if they were stored in two-dimensional tables?

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

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

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

Identify and describe the three basic operations used to extract useful sets of data from a relational database?

In a table for customers, the information about a single customer would reside in a single:

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?

Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions are known 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:

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

A one-to-one relationship between two entities is symbolized in a diagram by a line that ends:

Most back-end databases are able to interpret HTML commands.

What are some of the benefits of using the cloud as a database platform?

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

You are working in the IT department of a small paper supply company and planning a new database that monitors employee benefits and productivity. What would be the relationship you need to establish between Employee_ID in the Employee table and Parking_spot_number in the Perks table?

OLAP is a key tool of BI.

The project operation:

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

MongoDB and SimpleDB are both examples of:

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

What is the first step you should take in managing data for a firm?

MySQL is a:

Which of the following is the type of logical database model that treats data as if they were stored in two-dimensional tables?

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

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

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

Identify and describe the three basic operations used to extract useful sets of data from a relational database?

In a table for customers, the information about a single customer would reside in a single:

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?

Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions are known 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:

E-Commerce: Digital Markets, Digital Goods

Improving Decision Making and Managing Knowledge

Building Information Systems and Managing Projects

Filters