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

Multiple Choice

Review LaterAdd Note

Review Later

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

A) physical structure
B) logical structure
C) primary key
D) foreign key

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

Correct Answer

verified

Show Answer

Question 42

True/False

Review LaterAdd Note

Review Later

In contrast to the query languages used to interact with a relational database,interaction with an object-oriented database takes places via methods.

A) True
B) False

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

Which of the following statements is true of data marts and data warehouses?

Disks are sequential access devices,whereas tapes are random access devices.

A database administrator is responsible for developing recovery procedures in case data is lost or corrupted.

Describe the tasks performed in the first normal form (1NF) stage of normalization.

The _____ of a data model defines the boundaries of a database,such as maximum and minimum values allowed for a field.

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

In large organizations,database design and management is handled by the _____.

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

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

The advantage of _____ is that both sequential and random access can be used,depending on the situation and the user's needs.

The _____ component of a database management system (DBMS) is used for tasks such as backup and recovery,security,and change management.

Which of the following is a source of external data?

Which of the following data sources provides the input a data warehouse needs to perform analyses and generate reports?

For each database,there can be more than one physical view of data.

Labor and population statistics are sources of internal data that are accessed by a database.

In a relational model,when a primary key for one table appears in another table,it is called a _____ key.

What is a data-driven Web site?

Explain the transformation processes used in data warehouses.