Newly Released Oracle 1z0-083 Exam PDF

Oracle Database Administration II Questions and Answers

Question 13

Which three statements are true about Automatic Workload Repository (AWR)?

Options:

All AWR tables belong to the SYSTEM schema.

The AWR data is stored in memory and in t he database.

The snapshots collected by AWR are used by the self-tuning components in the database

AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.

AWR contains system wide tracing and logging information.

Question 14

choose two Examine these RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which two statements are true about the DUPLICATE command?

Options:

It succeeds.

It fails because no parallel channels are allocated for the auxiliary database.

It fails because connection to the AUXILIARY instance must be as SYSDBA.

Itsucceeds only if the target database is greater than 400M.

No catalogued backup of the TARGET is used to duplicate the database.

Question 15

You must transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination platforms have different endian formats.

Examine this list of actions:

1. Make the UNIVERSITY tablespace read-only on the source system.

2. Export the UNIVERSITY tablespace metadata using EXPDP.

3. Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.

4. Copy the UNIVERSITY tablespace data files to the destination system.

5. Copy the Data Pump dump set to the destination system.

6. Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.

7. Import the UNIVERSITY tablespace metadata using IMPDP.

8. Make the UNIVERSITY tablespace read/write on the destination system.

Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

Options:

1,2,4,5,7,8

1,2,4,6,7,8

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

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

2,4,5,6,7

Question 16

Choose the best answer. On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days. Level 0 backups are taken on the 10th, 17th, and 24th of August. Differential level 1 incremental backups are taken daily between the level 0 backups. Today is the 26th of August. Which backups will be obsolete?

Options:

all backups prior to 10th of August

all backups prior to 22nd of August

all backups prior to 20th of August

all backups prior to 24th of August

all backups prior to 17th of August

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

Oracle Database Administration II Questions and Answers

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer: