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

Add To Cart

Question 1

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

Question 2

Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

A : It analyzes a period of time corresponding to the 12 hours of activity.

B : It runs automatically after each AWR snapshot.

C : A DBA can run it manually.

D : Results are written to the alert log.

E : It analyzes a period of time corresponding to the last day of activity.

Answer: B,C

Question 3

Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database?

A : DBUA must be launched from the target Oracle Home.

B : Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.

C : A whole database backup must exist before upgrade.

D : The Pre-Upgrade Information Tool script is executed by DBUA.

E : All pluggable databases are automatically upgraded as part of a container database upgrade.

F : The database must be opened in read-only mode.

Answer: A,D

Question 4

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 5

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

Page: 1 / 57

Total 285 Questions | Updated On: Mar 21, 2026

Add To Cart