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: Apr 02, 2026

Add To Cart

Question 1

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 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

Choose three. Which three are true about RMAN archival backups with the RESTORE POINT clause?

A :

They are never considered obsolete by RMAN.

B :

They can optionally be written to a fast recovery area (FRA).

C :

Â All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database.

D :

Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored.

E :

The SPFILE is included in the archival backup.

F :

Use of a recovery catalog is always required to support the creation and use of archival backups. G)The ARCHIVAL attribute for a backup overrides the RMAN retention policy.

G :

Answer: A,B,D

Question 4

Choose three. Which three are true in Oracle 19c and later releases?

A : Tablespaces always remain in read/write mode during transportable tablespace operations.

B : Tablespaces never remain in read/write mode during transportable tablespace operations.

C : A transportable data pump import can leave a plugged-in tablespace in read-only mode.

D : Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.

E : A transportable data pump import can leave a plugged-in tablespace in read/write mode.

F : An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.

Answer: A,B

Question 5

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

Page: 1 / 57

Total 285 Questions | Updated On: Apr 02, 2026

Add To Cart