QUESTION 131
When starting up your ASM instance, you receive the following error:
What is the cause of the error?
A. The ASM_DISKGROUPS parameter is configured for three disk groups: DGROUP1, DGROUP2, and
DGROUP3.
The underlying disks for these disk groups have apparently been lost.
B. The format of the ASM_DISKGROUPS parameter is incorrect. It should reference the disk group numbers,
not the names of the disk groups
C. The ASM_POWER_LIMIT parameter is incorrectly set to 1. It should be set to the number of disk groups
being attached to the ASM instance.
D. The ASM_DISKSTRING parameter is not set; therefore disk discovery is not possible.
E. There is insufficient information to solve this problem.
Answer: D
QUESTION 132
As DBA for the Rebel Alliance you have decided that you need to facilitate some redundancy in your database. Using ASM, you want to create a disk group that will provide for the greatest amount of redundancy for your ASM data (you do not have advanced SAN mirroring technology available to you, unfortunately). Which of the following commands would create a disk group that would offer the maximum in data redundancy?
A. CREATE DISKGROUP dg_alliance1 NORMAL REDUNDANCY failgroup diskcontrol1 DISK ,,
c:\oracle\asm_disk\_file_disk3 NAME file_ diska1 failgroup diskcontrol2 DISK ,,
c:\oracle\asm_disk\_file_disk4 NAME file_ diskb1;
B. CREATE DISKGROUP dg_alliance1 EXTERNAL REDUNDANCY failgroup diskcontrol1 DISK
‘c:\oracle\asm_disk\_file_disk3’ NAME file_ diska1;
C. CREATE DISKGROUP dg_alliance1 HIGH REDUNDANCY failgroup diskcontrol1 DISK
‘c:\oracle\asm_disk\_file_disk1’ NAME file_ disk1 failgroup diskcontrol2 DISK ‘
c:\oracle\asm_disk\_file_disk2’ NAME file_ disk2 failgroup diskcontrol2 DISK ‘
c:\oracle\asm_disk\_file_disk3’ NAME file_ disk3;
D. CREATE DISKGROUP dg_alliance1 MAXIMUM REDUNDANCY failgroup diskcontrol1 DISK
‘c:\oracle\asm_disk\_file_disk1’ NAME file_ disk1 failgroup diskcontrol2 DISK ‘
c:\oracle\asm_disk\_file_disk2’ NAME file_ disk2 failgroup diskcontrol2 DISK ‘
c:\oracle\asm_disk\_file_disk3’ NAME file_ disk3 failgroup diskcontrol2 DISK
‘c:\oracle\asm_disk\_file_disk4’ NAME file_ disk4;
E. None of the above
Answer: C
QUESTION 133
You want to migrate your database to ASM, so you have done a clean shutdown, made a closed backup of the entire You wa database, noted the location of your control files and online redo log files, and changed your spfile to use OMF. The last step is to run an RMAN script to do the conversion. Using the following steps, what is the correct order in which the following RMAN commands should be executed?
1. STARTUP NOMOUNT
2. ALTER DATABASE OPEN RESETLOGS
3. SQL “ALTER DATABASE RENAME ,,logfile1 path TO ,,+dgrp4 ,,” # plus all other logfiles
4. SWITCH DATABASE TO COPY
5. BACKUP AS COPY DATABASE FORMAT ,,+dgrp4
6. ALTER DATABASE MOUNT
7. RESTORE CONTROLFILE FROM ,,controlfile_location
A. 2, 5, 3, 1, 7, 6, 4
B. 1, 7, 6, 5, 4, 3, 2
C. 5, 1, 2, 7, 4, 6, 3
D. 7, 3, 1, 5, 6, 2, 4
Answer: B
QUESTION 134
How can you reverse the effects of an ALTER DISKGROUP … DROP DISK command if it has not yet completed?
A. Issue the ALTER DISKGROUP … ADD DISK command.
B. Issue the ALTER DISKGROUP … UNDROP DISKS command.
C. Issue the ALTER DISKGROUP … DROP DISK CANCEL command.
D. Retrieve the disk from the Recycle Bin after the operation completes.
Answer: B
QUESTION 135
To reference existing ASM files, you need to use a fully qualified ASM filename. Your development database has a disk group named DG2A, the database name is DEV19, and the ASM file that you want to reference is a datafile for the USERS02 tablespace. Which of the following is a valid ASM filename for this ASM file?
A. dev19/+DG2A/datafile/users02.701.2
B. +DG2A/dev19/datafile/users02.701.2
C. +DG2A/dev19/users02/datafile.701.2
D. +DG2A.701.2
E. +DG2A/datafile/dev19.users.02.701.2
Answer: B
QUESTION 136
Which background process coordinates the rebalance activity for disk groups?
A. ORBn
B. OSMB
C. RBAL
D. ASMn
Answer: C
QUESTION 137
On the development database rac0, there are six raw devices: /dev/raw/raw1 through /dev/raw/raw6. /dev/raw/raw1 and /dev/raw/raw2 are 8GB each, and the rest are 6GB each. An existing disk group +DATA1, of NORMAL REDUNDANCY, uses /dev/raw/raw1 and /dev/raw/raw2. Which series of the following commands will drop one of the failure groups for +DATA1, create a new disk group +DATA2 using two of the remaining four raw devices, and then
cancel the drop operation from +DATA1?
A. ALTER DISKGROUP DATA1 DROP DISK DATA1_0001;
CREATE DISKGROUP DATA2 NORMAL REDUNDANCY FAILGROUP DATA1A DISK ,,
/dev/raw/raw3 FAILGROUP DATA1B DISK ,,/dev/raw/raw4;
ALTER DISKGROUP DATA1 UNDROP DISKS;
B. ALTER DISKGROUP DATA1 DROP DISK DATA1_0001;
CREATE DISKGROUP DATA2 HIGH REDUNDANCY FAILGROUP DATA1A DISK ‘/dev/raw/raw3’
FAILGROUP DATA1B DISK ‘/dev/raw/raw4;’ALTER DISKGROUP DATA1 UNDROP DISKS;
C. ALTER DISKGROUP DATA1 DROP DISK DATA1_0001;CREATE DISKGROUP DATA2 NORMAL
REDUNDANCY FAILGROUP DATA1A DISK ‘/dev/raw/raw3’ FAILGROUP DATA1B DISK ‘/dev/raw/raw4’;
ALTER DISKGROUP DATA1 UNDROP DATA1_0001;
D. ALTER DISKGROUP DATA1 DROP DISK DATA1_0001 ADD DISK GROUP DATA2 NORMAL
REDUNDANCY FAILGROUP DATA1A DISK ‘/dev/raw/raw3’ FAILGROUP DATA1B DISK ‘/dev/raw/raw4’;
ALTER DISKGROUP DATA1 UNDROP DISKS;
Answer: A
QUESTION 138
Which type of database file is spread across all disks in a disk group?
A. All types of files are spread across all disks in the disk group.
B. Datafiles
C. Redo log files
D. Archived redo log files
E. Control files
Answer: A
QUESTION 139
How can you reverse the effects of an ALTER DISKGROUP … DROP DISK command if it has already completed?
A. Issue the ALTER DISKGROUP … ADD DISK command.
B. Issue the ALTER DISKGROUP … UNDROP DISKS command.
P … DROP DISK CANCEL command.
C. Issue the ALTER DISKGROU
D. Retrieve the disk from the Recycle Bin after the operation completes.
Answer: A
QUESTION 140
Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation?
A. ADD DIRECTORY
B. DROP DISK
C. RESIZE DISK
D. REBALANCE
E. ADD FAILGROUP
Answer: A
If you want to pass Oracle 1Z0-053 successfully, donot missing to read latest lead2pass Oracle 1Z0-053 dumps.
If you can master all lead2pass questions you will able to pass 100% guaranteed.
http://www.lead2pass.com/1Z0-053.html
Lead2pass | Testking | Pass4sure | Actualtests | Others | |
$99.99 | $124.99 | $125.99 | $189 | $29.99-$49.99 | |
Up-to-Dated | ✔ | ✖ | ✖ | ✖ | ✖ |
Real Questions | ✔ | ✖ | ✖ | ✖ | ✖ |
Error Correction | ✔ | ✖ | ✖ | ✖ | ✖ |
Printable PDF | ✔ | ✖ | ✖ | ✖ | ✖ |
Premium VCE | ✔ | ✖ | ✖ | ✖ | ✖ |
VCE Simulator | ✔ | ✖ | ✖ | ✖ | ✖ |
One Time Purchase | ✔ | ✖ | ✖ | ✖ | ✖ |
Instant Download | ✔ | ✖ | ✖ | ✖ | ✖ |
Unlimited Install | ✔ | ✖ | ✖ | ✖ | ✖ |
100% Pass Guarantee | ✔ | ✖ | ✖ | ✖ | ✖ |
100% Money Back | ✔ | ✖ | ✖ | ✖ | ✖ |