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 31

Multiple Choice

Review LaterAdd Note

Review Later

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

A) database engine
B) data-driven site
C) static site
D) database mine

E) B) and C)
F) None of the above

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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

A) database management system
B) data hierarchical system
C) database modelling tool
D) data warehousing tool

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 33

Essay

Review LaterAdd Note

Discuss why an organization might choose a distributed database.

Briefly discuss the advantages and disadvantages of database marketing.

In comparison with flat file systems,databases:

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

To begin designing a relational database,you must define the _____ by defining each table and the fields in it.

Discuss how data was stored in flat files in the past.Explain the disadvantages associated with the flat file organization.

The advantage of the _____ access method is that both sequential and random access can be used to access records,depending on the number being accessed.

The first step in database design is defining a _____,which determines how data is created,represented,organized,and maintained.

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

In a _____ model,the relationships among records form a treelike structure.

In a relational database model,the rows are called _____.

In a(n) _____  access file structure,records can be accessed in any order,regardless of their physical locations in storage media.

Briefly explain the responsibilities of a database administrator (DBA).

Data in a database is used for analytical purposes,whereas data in a data warehouse is used for capturing and managing transactions.

Data warehouses are sometimes called hypercubes because they _____.

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

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

In a relational database model,which operation pares down a table by eliminating columns according to certain criteria?