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 1

True/False

Review LaterAdd Note

Review Later

An advantage that a database has over a flat file system is that more information can be generated from the same data.

A) True
B) False

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

With the indexed sequential access method (ISAM),records cannot be accessed randomly.

A) True
B) False

Correct Answer

verified

Show Answer

Question 3

Essay

Review LaterAdd Note

List and describe the features of data in a data warehouse in contrast to data in a database.

Which of the following statements is true of big data?

What is the function of a distributed database management system (DDBMS)?

The _____ component of a database management system (DBMS) is used to add,delete,modify,and retrieve records from a database.

A database engine converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS).

A _____ is usually a smaller version of a data warehouse,used by a single department or function.

Although a database can consist of only a single file,it is usually a group of files.

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

Describe the features and benefits of an object-oriented database.

In a(n) _____ data model,each record can have multiple parent and child records.

A(n) _____ is software for creating,storing,maintaining,and accessing database files.

The use of OR operator means that only one of the conditions in an SQL statement must be met.

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

In a relational model,the rows are called attributes and the columns are called tuples.

What are some of the sources of external data?

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

Data warehouses are sometimes called "hypercubes" because they_____.

The indexed sequential access method (ISAM) is slow and becomes increasingly useful as the number of records becomes larger.