DS0-001 practice question 5 of 15

Which of the following is the deployment phase in which a DBA ensures the most recent patches are applied to the new database?

Full set: 80 questions
Answer options
A: Importing
B: Upgrading Correct answer
C: Provisioning
D: Modifying
Correct Answer:
B. Upgrading
Explanation

In a typical database-deployment lifecycle, the first operational step is provisioning (creating the instance). The next phase is to bring that fresh instance to the latest supported software level, which is done through patch sets or minor-release updates. Vendor documentation groups this activity under “upgrading/patching,” where the DBA applies the most recent security and bug-fix patches immediately after creation. Therefore, the phase concerned with ensuring a new database has the newest patches is the upgrading phase.

Why Incorrect

A. Importing – Refers to loading data into an existing database; it does not change the database software level.
C. Provisioning – Creates and configures the initial database instance but intentionally precedes the patch/upgrade step.
D. Modifying – Pertains to changing database objects or configurations after deployment, not to applying software patches.

References

1. Oracle Corporation. “Patching and Upgrading Database Deployments,” Oracle Database Cloud Service Admin Guide 19c, Section 6.1, pp. 6-1–6-3.

2. Oracle Enterprise Manager 13c, Database Lifecycle Management Guide, Chap. 2 “Provisioning and Patching Overview,” para. “Upgrade/Patch Phase.”

3. PostgreSQL Global Development Group. “Minor Release Updates (Upgrading),” PostgreSQL 15 Documentation, Sec. 18.6.

4. IBM. “Installing Fix Packs (Upgrading) for Db2 11.5,” IBM Knowledge Center, Tasks > Maintain > Upgrade, Steps 1-3.

5. Stanford University CS145 Course Notes, “Database Administration Lifecycle,” slide set “Deployment and Maintenance,” slide 17 (“Provision → Upgrade/Patch → Data Load”).

Scroll to Top