ITPEC FE Morning October 2023 Question 25

DBMS Definition Function — the function that defines and manages the database schema.

A DBMS has four core functions:

• •Definition function — processes DDL (CREATE, ALTER, DROP) to define the schema (tables, columns, types, constraints)
• •Manipulation function — processes DML (SELECT, INSERT, UPDATE, DELETE) to access and modify data
• •Security function — controls access via GRANT/REVOKE and authentication
• •Recovery function — restores the database after failures using transaction logs and rollback

Why not others:
- (b) Maintenance function — handles backup, reorganization, and performance tuning
- (c) Recovery function — restores data after crashes or failures
- (d) Security function — manages user permissions and access control

Key rule: "Decides the schema" = Definition function (DDL processing).

AI-generated — may contain errors