FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Essay

Review LaterAdd Note

Review Later

Describe the loading process used in data warehouses.

Correct Answer

verified

Loading is the process of transferring d...

View Answer

Show Answer

Question 42

Essay

Review LaterAdd Note

Review Later

What is business analytics?

Correct Answer

verified

Business analytics (BA)uses da...

View Answer

Show Answer

Question 43

True/False

Review LaterAdd Note

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

As compared to data warehouses,consolidating information from different departments or functional areas is easier in data marts.

What is structured query language (SQL)?

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

The _____ approach,used to set up a distributed database management system (DDBMS) ,combines fragmentation and replication.

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

In contrast to the query languages used to interact with a relational database,interaction with an object-oriented database takes places via methods that are called by sending a message to an object.

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

In data warehouses,_____ is information about data-its content,quality,condition,origin,and other characteristics.

The network model is similar to the hierarchical data model because records are organized in the same way.

A data _____ is a collection of data from a variety of sources used to support decision-making applications and generate business intelligence.

What are the advantages of a database over a flat file system?

Which of the following is an example of a source for external data?

Identify the number of physical views of data for a database.

Identify a true statement about a database.

A _________ is software for creating,storing,maintaining,and accessing database files.

In well-designed data-driven Web sites,changes are made to the _____ code every time a Web site's data content changes.

Describe the fragmentation approach to setting up a distributed database management system.