Practice 1Z0-083 Exam Online

Question 1

Choose two. Which two are true about RMAN backups when using a media manager?

A : A media manager always writes RMAN requested backups to tape.

B : A media manager is required to create RMAN image copies.

C : A media manager is required to create RMAN proxy copies.

D : The media manager layer (MML) routines provided by Oracle support any vendors' media management products.

E : By default, a request for a proxy copy may result in a backup set being created.

Answer: A

Question 2

Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)

A : orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.

B : root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.

C : The sudo password can be specified in a response file.

D : root.sh can be executed automatically by the Database installer only by using sudo credentials

E : The sudo password must be specified in a response file.

F : The root password cannot be specified in a response file.

Answer: A

Question 3

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

Question 4

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment?

A : AWR snapshots can be created in CDB$ROOT.

B : ADDM can run in a nonroot container.

C : AWR reports can be generated while connected to any container.

D : All AWR data is stored in the CDB$ROOT SYSAUX tablespace.

E : AWR snapshots can be created in a PDB.

F : No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

Answer: A,D

Question 5

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2.
COMMON_USER_PREFIX is set to an empty string. 3. PDB1 is a pluggable database in CDB1. 4. APP1_ROOT is an application container in CDB1. 5. APP1_PDB1 is an application PDB in APP1_ROOT. You execute these commands: S sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> CREATE ROLE role1 CONTAINER=CURRENT; Which is true?

A : It will return an error because creation of a local role is not allowed in CDB$ROOT.

B : ROLE1 will be created only in CDB$ROOT.

C : It will return an error because common roles must start with C##.

D : ROLE1 will be created only in CDB$ROOT and APP1_ROOT.

E : ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.

Answer: A

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