Question 1

Describe the loading process used in data warehouses.

Accepted Answer

The answer of Describe the loading process used in data...

Question 2

Any changes to a database's structure,such as adding a field,deleting a field,changing a field's size,or changing the data type stored in a field,are made with the data manipulation component.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following is a key factor that has contributed to the growth and popularity of big data?

Accepted Answer

A)  Implosion in data growth 
B)  Brick and mortar businesses 
C)  Mobile and wireless technology 
D)  Exponential decay of organizational data

Question 4

A _____ stores definitions,such as data types for fields,default values,and validation rules for data in each field.

Accepted Answer

A)  data dictionary 
B)  data mine 
C)  data warehouse 
D)  data mart

Question 5

A(n) _____ is a collection of related data that is stored in a central location or multiple locations.

Accepted Answer

The answer of A(n) _____ is a collection of related...

Question 6

What type of files might a college database have?

Accepted Answer

The answer of What type of files might a college...

Question 7

Grouping objects along with their attributes and methods into a class is called _____.

Accepted Answer

The answer of Grouping objects along with their attributes and...

Question 8

In a hierarchical data model,nodes with the same parents are called siblings.

Accepted Answer

A) True 
 B)False

Question 9

In the past,why was data stored in "flat files"?

Accepted Answer

The answer of In the past,why was data stored in...

Question 10

A distributed database is not limited by the data's physical location.

Accepted Answer

A) True 
 B)False

Question 11

_____ is used to facilitate and manage transaction-oriented applications,such as point-of-sale,data entry,and retrieval transaction processing.

Accepted Answer

The answer of _____ is used to facilitate and manage...

Question 12

The integrity rules component of a data model defines the boundaries of a database,constraints,and access methods.

Accepted Answer

A) True 
 B)False

Question 13

In a(n) _____ data model,the relationships among records form a treelike structure.

Accepted Answer

The answer of In a(n) _____ data model,the relationships among...

Question 14

The _____ component is responsible for data storage,manipulation,and retrieval.

Accepted Answer

A)  data definition 
B)  data administration 
C)  application generation 
D)  database engine

Question 15

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

Accepted Answer

A)  Optimization 
B)  Fragmentation 
C)  Normalization 
D)  Encapsulation

Question 16

What is business analytics?

Accepted Answer

The answer of What is business analytics?...

Question 17

The database component of an information system can generate sufficient business intelligence by accessing just the internal data of an organization.

Accepted Answer

A) True 
 B)False

Question 18

In a relational data model,a(n) _____ operation searches data in a table and retrieves records based on certain criteria.

Accepted Answer

A)  insert 
B)  join 
C)  find 
D)  select

Question 19

Business analytics uses _____ to support decision-making activities.

Accepted Answer

A)  data mining tools 
B)  dashboards 
C)  query reports 
D)  OLAP

Question 20

The popularity of social networks has contributed to the growth of big data.

Accepted Answer

A) True 
 B)False

Exam 3: Database Systems,data Warehouses,and Data Marts

Describe the loading process used in data warehouses.

Any changes to a database's structure,such as adding a field,deleting a field,changing a field's size,or changing the data type stored in a field,are made with the data manipulation component.

Which of the following is a key factor that has contributed to the growth and popularity of big data?

A _____ stores definitions,such as data types for fields,default values,and validation rules for data in each field.

A(n) _____ is a collection of related data that is stored in a central location or multiple locations.

What type of files might a college database have?

Grouping objects along with their attributes and methods into a class is called _____.

In a hierarchical data model,nodes with the same parents are called siblings.

In the past,why was data stored in "flat files"?

A distributed database is not limited by the data's physical location.

_____ is used to facilitate and manage transaction-oriented applications,such as point-of-sale,data entry,and retrieval transaction processing.

The integrity rules component of a data model defines the boundaries of a database,constraints,and access methods.

In a(n) _____ data model,the relationships among records form a treelike structure.

The _____ component is responsible for data storage,manipulation,and retrieval.

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

What is business analytics?

The database component of an information system can generate sufficient business intelligence by accessing just the internal data of an organization.

In a relational data model,a(n) _____ operation searches data in a table and retrieves records based on certain criteria.

Business analytics uses _____ to support decision-making activities.

The popularity of social networks has contributed to the growth of big data.