Question 1

The action of including only some columns for output while retrieving data is known as ____.

Accepted Answer

A) selecting 
B) joining 
C)  projecting 
D)  linking 
A) selecting 
B) joining 
C)  projecting 
D)  linking C

Question 2

Explain entity-relationship (ER) diagrams.

Accepted Answer

Entity-relationship (ER) diagrams use basic graphical symbols to show an organization of and relationships between data. In other words, ER diagrams show data items in tables (entities) and the ways they are related.
ER diagrams help ensure that the relationships among the data entities in a database are correctly structured so that any application programs developed are consistent with business operations and user needs. In addition, ER diagrams can serve as reference documents after a database is in use. If changes are made to the database, ER diagrams help design them.

Question 3

_____ is an approach that starts by investigating the general data and information needs of an organization at the strategic level and then examines more specific data and information needs for the functional areas and departments within the organization.

Accepted Answer

A) Data selecting 
B) Enterprise data modeling 
C)  Data cleansing 
D)  Social graph analysis
​ 
A) Data selecting 
B) Enterprise data modeling 
C)  Data cleansing 
D)  Social graph analysis
​ B

Question 4

The relational database model is currently the most widely used.

Accepted Answer

A) True 
 B)False

Question 5

Unstructured data comes from sources such as word-processing documents and scientific research.

Accepted Answer

A) True 
 B)False

Question 6

Haley's employer has asked her to review tens of thousands of social media posts about their company's products and compile this data into a database. In terms of the characteristics of big data, Haley is dealing with ________.

Accepted Answer

A) ​volume 
B) ​variety 
C)  ​velocity 
D)  ​veracity 
A) ​volume 
B) ​variety 
C)  ​velocity 
D)  ​veracity

Question 7

A(n) _____ is a database management system that stores the entire database in random access memory (RAM).

Accepted Answer

in-memory

Question 8

Define the role of a database administrator and of a data administrator, and explain the difference between the two.

Accepted Answer

Based on their understanding of business

Question 9

In a relational database model, _____ involves combining two or more tables.

Accepted Answer

The answer of In a relational database model, _____ involves...

Question 10

_____ is a special-purpose programming language for accessing and manipulating data stored in a relational database.

Accepted Answer

A) Query by Example (QB
E)  
B) Access 
C)  Structured Query Language (SQL) 
D)  Java 
A) Query by Example (QB
E)  
B) Access 
C)  Structured Query Language (SQL) 
D)  Java

Question 11

_____ is a method of dealing with a situation in which two or more users or applications need to access the same record at the same time.

Accepted Answer

The answer of _____ is a method of dealing with...

Question 12

Together, bits, characters, fields, records, files, and databases form the ______.

Accepted Answer

The answer of Together, bits, characters, fields, records, files, and...

Question 13

Briefly describe the relational database model.

Accepted Answer

The relational database model describes

Question 14

To ensure reliability and integrity, SQL databases conform to four specific properties. Which of the following is NOT one of those four properties?

Accepted Answer

A) ​atomicity 
B) ​durability 
C)  ​isolation 
D)  ​currency 
A) ​atomicity 
B) ​durability 
C)  ​isolation 
D)  ​currency

Question 15

Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, MySQL, and Sybas are databases based on the _____ model.

Accepted Answer

The answer of Oracle, IBM DB2, Microsoft SQL Server, Microsoft...

Question 16

Carlos is working with an existing database, but he wants to eliminate some of the columns in the table to create a new, more streamlined database. He will use projection to create his new database.

Accepted Answer

A) True 
 B)False

Question 17

In the _____ process, all of the data from various sources is converted into a single format suitable for processing.

Accepted Answer

A) extract 
B) transform 
C)  load 
D)  consolidate 
A) extract 
B) transform 
C)  load 
D)  consolidate

Question 18

The relational model describes data using a standard tabular format; all data elements are placed in three-dimensional tables called relations, which are the logical equivalent of files.

Accepted Answer

A) True 
 B)False

Question 19

You would use Query by Example, if _____.

Accepted Answer

A) you wish to use a visual approach to query building 
B) you build a query from an example 
C)  you use a template for reports 
D)  wish teach SQL with examples 
A) you wish to use a visual approach to query building 
B) you build a query from an example 
C)  you use a template for reports 
D)  wish teach SQL with examples

