Question 1

Data entry forms are used to read, insert, modify, and delete data.

Accepted Answer

A) True 
 B)False

Question 2

A DBMS is a software that helps to manage the operating system.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following is a developmental task of database administration?

Accepted Answer

A) creating and staffing the DBA function 
B) monitoring backup procedures 
C) conducting training for users 
D) managing configuration changes in systems

Question 4

In a data model, a(n)________ is something that a user wants to track.

Accepted Answer

A) record 
B) byte 
C) entity 
D) primary key

Question 5

A group of similar rows or records is called a field.

Accepted Answer

A) True 
 B)False

Question 6

Attributes are used to describe characteristics of entities.

Accepted Answer

A) True 
 B)False

Question 7

Normalization is the process of combining two or more tables into a single table.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) public key 
B) identifier 
C) foreign key 
D) index field

Question 9

What are application programs and what are their functions?

Accepted Answer

The answer of What are application programs and what are...

Question 10

Some type of locking must be used to coordinate the activities of users who know nothing about one another in order to prevent the lost-update problem.

Accepted Answer

A) True 
 B)False

Question 11

The data integrity problem occurs if data are duplicated.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is a valid observation of MySQL?

Accepted Answer

A) It is offered by Oracle. 
B) It is license-free for most applications. 
C) It is a closed-source database product. 
D) It is yet to be widely adopted.

Question 13

SQL is an international standard language for processing a database.

Accepted Answer

A) True 
 B)False

Question 14

Metadata refer to entities that users of a database want to process.

Accepted Answer

A) True 
 B)False

Question 15

A primary key used in a database is a ________.

Accepted Answer

A) group of rows that are formed to identify a unique table or file 
B) column or group of columns that identifies a unique row in a table 
C) character or byte that represents fields or columns 
D) group of tables or files formed to identify a unique field or row

Question 16

A line in an E-R diagram is used to represent the attributes of the entities.

Accepted Answer

A) True 
 B)False

Question 17

From among the following, identify the open source DBMS product.

Accepted Answer

A) MySQL 
B) DB2 
C) Access 
D) Oracle Database

Question 18

The purpose of a(n)________ is to keep track of things.

Accepted Answer

A) cloud 
B) database 
C) storage folder 
D) application software

Question 19

Managing the impact of database structure changes on applications and users is an operational task for a database administrator.

Accepted Answer

A) True 
 B)False

Question 20

Entities in a data model have ________ that describe the characteristics of the entity.

Accepted Answer

A) characters 
B) primary keys 
C) codes 
D) attributes

Exam 5: Database Processing

Data entry forms are used to read, insert, modify, and delete data.

A DBMS is a software that helps to manage the operating system.

Which of the following is a developmental task of database administration?

In a data model, a(n) ________ is something that a user wants to track.

A group of similar rows or records is called a field.

Attributes are used to describe characteristics of entities.

Normalization is the process of combining two or more tables into a single table.

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

What are application programs and what are their functions?

Some type of locking must be used to coordinate the activities of users who know nothing about one another in order to prevent the lost-update problem.

The data integrity problem occurs if data are duplicated.

Which of the following is a valid observation of MySQL?

SQL is an international standard language for processing a database.

Metadata refer to entities that users of a database want to process.

A primary key used in a database is a ________.

A line in an E-R diagram is used to represent the attributes of the entities.

From among the following, identify the open source DBMS product.

The purpose of a(n) ________ is to keep track of things.

Managing the impact of database structure changes on applications and users is an operational task for a database administrator.

Entities in a data model have ________ that describe the characteristics of the entity.