New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: Board70

1z0-083 Reviews Questions

Page: 8 / 21
Question 32

Choose two. Which two are true about PDB archive files?

Options:

A.

DBMS_PDB.CHECK_PLUG_COMPATIBILITY can be run against a PDB archive.

B.

They contain a PDB manifest file and all the data files in uncompressed form for a PDB.

C.

They contain all the data files only in uncompressed form for a PDB.

D.

They must be created using the DBMS_PDB package.

E.

They contain a PDB manifest file and all the data files in compressed form for a PDB.

F.

They contain all the data files only in compressed form for a PDB.

Question 33

Choose two. Which two are true about monitoring waits for sessions and services?

Options:

A.

V$SERVICE_EVENT displays wait counts for every wait event for each service even including counts of zero for waits that never occurred.

B.

V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.

C.

V$SESSION_WAIT and V$SESSION both contain details of the event on which a waiting session is currently waiting.

D.

V$SESSION_EVENT displays all waits events for those events that have occurred at least once for sessions that have now terminated.

E.

V$SESSION_WAIT_CLASS displays waits broken down by wait class only for terminated sessions.

Question 34

Choose two. Some archived log backups have been accidentally deleted from storage. Which two commands should be used to update the status of backups in the recovery catalog to display only the missing backups?

Options:

A.

RESYNC CATALOG

B.

CROSSCHECK BACKUP OF ARCHIVELOG ALL

C.

LIST ARCHIVELOG ALL

D.

LIST EXPIRED

E.

LIST ARCHIVELOG

F.

REPORT OBSOLETE

Question 35

1.Which two are prerequisites for creating a backup-based duplicate database?

Options:

A.

connecting to the target database and a recovery catalog to execute the duplicate command

B.

creating a password file for an auxiliary instance

C.

connecting to an auxiliary instance

D.

matching the database identifier (DBID) of the source database and the duplicate database

E.

creating an SPFILE for the target database

Page: 8 / 21
Exam Code: 1z0-083
Exam Name: Oracle Database Administration II
Last Update: Dec 22, 2024
Questions: 286
1z0-083 pdf

1z0-083 PDF

$25.5  $84.99
1z0-083 Engine

1z0-083 Testing Engine

$28.5  $94.99
1z0-083 PDF + Engine

1z0-083 PDF + Testing Engine

$40.5  $134.99