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 21, 2026

Add To Cart

Question 1

Choose two. Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?

A : Data Recovery Advisor can proactively check for failures.

B : Using the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state.

C : ata Recovery Advisor can be used if a database is in the NOMOUNT state.

D : A failure can be closed only if the database is in MOUNT state.

E : Data Recovery Advisor can be used if a database is closed.

Answer: A,B

Question 2

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 3

Choose three. Which three are true about recovering tables using RMAN?

A : RMAN can recover tables owned by the SYSTEM user.

B : RMAN can recover tables owned by the SYS user.

C : RMAN can recover tables in the SYSTEM tablespace.

D : RMAN always uses an auxiliary instance.

E : RMAN can recover a table after a DDL operation has altered the table structure

F : RMAN can recover tables in the SYSAUX tablespace.

G : RMAN can recover tables in a standby database.

Answer: A,D

Question 4

Which two are true about RMAN duplexed backup sets? (Choose two.)

A : A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.

B : A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.

C : A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.

D : A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.

E : A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.

F : A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.

Answer: B,D

Question 5

Which three are true about requirements for various FLASHBACK operations? (Choose three.)

A : FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.

B : FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.

C : FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.

D : FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.

E : FLASHBACK drop requires undo to retrieve all versions of a row that existed two points in time.

F : FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

Answer: A,B

Page: 1 / 57

Total 285 Questions | Updated On: Feb 21, 2026

Add To Cart