Free Oracle 1Z1-083 Practice Test & Real Exam Questions

Exam Code/Number: 1Z1-083
Exam Name/Title: Oracle Database Administration II
Certification Provider: Oracle
Corresponding Certification: Oracle Database 19c

Exam Questions: 283
Updated On: Oct 03, 2026

Question #1

On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days.
Level 0 backups are taken on the 10th, 17th, and 24th of August. Differential level 1 incremental backups are taken daily between the level 0 backups.
Today is the 26th of August.
Which backups will be obsolete?

A. all backups prior to 22nd of August

B. all backups prior to 10th of August

C. all backups prior to 24th of August

D. all backups prior to 17th of August

E. all backups prior to 20th of August

Discussion 0

Correct Answer: D Vote an answer

Question #2

Which three are true about an application container? (Choose three.)

A. It can contain multiple applications.

B. It must have an application seed PDB.

C. Two application containers can share an application seed PDB.

D. It can contain a single application.

E. An application PDB can belong to multiple application containers.

F. It must have an application root PDB.

Discussion 0

Correct Answer: A,D,F Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #3

Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PBD) starting from Oracle 19c? (Choose three.)

A. creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned

B. automatically dropping the database link to the remote database if it already exists

C. creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned

D. creating a database link from CDB$ROOT in the remote database to the PDB in the local database

E. creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database

F. opening the cloned PDB

G. creating a new empty PDB in the local database from PDB$SEED

Discussion 0

Correct Answer: B,C,F Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #4

Which three RMAN persistent settings can be set explicitly?

A. image copy duplexing

B. archive log backup duplexing

C. SPFILE backup duplexing

D. control file auto backup formats

E. archive log deletion policy

F. redo log backup duplexing

Discussion 0

Correct Answer: B,D,E Vote an answer

Question #5

Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

A. The owner of VPC cannot own recovery catalog.

B. The register database privilege should be granted to the virtual catalog owner.

C. The recovery_catalog_owner role should be granted to the virtual catalog owner.

D. A base recovery catalog should exist.

E. At least one target database should be registered in the recovery catalog.

Discussion 0

Correct Answer: A,B,D Vote an answer

Question #6

RMAN has just been connected to a target database and the recovery catalog database.
In which two cases would an automatic partial resynchronization occur between this target database's control file and the RMAN recovery catalog?

A. When a backup of the current SPFILE is created.

B. When any control file metadata for archive log backups or image copies is now older than CONTROL_FILE_RECORD_KEEP_TIME.

C. When the target is first registered.

D. When a new data file is added to a tablespace in a registered target database.

E. When any control file metadata for data file backups or image copies is now older than CONTROL_FILE_RECORD_KEEP_TIME.

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #7

Which two are true about server-generated alerts? (Choose two.)

A. Stateless alerts can be purged manually from the alert history.

B. Stateless alerts can be cleared manually.

C. Stateless alerts are automatically cleared.

D. Stateful alerts must be created by a DBA after resolving the problem.

E. Stateful alerts are purged automatically from the alert history.

Discussion 0

Correct Answer: A,B Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #8

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output:

Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?

A. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.

B. Re-createthepasswordfileintheOracleDatabase12cformat. Correct

C. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

D. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.

E. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

Discussion 0

Correct Answer: C,E Vote an answer

Question #9

Which two are true about the Optimizer Statistics Advisor?

A. It runs automatically every night by default. E) It can be run only automatically.

B. It can recommend changes to improve the statistics gathering process.

C. It always analyzes all schemas in the database.

D. It can be run only manually.

Discussion 0

Correct Answer: A,B Vote an answer

Question #10

Which three statements are true about Flashback Data Archive?

A. While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive.

B. A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.

C. To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.

D. To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database

E. Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.

Discussion 0

Correct Answer: A,B,E Vote an answer

Question #11

Which three are true about the FLASHBACK DATABASE feature? (Choose three.)

A. Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.

B. FLASHBACK LOGS are archived after a log switch.

C. It requires that the target database be in ARCHIVELOG mode.

D. FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.

E. A database can be flashed back using SQL*PLUS.

F. It always generates REDO and UNDO.

Discussion 0

Correct Answer: C,E,F Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Download Free Oracle 1Z1-083 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z1-083 exam.