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: Dec 06, 2025

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 three Which three are true about unified auditing in full mode?

A : The unified audit trail is written to a read-only table.

B : The unified audit trail is written to a read-only external file.

C : Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements.

D : Audit records are created for SYS.

E : Audit records are created for non-sys users.

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

Choose two. Which two are true about memory advisors?

A : If Automatic Memory Management is enabled, no memory advisors are available.

B : If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.

C : All memory advisors use data from Automatic Workload Repository

D : If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.

E : If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.

Answer: C,D

Question 5

You must transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination platforms have different endian formats.
Examine this list of actions:
1. Make the UNIVERSITY tablespace read-only on the source system.
2. Export the UNIVERSITY tablespace metadata using EXPDP.
3. Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.
4. Copy the UNIVERSITY tablespace data files to the destination system.
5. Copy the Data Pump dump set to the destination system.
6. Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.
7. Import the UNIVERSITY tablespace metadata using IMPDP.
8. Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

A : 1,2,4,5,7,8

B : 1,2,4,6,7,8

C : 1,2,3,4,5,7,8

D : 1,2,3,4,5,6,7,8

E : 2,4,5,6,7

Answer: C

Page: 1 / 57

Total 285 Questions | Updated On: Dec 06, 2025

Add To Cart