Exercise #02 - This exercise reviews Chapter 01.

Question 1

A data definition language (DDL) is a language for specifying the database schema and as well as other properties of the data.
Select one:
a. True
b. False
Feedback
The correct answer is: True

Question 2
A data manipulation language (DML) is a language that enables users to access or manipulate data.
Select one:
a. True
b. False
Feedback
The correct answer is: True

Question 3
A data model is a collection of conceptual tools for describing data, data relationships, data semantics, and data constraints.
Select one:
a. True
b. False
Feedback
The correct answer is: True

Question 4
A database management system (DBMS) consists of a collection of interrelated data and a collection of programs to access that data.
Select one:
a. False
b. True
Feedback
The correct answer is: True
**
Question 5
In two-tier architectures, the back end part is itself broken up into an application server and a database server, while in three-tier architectures, the front end directly communicates with a database running at the back end.
Select one:
a. False
b. True
Feedback
The correct answer is: False

Question 6
The query processor subsystem compiles and executes DDL and DML statements.
Select one:
a. False
b. True
Feedback
The correct answer is: True

Question 7
The storage manager subsystem provides the interface between the low level data stored in the database and the application programs and queries submitted to the system.
Select one:
a. False
b. True
Feedback
The correct answer is: True

Question 8
The transaction management compiles and executes DDL and DML statements.
Select one:
a. False
b. True
Feedback
The correct answer is: False

Question 9
Correct
Mark 1.00 out of 1.00
Not flaggedFlag question
Question text
The feature of describing the entry field in a data dictionary form as ‘text’ is characteristic of
Select one:
a. data manipulation subsystem.
b. data administration subsystem.
c. data definition subsystem.
d. application generation subsystem.
Feedback
The correct answer is: data definition subsystem.

Question 10
Incorrect
Mark 0.00 out of 1.00
Not flaggedFlag question
Question text
The DBA can create user forms and menus using the
Select one:
a. application generation subsystem.
b. data definition subsystem.
c. data administration subsystem.
d. DBMS engine.
Feedback
The application generation subsystem provides tools to enable this task.

The correct answer is: application generation subsystem.