Oracle Database 11g: Administration II
Question No: 51 – (Topic 1)
Examine the CREATE DISKGROUP command used to create a disk group:
SQLgt; CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK #39;ORCL: FRA3#39; NAME misc1, #39;ORCL: FRA4#39; NAME misc2;
In which situation would you use this method of disk group creation?
When two-way disk mirroring is required for the allocation units
When three-way disk mirroring is required for the allocation units
When using hardware mirroring or RAID
When disk mirroring is required for the Automatic Storage Management (ASM) disks
Question No: 52 – (Topic 1)
You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command:
ASMCMDgt; lsdsk -I -d DATA
Which statement is true regarding the outcome of this command?
The command succeeds but it retrieves only the disk names.
The command produces an error because the ASM instance is down.
The command succeeds but it shows only the status of the ASM instance.
The command succeeds and retrieves information by scanning the disk headers based on an
Answer: D Explanation:
See details at Options for the lsdsk command.
-I Scans disk headers for information rather than extracting the information from an Oracle ASM instance. This option forces non-connected mode.
Question No: 53 – (Topic 1)
You issued the following command:
CREATE GLOBAL TEMPORARY TABLE admin_work_area (startdate DATE, enddate DATE, class CHAR(20))
ON COMMIT DELETE ROWS TABLESPACE tbs_t1;
An index is then created on the ADMIN_WORK_AREA temporary table.
Which two statements are true regarding the TBS_T1 tablespace in the above command? (Choose two.)
It stores only the temporary table but not its indexes.
It stores both the temporary table as well as its indexes.
It must be a nondefault temporary tablespace for the database.
It can be a default or nondefault temporary tablespace for the database.
It must be the default temporary tablespace of the user who issues the command.
Question No: 54 – (Topic 1)
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance:
SQLgt; shutdown immediate;
What is the result of executing this command?
The ASM instance is shut down, but the other instances are still running.
It results in an error because other database instances are connected to it.
All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.
Question No: 55 – (Topic 1)
How can you reverse the effects of an ALTER DISKGROUP … DROP DISK command if it has already completed?
Issue the ALTER DISKGROUP … ADD DISK command.
Issue the ALTER DISKGROUP … UNDROP DISKS command.
Issue the ALTER DISKGROUP … DROP DISK CANCEL command.
Retrieve the disk from the Recycle Bin after the operation completes.
Answer: A Explanation:
You cannot UNDROP DISKS if the DROP DISK command has already completed.
Question No: 56 – (Topic 1)
Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)
An ASM instance mounts an ASM control file
An ASM instance uses the ASMB process for rebalancing of disks within a disk group
Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
Question No: 57 – (Topic 1)
Which type of database file is spread across all disks in a disk group?
All types of files are spread across all disks in the disk group.
Redo log files
Archived redo log files
Question No: 58 – (Topic 1)
After executing the command
ALTER DISKGROUP diskgroup2 DROP DISK dg2a;
You issue the following command from the ASM instance:
SELECT group_number, COUNT(*) FROM v$asm_operation;
What is the implication if the query against V$ASM_OPERATION returns zero rows?
The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.
The drop disk operation is complete and you can run the undrop disks command if needed.
The drop disk operation is complete and you cannot run the undrop disks command.
The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance.
None of the above is true.
Answer: C Explanation:
Once the DROP DISK operation is completed, you CANNOT run the UNDROP DISKS command any more.
Question No: 59 – (Topic 1)
You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.
Which parameter should you specify to control the speed of the rebalancing activity?
Question No: 60 – (Topic 1)
Examine the following command:
ALTER DISKGROUP data MOUNT FORCE;
In which scenario can you use the above command to mount the disk group?
when ASM disk goes offline
when one or more ASM files are dropped
when some disks in a disk group are offline
when some disks in a failure group for a disk group are rebalancing
Answer: C Explanation:
In the FORCE mode, Oracle ASM attempts to mount the disk group even if it cannot discover all of the devices that belong to the disk group. This setting is useful if some of the disks in a normal or high redundancy disk group became unavailable while the disk group was dismounted. When MOUNT FORCE succeeds, Oracle
ASM takes the missing disks offline.
If Oracle ASM discovers all of the disks in the disk group, then MOUNT FORCE fails. Therefore, use the MOUNT FORCE setting only if some disks are unavailable. Otherwise, use NOFORCE.
In normal- and high-redundancy disk groups, disks from one failure group can be unavailable and MOUNT FORCE will succeed. Also in high-redundancy disk groups, two disks in two different failure groups can be unavailable and MOUNT FORCE will succeed. Any other combination of unavailable disks causes the operation to fail, because Oracle ASM cannot guarantee that a valid copy of all user data or metadata exists on the available disks.
Refer to here
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|