Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

The data integrity problem occurs only if data are duplicated.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A database management system (DBMS)is a ...

Question 5

A database is used instead of a spreadsheet when ________.

Accepted Answer

A)   lists of data involve a single theme
B)   structures of data lists are simple
C)   lists involve data with multiple themes
D)   users do not want to store all data in one placeE) None of the above
F) A) and D)

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A)   Database design
B)   Database querying
C)   Data mining
D)   Database aggregationE) None of the above
F) B) and C)

Question 8

A data integrity problem will occur only if ________.

Accepted Answer

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 databaseE) B) and C)
F) A) and D)

Question 9

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

Accepted Answer

A)   file
B)   field
C)   character
D)   byteE) All of the above
F) None of the above

Question 10

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

Accepted Answer

A) True 
 B)False  True

Question 11

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

Accepted Answer

A)   development
B)   adaptation
C)   backup and recovery
D)   operationE) A) and C)
F) A) and D)

Question 12

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

Accepted Answer

A)   one-to-one relationship between entities
B)   single theme
C)   foreign key
D)   specialized graphical queryE) A) and B)
F) All of the above

Question 13

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

Accepted Answer

A)   field
B)   record
C)   byte
D)   metadataE) A) and D)
F) A) and C) C

Question 14

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

Accepted Answer

A) True 
 B)False  True

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Explain the different types of database applications.

Accepted Answer

Database applications fall into two broa...

Question 18

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

Accepted Answer

A)   public key
B)   identifier
C)   foreign key
D)   index fieldE) A) and B)
F) B) and D)

Question 19

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

Accepted Answer

A)   They are displayed and processed using html5, css3, and JavaScript.
B)   They use JavaScript for user-side processing.
C)   The Internet is used to access the DBMS server computer.
D)   The application, the DBMS, and the database all reside on the user's computer.E) B) and C)
F) C) and D)

Question 20

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

Accepted Answer

A)   data aggregator
B)   query model
C)   data model
D)   data applicationE) A) and D)
F) B) and C)

Exam 5: Database Processing

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

Correct AnswerverifiedShow Answer

The data integrity problem occurs only if data are duplicated.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA database management system (DBMS)is a ...View AnswerShow Answer

A database is used instead of a spreadsheet when ________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A data integrity problem will occur only if ________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedTrue

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedC

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

Correct AnswerverifiedTrue

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Explain the different types of database applications.

Correct AnswerverifiedDatabase applications fall into two broa...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A database management system (DBMS)is a ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Database applications fall into two broa...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified