Practice 1Z0-083 Exam Online

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

Which three are true about opatch auto? (Choose three.)

A : It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.

B : It must be invoked by a user with root user privileges.

C : Patches are applied via opatchauto.

D : Users must always input patch plans to opatchauto.

E : It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.

F : It applies patches in nonrolling mode by default.

G : It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

Answer: A,B

Question 4

Choose two. Which two are true about a Recovery Manager (RMAN) duplication without a TARGET connection?

A : The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

B : RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

C : The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

D : The UNDO TABLESPACE clause is never required.

E : RMAN 'pushes' the backups of the database to be duplicated over the network to the auxiliary instance.

Answer: A,B

Question 5

Choose two. You want to install Oracle Grid Infrastructure for a Standalone Server using Oracle Universal Installer (OUI). There is no existing Oracle installation on the server. Which two are prerequisites?

A : an operating system user to own this installation

B : the Oracle Inventory group oinstall

C : an operating system account called grid

D : a group called dba

E : the installation of Oracle ASMLIB

Answer: A,B

Name:	Oracle Database Administration II
Exam Code:	1Z0-083
Certification:	Oracle Database
Vendor:	Oracle
Total Questions:	285
Last Updated:	Apr 25, 2024

Oracle 1Z0-083