Create Next App

Exam contains 145 questions

Page 7 of 25

Question 37 🔥

Examine the following ALTER command:SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;What is the purpose of the command?

Which database solution meets these requirements?

A. It cancels all pending disk drops within the disk group.

Highly voted

B. It adds previously dropped disks back into the disk group.

Highly voted

C. It restores disks that are being dropped as the result of a DROP DISKGROUP operation.

Highly voted

D. It mounts disks in the disk group for which the drop-disk operation has already been completed.

Highly voted

E. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed.

Highly voted

Discussion of the question

Question 38 🔥

You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database.Which two statements are true?

Which database solution meets these requirements?

A. You must ensure that the SALES database is mounted or open.

Highly voted

B. You must restore a backup control file to perform a block media recovery.

Highly voted

C. You must take the tools01.dbf data file offline before you start a block media recovery.

Highly voted

D. You must put the database in NOARCHIVELOG mode to perform a block media recovery.

Highly voted

E. You can perform only a complete media recovery of individual blocks, point-in-time recovery of individualdata blocks is not supported.

Highly voted

Discussion of the question

Question 39 🔥

Which statement is true regarding the creation of nested plans using the Oracle Resource Manager?

Which database solution meets these requirements?

A. Only one nested subplan is allowed per parent plan

Highly voted

B. The plans can be nested up to four levels.

Highly voted

C. Nested plans only control resources used by recursive SQL

Highly voted

D. Nested plans control only the degree of parallelism and I/O requests

Highly voted

E. Each nested plan gets a proportion of the CPU resources assigned to its parent group.

Highly voted

Discussion of the question

Question 40 🔥

There was media failure and you decide to check the data files for block corruption. Which would you use to create a report on any corruptions found?

Which database solution meets these requirements?

A. the DBNEWID utility

Highly voted

B. the DBVERIFY utility

Highly voted

C. the ANALYZE command

Highly voted

D. the RMAN REPORT command

Highly voted

E. the RMAN CROSSCHECK command

Highly voted

F. the CHECK_OBJECT procedure of the DBMS_REPAIR package

Highly voted

Discussion of the question

Question 41 🔥

You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure.Which statement is true in this situation?

Which database solution meets these requirements?

A. The online redo log files and archived redo log files are required to accomplish the recovery

Highly voted

B. The uncommitted transaction will be committed at the next startup of the database instance

Highly voted

C. The uncommitted transaction is rolled back automatically at the next opening of the database

Highly voted

D. The DBA has to perform the recovery on the database to recover the uncommitted transaction

Highly voted

Discussion of the question

Question 42 🔥

Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization parameter to a nonzero value?

Which database solution meets these requirements?

A. The MTTR advisor will be disabled.

Highly voted

B. Automatic checkpoint tuning will be enabled.

Highly voted

C. The value for the LOG_CHECKPIONT_INTERVAL initialization parameter will be override the value for FAST_START_MTTR_TARGET.

Highly voted

D. The time taken to recover the instance after the crash is always exactly the same as the value given for the FAST_START_MTTR_TARGET initialization

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_034

Exam contains 145 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us