Question 20

Define the terms data management and data governance, and explain how organizations are using them to address the challenges of big data.

Accepted Answer

Big data presents many challenges to org

The action of including only some columns for output while retrieving data is known as ____.

Explain entity-relationship (ER) diagrams.

_____ is an approach that starts by investigating the general data and information needs of an organization at the strategic level and then examines more specific data and information needs for the functional areas and departments within the organization.

The relational database model is currently the most widely used.

Unstructured data comes from sources such as word-processing documents and scientific research.

Haley's employer has asked her to review tens of thousands of social media posts about their company's products and compile this data into a database. In terms of the characteristics of big data, Haley is dealing with ________.

A(n) _____ is a database management system that stores the entire database in random access memory (RAM).

Define the role of a database administrator and of a data administrator, and explain the difference between the two.

In a relational database model, _____ involves combining two or more tables.

_____ is a special-purpose programming language for accessing and manipulating data stored in a relational database.

_____ is a method of dealing with a situation in which two or more users or applications need to access the same record at the same time.

Together, bits, characters, fields, records, files, and databases form the ______.

Briefly describe the relational database model.

To ensure reliability and integrity, SQL databases conform to four specific properties. Which of the following is NOT one of those four properties?

Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, MySQL, and Sybas are databases based on the _____ model.

Carlos is working with an existing database, but he wants to eliminate some of the columns in the table to create a new, more streamlined database. He will use projection to create his new database.

In the _____ process, all of the data from various sources is converted into a single format suitable for processing.

The relational model describes data using a standard tabular format; all data elements are placed in three-dimensional tables called relations, which are the logical equivalent of files.

You would use Query by Example, if _____.

Define the terms data management and data governance, and explain how organizations are using them to address the challenges of big data.

An Introduction to Information Systems in Organizations

Hardware and Software

Networks and Cloud Computing

Electronic Commerce and Enterprise Systems

Business Intelligence and Analytics

Knowledge Management and Specialized Information Systems

Systems Acquisition and Development

The Personal and Social Effects of Computers

Ethics, Privacy, and Security in the Digital Age

Filters

Exam 3: Database Systems and Big Data

The action of including only some columns for output while retrieving data is known as ____.

Explain entity-relationship (ER) diagrams.

_____ is an approach that starts by investigating the general data and information needs of an organization at the strategic level and then examines more specific data and information needs for the functional areas and departments within the organization.

The relational database model is currently the most widely used.

Unstructured data comes from sources such as word-processing documents and scientific research.

Haley's employer has asked her to review tens of thousands of social media posts about their company's products and compile this data into a database. In terms of the characteristics of big data, Haley is dealing with ________.

A(n) _____ is a database management system that stores the entire database in random access memory (RAM).

Define the role of a database administrator and of a data administrator, and explain the difference between the two.

In a relational database model, _____ involves combining two or more tables.

_____ is a special-purpose programming language for accessing and manipulating data stored in a relational database.

_____ is a method of dealing with a situation in which two or more users or applications need to access the same record at the same time.

Together, bits, characters, fields, records, files, and databases form the ______.

Briefly describe the relational database model.

To ensure reliability and integrity, SQL databases conform to four specific properties. Which of the following is NOT one of those four properties?

Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, MySQL, and Sybas are databases based on the _____ model.

Carlos is working with an existing database, but he wants to eliminate some of the columns in the table to create a new, more streamlined database. He will use projection to create his new database.

In the _____ process, all of the data from various sources is converted into a single format suitable for processing.

The relational model describes data using a standard tabular format; all data elements are placed in three-dimensional tables called relations, which are the logical equivalent of files.

You would use Query by Example, if _____.

Define the terms data management and data governance, and explain how organizations are using them to address the challenges of big data.

An Introduction to Information Systems in Organizations

Hardware and Software

Networks and Cloud Computing

Electronic Commerce and Enterprise Systems

Business Intelligence and Analytics

Knowledge Management and Specialized Information Systems

Systems Acquisition and Development

The Personal and Social Effects of Computers

Ethics, Privacy, and Security in the Digital Age

Filters