Difficulty: Easy
Correct Answer: Modifying existing records or adding new record occurrences (routine DML)
Explanation:
Introduction / Context:
Terminology matters in data operations. ‘‘Updating a database’’ in everyday practice usually refers to changing the stored data values—adding new rows and editing or deleting existing rows—not reorganizing files or altering the schema.
Given Data / Assumptions:
Concept / Approach:
Data Manipulation Language (DML) covers INSERT, UPDATE, and DELETE. These change record occurrences and values. By contrast, physical reorganization is a performance/maintenance task, and schema revision is a DDL change. Therefore, ‘‘updating’’ maps to modifying or adding record occurrences.
Step-by-Step Solution:
Verification / Alternative check:
Job logs and audit trails label content changes as updates, inserts, and deletes; structural changes are tracked separately as migrations.
Why Other Options Are Wrong:
Common Pitfalls:
Using ‘‘update’’ ambiguously; always separate content edits from structural or physical maintenance activities.
Final Answer:
Modifying existing records or adding new record occurrences (routine DML)
Discussion & Comments