Free Oracle 1Z0-058 Exam Dumps Questions & Answers

Examine the following output:
[oracIe@gr5153 ~]$ sudo crsctl config crs CRS-4622: Oracle High Availability Services autostart is enabled. [oracIe@gr5153 ~]$ srvctl config database -d RACDB -a Database unique name: RACDB Database name: RACDB Oracle home : /u01/app/oracle/product/l11.2.0/dbhome_1 Oracle user: oracle Spfile: +DATA/ RACDB /spfileRACDB.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: POOL1 Database instances: Disk Groups: DATA, FRA Services: Database is enabled Database is policy managed
Oracle Clusterware is started automatically after the system boot. Which two statements are true regarding the attributes of RACDB?

• A.You must manually start RACD
• B.Database resource Is not managed by crsd for high availability and needs to be restarted manually if it fails.
• C.Database resource is managed by crsd for high availability and may be automatically restarted in place if it fails.
• D.Oracle Clusterware automatically starts RACDB.

Which three statements are true about using RMAN with ASM?

• A.Using RMAN, database files can be migrated to ASM from a file system.
• B.RMAN can use ASM storage for backups.
• C.RMAN is the only supported method to back up database files stored in ASM.
• D.Using RMAN, database files cannot be moved from ASM to a file system
• E.RMAN is the only supported method to back up ACFS files.
• F.RMAN cannot use ASM storage for backups.

You want to reorganize the DATA diskgroup while continuing database operations. The DATA diskgroup was created using normal redundancy having one disk per failure group. The two disks used are /dev/sdal and /dev/sda2.
You plan to drop the existing disks and add the /dev/sdb1 and /dev/sdb2 disks to failure group FG_C and the /dev/sdcl and /dev/sdc2 disks to failure group FG_D.
Which procedure would you use to minimize the effect of the I/Os of this reorganization on ongoing database operations?

• A.Set rebalance power to 9 for diskgroup DATA. Add failure group FG_C with all the /dev/sdb disks.
  Add failure group FG_D with all the /dev/sdc disks.
  Drop disks /dev/sda1 and /dev/sda2.
  Set rebalance power to 0 for diskgroup DATA.
• B.Set rebalance power to 0 for diskgroup DATA.
  Add failure group FG_C with all the /dev/sdb disks.
  Add failure group FG_D with all the /dev/sdb disks.
  Drop disks/dev/sda1 and /dev/sda2.
  Set rebalance power to 9 for diskgroup DATA.
• C.Set rebalance power to 0 for diskgroup DAT
  Add failure group FG_C with all the /dev/sdb disks.
  Add failure group FG_D with all the /dev/sdc disks.
  Drop disks/dev/sda1 and /dev/sda2.
  Set rebalance power to 1 for diskgroup DATA.
• D.Set rebalance power to 0 for diskgroup DATA
  Drop disks /dev/sdal and /dev/sdb disks.
  Add failure group FG_C with all the /dev/sdb disks.
  Add failure group FG_D with all the /dev/sdc disks
  Set rebalance power to 1 for diskgroup DATA.

Various clients can access and manipulate ASM files. Which two statements are true?

• A.The ASMCMD cp command can move database files from a file system to ASM, but not from ASM to ASM.
• B.The SQL*Plus command ALTER DISKGROUP orcl MOVE '+DATA/orcl/example01.dbf' to '+OLDDATA/orcl/example01.dbf' can move the example01 data file to a different diskgroup.
• C.The ASMCMD rm command will delete ASM files and directories, but not database files on an operating system file system.
• D.The DBMS_FILE_TRANSFER.GET_FILE procedure reads an ASM file from a remote machine and makes a local copy on an ASM or a file system.
• E.The DBMS_FILE_TRANSFER.COPY_FILE procedure can move a database file from one ASM to another ASM, but not to an operating system file system.

The System Global Area (SGA) for the ASM instance contains distinct memory areas. Choose three areas that are contained within the ASM SGA.

• A.Buffer Cache
• B.Shared Pool
• C.Log Buffer
• D.Streams Pool
• E.Large Pool
• F.ASM Cache