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 questionsIn 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”).
Keep practicing
Take the free DS0-001 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DS0-001 practice questions
- Question 1Which of the following types of RAID, if configured with the same number and type of disk…
- Question 3Which of the following can be used to protect physical database appliances from damage in…
- Question 4A database administrator is updating an organization's ERD. Which of the following is the…
- Question 6Which of the following database instances are created by default when SQL Server is insta…
- Question 7A database administrator manages a database server that is running low on disk space. A l…
- Question 8Which of the following statements contains an error?
