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

Pass Using 1z0-083 Exam Dumps

Page: 19 / 21
Total 286 questions

Oracle Database Administration II Questions and Answers

Question 73

Choose the best answer. You want to transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination platforms have the same endian Examine this list of steps:. 1. Make the UNIVERSITY tablespace read-only on the source 2. Export the UNIVERSITY tablespace metadata using EXPDP. 3. Create a cross-platform backup set from the UNIVERSITY source system, using an RMAN command that includes the DATAPUMP clause. 4. Copy the cross-platform backup sets to the destination system. 5. Copy the Data Pump dump set from the source to the destination system. 6. Restore the cross-platform backup set on the destination system using an RMAN command that includes the DATAPUMP clause. 7. Import the UNIVERSITY tablespace metadata using IMPDP. 8. Make the UNIVERSITY tablespace read/write on the destination system. Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY tablespace?

Options:

A.

3,4,6

B.

2,3,4,5,6,7

C.

1,3,4,6,8

D.

1,2,3,4,5,6,7,8

Question 74

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog. You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host. How would you achieve this?

Options:

A.

by using the RMAN switch command to set the new location for the data files

B.

by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host

C.

by using the RMAN duplicate command with dbid and set new name for tablespace to recover the database to the new host

D.

by creating a new database in the new host, and then using the RMAN recover command

Question 75

Choose three. Which three are true about Data Pump in an Oracle multitenant environment?

Options:

A.

It can be used to transport data from a non-CDB to a PDB.

B.

It can be used to clone a CDB.

C.

It can be used to transport data between PDBs.

D.

It can be used to transport data from a PDB to a non-CDB.

E.

It can be used to create a new PDB.

Question 76

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.

Page: 19 / 21
Total 286 questions