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: Jun 25, 2025

Add To Cart

Question 1

Which two are true about Oracle Flashback features? (Choose two.)

A : FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVE D REDO LOG files.

B : FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVE D REDO LOG files.

C : FLASHBACK TABLE can undrop a column.

D : FLASHBACK DROP can undrop an index when undropping a table.

E : After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.

Answer: A,D

Question 2

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 3

Identify three benefits of Unified Auditing.

A : Decreased use ofstorage to store audit trail rowsin the database.

B : It improves overall auditing performance.

C : It guarantees zero-loss auditing.

D : The audit trail cannot be easily modified because it is read-only.

E : It automatically audits Recovery Manager (RMAN) events.

Answer: A,B,D

Question 4

Choose three. Your container database, CDB1, is in local undo mode. You successfully execute this command while connected to CDB1: CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES= (CONNECT) CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1' ; Which three are true about PDB1?

A :

It has the same common users defined as does CDB1.

B :

It has only local roles.

C :

It has the same number of roles as CDB1.

D :

Service PDB1 is created for remote logins to PDB1.

E :

It is in mount state after creation.

F :

It has no local users.

Answer: A,B,D

Question 5

Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)

A : A PDB snapshot is always a full copy of the source PDB.

B : A PDB snapshot is always a sparse copy of the source PDB.

C : A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.

D : A PDB snapshot depends on a storage snapshot which can be stored on any file system.

E : A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.

F : A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.

G : A snapshot copy PDB can be created from a stand-alone clone PDB.

Answer: A,C

Page: 1 / 57

Total 285 Questions | Updated On: Jun 25, 2025

Add To Cart