FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Database Processing

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

A data integrity problem will occur only if ________.

A) a database has multiple administrators
B) data are duplicated in a database
C) the database is very complex
D) there are complex relationships between entities in a database

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following is the smallest element in a database?

A) field
B) record
C) byte
D) metadata

Correct Answer

verified

C

Question 3

Multiple Choice

Review LaterAdd Note

Which of the following is True of single-user databases?

A database is used instead of a spreadsheet when ________.

Each entity in a database has a unique attribute called a(n) ________.

Explain the different types of database applications.

Identify the type of task performed by a database administrator when validating the data model to be used in a database management system.

The general goal of normalization is to construct tables such that every table has a single topic or theme.

A foreign key is essential in relational databases to represent the relationship between two tables.

A line in an entity-relationship (E-R) diagram is used to represent the attributes of an entity.

The accuracy of a database design is not dependent on the corresponding data model.

The process of normalization constructs tables such that every table has a ________.

The data integrity problem occurs only if data are duplicated.

Which of the following data elements is placed higher than records in the database hierarchy?

The crow's-foot notation in an E-R diagram shows the maximum number of entities that can be involved in a relationship.

________ is the process of converting a data model into tables, relationships, and data constraints.

A spreadsheet can be used to store data if the structure of a list is simple.

Minimum cardinalities represent the lower limit on the number of entities required in a relationship.

An administrator should create a ________ before developing the database design.

Describe database management system and the functions provided by DBMS. List some of the popular DBMS products.