Oracle Database Administration II

Multiple-choice and multiple-response questions delivered in English at a testing centre or online proctored. Some items describe a scenario and ask which action or command sequence is correct. Multi-response items usually state how many answers to select, so read the stem carefully before committing.

The official certifying body publishes the current question count, time limit, and passing score, and those figures change between releases. Check the exam page on the Oracle certification site before you schedule. Do not rely on numbers quoted in forums or older study guides.

Harder, mainly because the scenarios are less forgiving. Administration I rewards knowing what a feature does; Administration II rewards knowing which feature applies to a specific failure. Candidates who have never performed an incomplete recovery or cloned a PDB under time pressure typically find the backup and multitenant sections the toughest.

Retakes are permitted, but Oracle sets the waiting period and fee, and those terms are published on its certification site rather than fixed here. Check the retake policy before booking so you can plan a second attempt. Use the score report's section breakdown to target the weakest domain rather than rereading everything.

Start with RMAN configuration and backup strategy, because restore and recovery and Flashback all build on it. Then take multitenant architecture before provisioning and cloning, since cloning assumes CDB/PDB fundamentals. Leave performance monitoring and SQL tuning until last; they are largely independent and easier to absorb once the rest is solid.

You need to recognise correct syntax and, more importantly, understand the effect of each clause. Questions often hinge on whether a backup is consistent, whether archivelogs are included, or whether a restore needs a specific until time. Practise typing commands in a lab until the options make sense rather than memorising them.

Confusing restore with recover, mixing up Flashback Database with Flashback Table, and assuming a PDB operation behaves like the same operation on a non-CDB. Another frequent trap is choosing an RMAN option that works but is slower or less safe than the intended answer. Read every option before selecting.

Yes. Several objectives, including Data Recovery Advisor, PDB relocation, and transportable tablespaces, are difficult to answer confidently from reading alone. Build a small container database, create a pluggable database, break it deliberately, and fix it. An hour of guided practice is worth several hours of passive review.

Only on the official Oracle certification website. Question count, duration, price, passing score, retake rules, and score validity are all published there and are updated periodically. This page deliberately omits those numbers because they change and because no authoritative source was supplied for this draft.