Oracle Database Administration II Practice Questions - Oracle Database Administration II (1Z0-083) Exam - Oracle Database Administration II Practice Questions - Oracle Database Administration II (1Z0-083) Exam

Question 1

You want to create a new pluggable database named SALESPDB inside an existing multitenant container database by copying the PDB$SEED. Which statement creates it correctly?

CREATE PLUGGABLE DATABASE salespdb ADMIN USER pdbadmin IDENTIFIED BY pwd; CREATE DATABASE salespdb USING SEED; ALTER CONTAINER DATABASE ADD PLUGGABLE salespdb; CREATE PDB salespdb FROM PDB$SEED OPEN;

Correct Answer:

CREATE PLUGGABLE DATABASE salespdb ADMIN USER pdbadmin IDENTIFIED BY pwd;

Question 2

A newly created PDB shows OPEN_MODE of MOUNTED in V$PDBS after the CDB instance restarts. Which action ensures the PDB opens automatically the next time the CDB starts?

Set the CDB initialization parameter OPEN_PDBS=ALL. ALTER PLUGGABLE DATABASE salespdb SAVE STATE; while it is open. ALTER PLUGGABLE DATABASE salespdb OPEN PERSISTENT; Add the PDB to the spfile with ALTER SYSTEM SET PDB_OPEN=ON;

Correct Answer:

ALTER PLUGGABLE DATABASE salespdb SAVE STATE; while it is open.

Question 3

Before you can plug an unplugged PDB into a target CDB, you should verify compatibility. Which procedure or function reports whether the PDB is compatible with the target CDB?

DBMS_PDB.DESCRIBE DBMS_PDB.RECOVER DBMS_PDB.CHECK_PLUG_COMPATIBILITY DBMS_PDB.EXPORTRMANBACKUP

Correct Answer:

DBMS_PDB.CHECK_PLUG_COMPATIBILITY

Question 4

You unplug a PDB with ALTER PLUGGABLE DATABASE hrpdb UNPLUG INTO '/tmp/hrpdb.xml'. Immediately afterward, what is the state of HRPDB in the source CDB?

It is dropped from the CDB and its datafiles are deleted. It is automatically converted into a non-CDB. It continues to open READ WRITE for application access. It remains in the CDB in MOUNTED state and cannot be opened until it is dropped or replugged.

Correct Answer:

It remains in the CDB in MOUNTED state and cannot be opened until it is dropped or replugged.

Question 5

You must clone an open PDB named PRODPDB into the same CDB as a hot clone for testing. What must be true about PRODPDB for a hot clone to succeed?

The source CDB must be in ARCHIVELOG mode and local undo must be enabled. PRODPDB must be in READ ONLY mode. PRODPDB must first be unplugged. The CDB must be shut down to NOMOUNT.

Correct Answer:

The source CDB must be in ARCHIVELOG mode and local undo must be enabled.

Exam overview

About this Exam

Prepare with the Oracle Database Administration II Practice Questions - Oracle Database Administration II (1Z0-083) Exam practice quiz. This question bank includes 100 questions covering database, rman, command, flashback, and want. Use it to review important concepts, identify knowledge gaps, and build confidence for the related exam, course, or assessment.

More details

Additional Information

Oracle Database Administration II Practice Questions - Oracle Database Administration II (1Z0-083) Exam

This practice set contains 100 questions from the matching question bank and focuses on database, rman, command, flashback, and want. Work through each question carefully, review the provided solutions, and revisit topics that need more study before your next attempt.

This is an independent study resource intended for practice and review; it is not an official examination or an endorsement by any organization named in the title.

Quiz information

Frequently Asked Questions

The complete question count is available after full access is unlocked.

No fixed duration is currently configured for this quiz.

Question explanations are included where they are available in the quiz content, helping you review the reasoning after answering.

Yes. You can retake the practice test again as you continue studying during your available access period.

After your access is confirmed, you can continue into the complete practice exam from this quiz flow.

Unless explicitly stated otherwise, this page provides independent practice material for study and exam preparation and is not the official examination itself.

Correct Answer:

Correct Answer:

Correct Answer:

Correct Answer:

Correct Answer:

About this Exam

Additional Information

Oracle Database Administration II Practice Questions - Oracle Database Administration II (1Z0-083) Exam

Frequently Asked Questions

Related Questions

3F5 CDC Administration Practice Exam

3F571 Administration Craftsman Practice Exam

3F571 Administration Craftsman Practice Exam.

ArcGIS Online Administration Associate Practice Test

ArcGIS Online Administration Associate Practice Test

Certified Professional in IACUC Administration (CPIA) Practice Exam