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: Feb 08, 2026

Add To Cart

Question 1

Choose three. Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases?

A : The base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBs.

B : The target PDB must be registered in both the base catalog and the Virtual Private Catalog.

C : The base catalog must be used by RMAN when performing point-in-time recovery for the PDB registered in the Virtual Private Catalog

D : The base catalog must be enabled for Virtual Private Catalog use.

E : The target PDB must be registered in a Virtual Private Catalog.

F : The target PDB must be registered in a base catalog.

Answer: A,C,D

Question 2

Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

A : Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces

B : The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.

C : SPFILE backups can be created while connected to an application root PDB.

D : The BACKUP DATABASE PLUS ARCHIVE LOG command will back up archive logs when RMAN is connected to a PDB.

E : The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.

Answer: A,B

Question 3

Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)

A : orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.

B : root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.

C : The sudo password can be specified in a response file.

D : root.sh can be executed automatically by the Database installer only by using sudo credentials

E : The sudo password must be specified in a response file.

F : The root password cannot be specified in a response file.

Answer: A

Question 4

Choose two. Your SALES_ROOT application container has two application PDBs. The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs. Examine this query and its output: SELECT containers_default, container_map, table_name FROM dba_tables WHERE owner='FIN' ; CONTAINERS_DEFAULT CONTAINER_MAP CONTAINER_MAP_OBJECT TABLE_NAME -------------------------------------------------------------------------------------------------------------------------------NO YES NO REVENUE NO NO YES MAPTABLE Which two are true?

A : The REVENUE table must be a list-partitioned table.

B : The CONTAINERS clause cannot be used in queries on the REVENUE table.

C : The REVENUE table partitions are not pruned across the PDBs automatically

D : The REVENUE table must be a composite-partitioned table.

E : The MAPTABLE table defines a logical partition key on a commonly used column for the REVENUE table.

Answer: C,D

Question 5

Which three are true about the SQL Tuning Advisor? (Choose three.)

A : It checks each query being analyzed for stale statistics.

B : It checks each query being analyzed for missing statistics.

C : It only recommends syntactic changes to SQL statements.

D : It can recommend semantic changes to SQL statements.

E : It considers all SQL statements being analyzed by the advisor task as a group.

F : It builds SQL profiles for each poorly performing SQL statement to prevent regressions.

Answer: A,B,D

Page: 1 / 57

Total 285 Questions | Updated On: Feb 08, 2026

Add To Cart