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

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.

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.

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”).