Database System Environment

Question 1

Enumerate the DBMS Component Modules

Answer 1

• DDL compiler
• Query compiler
• Pre-compiler
• DML compiler
• Runtime database processor
• Stored data manager

Question 2

Processes schema definition stores it in the catalog.

Answer 2

DDL compiler

Question 3

Handles high-level queries.

Answer 3

Query compiler

Question 4

Extracts DML commands from an application program.

Answer 4

Pre-compiler

Question 5

Compilation of DML commands into object code.

Answer 5

DML compiler

Question 6

Handles database accesses at runtime.

Answer 6

Runtime database processor

Question 7

Data transfer between disk & main memory.

Answer 7

Stored data manager

Question 8

Enumerates the Database System Utilities

Answer 8

• Loading
• Backup
• File reorganization:

Question 9

i. Used to load existing data files into the database.
ii. The source file format and the target data file structure are mentioned to the
utility.–> automatically reformats the data —> stores it in the database.

Answer 9

Loading

Question 10

• Creates a backup copy of the database.
• Incremental backups are often used. Though it is complex, it saves space.

Answer 10

Backup

Question 11

Used during the design of the database.

Answer 11

CASE tools

Question 12

Storing catalog information.

Answer 12

Data Dictionary (or data repository)

Question 13

Provides an environment for developing database applications.
Ex. JBuilder, PowerBuilder System

Answer 13

Application Development Environment

Question 14

Remote access to the database.

Answer 14

Communications software