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: Jan 12, 2026

Add To Cart

Question 1

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 2

Choose the best answer. SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases. Which action could help in the performance management of these regressed SQL statements?

A : Create SQL plan directives for each of the regressed statements.

B : Use The SQL Tuning Advisor for each of the regressed statements.

C : Create an adaptive execution plan for each of the regressed statements

D : Use the SQL Access Advisor for each of the regressed statements.

Answer: B

Question 3

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 4

Choose three. Which three are true about a whole database backup?

A :

It can be created only by using RMAN.

B :

It always includes all data files, the current control file, the server parameter file, and archived redo logs.

C :

It can be consistent.

D :

Â It is the only possible backup type for a database in NOARCHIVELOG mode.

E :

It can consist of either backup sets or image copies. F) It can be inconsistent.

Answer: C,D,E

Question 5

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

Page: 1 / 57

Total 285 Questions | Updated On: Jan 12, 2026

Add To Cart