Free Online Oracle 1Z0-083 Practice Test

Prepare Your Oracle 1Z0-083 Exam Questions with Free online 1Z0-083 Practice Test. Get Brilliant Oracle Database Administration II Exam Results with Valid 1Z0 083 Exam Dumps.

Page: 1 / 57

Total 285 Questions | Updated On: Apr 23, 2024

Question 1

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 2

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

Question 3

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 4

Choose three. Which three are true about cloning databases into an existing CDB with RMAN?

A : A non-CDB can be cloned into a PDB.

B : A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when cloning a PDB.

C : Only one PDB can be cloned at a time.

D : Two or more PDBs can be cloned with the same command.

E : A user with SYSDBA or SYSBKUP must be logged in with RMAN to the non-CDB being cloned when cloning a non-CDB.

F : The target and auxiliary instance passwords must be the same.

Answer: A,B,C

Question 5

Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

A : The number of table rows is considered when evaluating the cost of accessing a table using an index.

B : Index balanced B*Tree height is considered when evaluating the cost of using an index.

C : The Statistics Advisor can help recommend the best way to gather statistics.

D : Statistics collected using DBMS_STATS always yield the best optimizer result.

E : The Statistics Advisor generates actions for all recommendations.

Answer: B,C

Page: 1 / 57

Total 285 Questions | Updated On: Apr 23, 2024