CertsTopics Logo

Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

1z0-083 Exam Questions Tutorials

Page: 12 / 21
Total 286 questions
Get 1z0-083 Full Access Download 1z0-083 PDF

Oracle Database Administration II Questions and Answers

Question 45

You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference. Which method or feature should you use?

Options:

A.

Database Replay

B.

Automatic Database Diagnostic Monitor (ADDM) Compare Period report

C.

Active Session History (ASH) report

D.

SQL Performance Analyzer

Question 46

Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1. You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT. Which two are always true? (Choose two.)

Options:

A.

CDB1 and CDB2 must be in shared undo mode.

B.

A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.

C.

All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.

D.

Cloning HR_ROOT automatically clones HR_PDB1.

E.

The HR_PDB1clone created in CDB2 will be in mount state when cloning ends.

Question 47

Which two are true about creating RMAN backups for an Oracle container database?

Options:

A.

Online Redo Log backups can be created while connected to CDB$ROOT

B.

Control file backups can be created while connected to CDB$ROOT.

C.

The BACKUP TABLESPACE command can back up a pDB tablespace even if RMAN is connected to CDB$ROOT.

D.

Archived Redo Log backups can be created while connected to PDB

E.

Control file backups can not be created while connected to a PDB

Question 48

Choose three. In a single-instance, multitenant container database (CDB), which three are only ever defined in or part of CDB$ROOT?

Options:

A.

redo logs

B.

control files

C.

all data dictionary metadata

D.

user-defined PL/SQL packages

E.

temporary tablespaces

F.

mandatory Oracle-supplied PL/SQL packages

G.

undo tablespaces

Page: 12 / 21
Total 286 questions
Get 1z0-083 Full Access Download 1z0-083 PDF