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

Choose three. Which three are true about the FLASHBACK DATABASE feature?

A : FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.

B : It requires that the target database be in ARCHIVELOG mode.

C : FLASHBACK LOGS are archived after a log switch.

D : A database can be flashed back using SQL*PLUS.

E : It always generates REDO and UNDO.

F : Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.

Answer: A,B,D

Question 2

Choose two. Which two statements are true when row-archival management is enabled?

A : The ORA_ARCHIVE_STATE column may only be queried by users with the DBA role set.

B : The ORA_ARCHIVE_STATE column is only displayed if it is referenced in the column select list of a query

C : The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows.

D : The ORA_ARCHIVE_STATE column may only be updated by users with the DBA role set.

E : The ORA_ARCHIVE_STATE column is updated in an overnight maintenance job based on activity tracking.

Answer: B,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

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

Question 5

Which two statements are true when row archival management is enabled?

A : The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.

B : The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.

C : The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.

D : The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.

E : The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active. Correct

Answer: B,D

Page: 1 / 57

Total 285 Questions | Updated On: Jan 12, 2026

Add To Cart