[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-053 Dumps with VCE and PDF 51-60

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-053.html

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?

  1. When two-way disk mirroring is required for the allocation units

  2. When three-way disk mirroring is required for the allocation units

  3. When using hardware mirroring or RAID

  4. When disk mirroring is required for the Automatic Storage Management (ASM) disks

Answer: C

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?

  1. The command succeeds but it retrieves only the disk names.

  2. The command produces an error because the ASM instance is down.

  3. The command succeeds but it shows only the status of the ASM instance.

  4. The command succeeds and retrieves information by scanning the disk headers based on an

ASM_DISKSTRING value.

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.)

  1. It stores only the temporary table but not its indexes.

  2. It stores both the temporary table as well as its indexes.

  3. It must be a nondefault temporary tablespace for the database.

  4. It can be a default or nondefault temporary tablespace for the database.

  5. It must be the default temporary tablespace of the user who issues the command.

Answer: B,D

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?

  1. The ASM instance is shut down, but the other instances are still running.

  2. It results in an error because other database instances are connected to it.

  3. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.

  4. HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.

Answer: B

Question No: 55 – (Topic 1)

How can you reverse the effects of an ALTER DISKGROUP … DROP DISK command if it has already completed?

  1. Issue the ALTER DISKGROUP … ADD DISK command.

  2. Issue the ALTER DISKGROUP … UNDROP DISKS command.

  3. Issue the ALTER DISKGROUP … DROP DISK CANCEL command.

  4. 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.)

  1. An ASM instance mounts an ASM control file

  2. An ASM instance uses the ASMB process for rebalancing of disks within a disk group

  3. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly

  4. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

Answer: C,D

Question No: 57 – (Topic 1)

Which type of database file is spread across all disks in a disk group?

  1. All types of files are spread across all disks in the disk group.

  2. Datafiles

  3. Redo log files

  4. Archived redo log files

  5. Control files

Answer: A

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?

  1. The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.

  2. The drop disk operation is complete and you can run the undrop disks command if needed.

  3. The drop disk operation is complete and you cannot run the undrop disks command.

  4. The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance.

  5. 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?

  1. ASM_POWER_LIMIT

  2. ASM_DISKSTRING

  3. ASM_DISKGROUPS

  4. INSTANCE_TYPE

Answer: A

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?

  1. when ASM disk goes offline

  2. when one or more ASM files are dropped

  3. when some disks in a disk group are offline

  4. 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

100% Ensurepass Free Download!
Download Free Demo:1z0-053 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-053 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *