最新的Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP - 1z0-034免費考試真題
問題1
You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks.
One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours: ALTER DISKGROUP dg01 SET ATTRIBUTE *disk_repair_time' = '5h';
To which disks in the disk group will the new value be applicable?
You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks.
One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours: ALTER DISKGROUP dg01 SET ATTRIBUTE *disk_repair_time' = '5h';
To which disks in the disk group will the new value be applicable?
正確答案: C
說明:(僅 PDFExamDumps 成員可見)
問題2
Which two statements are correct about database transportation? (Choose two.)
Which two statements are correct about database transportation? (Choose two.)
正確答案: C,E
問題3
--- -
Consider the following scenario for your database:
Backup optimization is enabled in RMAN.
The recovery window is set to 7 days in RMAN.
The most recent backup to disk for the TOOLS tablespace was taken on
November 3, 2007.
The TOOLS tablespace is read-only since November 4, 2007.
On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?
--- -
Consider the following scenario for your database:
Backup optimization is enabled in RMAN.
The recovery window is set to 7 days in RMAN.
The most recent backup to disk for the TOOLS tablespace was taken on
November 3, 2007.
The TOOLS tablespace is read-only since November 4, 2007.
On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?
正確答案: D
問題4
Which statements are true regarding system-partitioned tables? (Choose all that apply.)
Which statements are true regarding system-partitioned tables? (Choose all that apply.)
正確答案: B,D
問題5
View the Exhibit and examine the steps that you executed to create a database resource plan.
Subsequently, you execute the following procedure which results in an error: SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );
What could be the reason?

View the Exhibit and examine the steps that you executed to create a database resource plan.
Subsequently, you execute the following procedure which results in an error: SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );
What could be the reason?

正確答案: C
問題6
You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository.
Which condition must be met before you create the VPC?
You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository.
Which condition must be met before you create the VPC?
正確答案: B