Exam 9: Database Management Systems

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

Use the following words to complete the sentences. database administrator data dictionary data redundancy index sequential access method query language schema sequential structure subschema -The ____________________ allows users to retrieve and modify data easily.

(Short Answer)
4.8/5
(36)

Use the following words to complete the sentences. database administrator data dictionary data redundancy index sequential access method query language schema sequential structure subschema -The __________________________ authorizes access to the database.

(Short Answer)
4.8/5
(40)

An important feature associated with the traditional approach to data management is the ability to produce ad hoc reports.

(True/False)
4.8/5
(43)

The database management system provides a controlled environment for accessing the database.

(True/False)
4.8/5
(42)

The deletion anomaly is the least important of the problems affecting unnormalized databases.

(True/False)
4.9/5
(27)

Users access the database

(Multiple Choice)
4.9/5
(37)

Under the database approach, data is viewed as proprietary or owned by users.

(True/False)
4.8/5
(37)

Explain a database lockout and the deadlock phenomenon. Contrast that to concurrency control and the timestamping technique. Describe the importance of these items in relation to database integrity.

(Essay)
4.8/5
(43)

The most serious problem with unnormalized databases is the

(Multiple Choice)
4.8/5
(29)

In a hierarchical model

(Multiple Choice)
4.9/5
(35)

The update anomaly in unnormalized databases

(Multiple Choice)
4.8/5
(32)

Explain the three types of anomalies associated with database tables that have not been normalized.

(Essay)
5.0/5
(31)

Which procedure will prevent two end users from accessing the same data element at the same time?

(Multiple Choice)
4.9/5
(32)

An example of a distributed database is

(Multiple Choice)
4.9/5
(23)

Which statement is correct?

(Multiple Choice)
4.7/5
(44)

Which duty is not the responsibility of the database administrator?

(Multiple Choice)
4.8/5
(41)

A user view

(Multiple Choice)
4.7/5
(35)

What is repeating group data?

(Essay)
4.7/5
(44)

An ER diagram is a graphical representation of a data model.

(True/False)
4.9/5
(31)

Which of the following is a relational algebra function?

(Multiple Choice)
4.8/5
(34)
Showing 41 - 60 of 105
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)