Free Oracle 1Z0-083 Exam Questions

Become Oracle Certified with updated 1Z0-083 exam questions and correct answers

Page: 1 / 57

Total 285 Questions | Updated On: Dec 17, 2025

Add To Cart

Question 1

choose three Which three are true about unified auditing in full mode?

A : The unified audit trail is written to a read-only table.

B : The unified audit trail is written to a read-only external file.

C : Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements.

D : Audit records are created for SYS.

E : Audit records are created for non-sys users.

Answer: A,D

Question 2

choose two Which two statements are true about encrypted backups performed by using RMAN?

A : Transparent encryption of backups uses an encryption wallet.

B : Image copy backups can be created by using password encryption.

C : A password encryption of backups uses the password while creating and restoring backups.

D : Encrypted backups can only be written to disk.

E : A database uses the same encryption key for every encrypted backup.

Answer: A,C

Question 3

T schema owned by the RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open. You execute the RMAN commands: RMAN> CONNECT CATALOG rcl2c/passl2c@catdbl2c RMAN> IMPORT CATALOG rcll/pwdcatll@ractll Which two tasks are performed as part of the import?

A : Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.

B : Recovery catalog is resynchronized with the control files of the registered databases.

C : Imported databases are unregistered from the RC11 catalog.

D : Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.

E : All databases registered in the RC11 catalog are registered in the RC12C catalog.

Answer: A,D

Question 4

A database is configured in ARCHIVE LOG mode. A full RMAN backup exists but no control file backup to trace has been taken. A media failure has occurred. In which two scenarios is incomplete recovery required? (Choose two.)

A : after losing a SYSAUX tablespace data file

B : after losing all members of an INACTIVE online redo log group

C : after losing all members of the CURRENT online redo log group

D : after losing all copies of the control file

E : after losing an UNDO tablespace that is in use

Answer: C,D

Question 5

Choose two. Which two are true about Lockdown profiles in a container database (CDB) and its pluggable databases (PDBs)?

A : A Lockdown profile created from a base Lockdown profile is always automatically modified if the profile on which it is based is modified.

B : A PDB Lockdown profile can be created in an application root.

C : A Lockdown profile created from a base Lockdown profile is never automatically modified if the profile on which it is based is modified.

D : A PDB Lockdown profile can be created in a regular PDB.

E : A PDB Lockdown profile can be created in CDB$ROOT .

Answer: A,B

Page: 1 / 57

Total 285 Questions | Updated On: Dec 17, 2025

Add To Cart