Oracle Database Administration II

This certification validates practical skills in enterprise business systems, with emphasis on configuring processes, managing information, and supporting business outcomes. It is intended for professionals who implement or operate enterprise business systems.

Rate this exam

Exam Details

Total Questions

338

Last Updated

Aug. 2026

Rating

4.9

Question Types

Multi choices

338

Get Full Access

Unlimited access to all questions

Detailed explanations for every question

Page progress: 3 / 684%

#11Multiple Choice

Which action takes place when a file checkpoint occurs?

#12Multiple Choice

Examine the structure of the sales table, which is stored in a locally managed tablespace with Automatic Segment Space Management (ASSM) enabled.

You want to perform online segment shrink to reclaim fragmented free space below the high water mark.
What should you ensure before the start of the operation?

#13Multiple Choice

Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle
Database 12c?

#14Multiple Choice

Your database is open and the listener LISTENER is up. You issue the command:

LSNRCTL> RELOAD -
What is the effect of reload on sessions that were originally established by listener?

#15Multiple Choice

Which statement is true regarding the startup of a database instance?