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: Apr 09, 2021

Add To Cart

Question 1

Which three are true about the SQL Tuning Advisor? (Choose three.)

A : checks each query being analyzed for stale statistics.

B : checks each query being analyzed for missing statistics.

C : only recommends syntactic changes to SQL statements.

D : can recommend semantic changes to SQL statements.

E : considers all SQL statements being analyzed by the advisor task as a group.

F : builds SQL profiles for each poorly performing SQL statement to prevent regressions.

Answer: A,B,D

Question 2

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 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 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 : will return an error because creation of a local role is not allowed in CDB$ROOT.

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

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

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

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

Answer: A

Question 5

Identify three benefits of Unified Auditing.

A : creased use ofstorage to store audit trail rowsin the database.

B : improves overall auditing performance.

C : guarantees zero-loss auditing.

D : audit trail cannot be easily modified because it is read-only.

E : automatically audits Recovery Manager (RMAN) events.

Answer: A,B,D

Page: 1 / 57

Total 285 Questions | Updated On: Apr 09, 2021

Add To Cart