Free Practice Oracle 1Z0-083 Exam Questions 2025

Stay ahead with 100% Free Oracle Database Administration II 1Z0-083 Dumps Practice Questions

Page: 1 / 57

Total 285 Questions | Updated On: Apr 09, 2021

Add To Cart

Question 1

Choose three. Which three are true about a whole database backup?

A :

It can be created only by using RMAN.

B :

It always includes all data files, the current control file, the server parameter file, and archived redo logs.

C :

It can be consistent.

D :

Â It is the only possible backup type for a database in NOARCHIVELOG mode.

E :

It can consist of either backup sets or image copies. F) It can be inconsistent.

Answer: C,D,E

Question 2

Choose three. Which three are true about a container database (CDB)?

A : It can be created from a non-CDB.

B : It can contain only one PDB$SEED, which is created when the CDB is created.

C : It can have local users with the same name in different PDBs.

D : It can contain only one Application Container seed, which is created when the Application Container is created.

E : It can be created by cloning an existing CDB.

F : It can have any number of pluggable databases (PDBs) limited only by space availability.

G : It contains predefined common roles in both the root and the seed.

Answer: A,B

Question 3

choose three Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

A : to allow database duplication without a connection to the target instance

B : to store backup metadata that would cause the controlfile to become too large.

C : to store backups that would cause the controlfile to become too large

D : to report on the database schema at an earlier point in time.

E : to allow database duplication without a connection to the auxiliary instance.

Answer: A,B,D

Question 4

You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for the first time on a server. Examine this command and its outcome: Which two are true? (Choose two.)

A : oracle will be an owner of the Oracle Inventory.

B : oracle must be the owner of every Oracle Database installation

C : oracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation.

D : oracle will be granted the SYSASM privilege when installing the Oracle Database software.

E : The user account, oracle, and group, oinstall, can be used for all Oracle software installations.

Answer: A,C

Question 5

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

Page: 1 / 57

Total 285 Questions | Updated On: Apr 09, 2021

Add To Cart