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

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: 21 – (Topic 1)

Which of the following is not a configurable attribute for an individual disk group?

  1. AU_SIZE

  2. COMPATIBLE.RDBMS

  3. COMPATIBLE.ASM

  4. DISK_REPAIR_TIME

  5. DG_DROP_TIME

Answer: E Explanation:

DG_DROP_TIME is an invalid DG attribute.

Disk Group Attributes

The DISK_REPAIR_TIME disk group attribute specifies how long a disk remains offline before ASM drops the disk.

The COMPATIBLE.ASM attribute determines the minimum software version for an ASM instance that uses the disk group.

The COMPATIBLE.RDBMS attribute determines the minimum COMPATIBLE database initialization parameter setting for any database instance that uses the disk group.

The AU_SIZE attribute determines the allocation unit size of the disk group. The values can be 1, 2, 4, 8, 16, 32, and 64 MB.

Question No: 22 – (Topic 1)

You are managing Oracle Database 11g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours:

ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H;

Which statement is true in this scenario?

  1. It starts the ASM fast mirror resync.

  2. All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.

  3. It drops all disk paths from the dga disk group.

  4. All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.

Answer: D Explanation:

Ensurepass 2018 PDF and VCE

C:\Users\albo\Desktop\1-1.jpg

Question No: 23 – (Topic 1)

Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal.

Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks? (Choose two.)

  1. Define the POWER option while adding or removing the disks.

  2. Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.

  3. Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES.

  4. Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES.

Answer: A,B Explanation:

ARBn (ASM Rebalance Process): Rebalances data extents within an ASM disk group, possible processes are ARB0-ARB9 and ARBA.

ALTER DISKGROUP..POWER clause, specify a value from 0 to 11, where 0 stops the rebalance operation and 11 permits Oracle ASM to execute the rebalance as fast as possible. The value you specify in the POWER clause defaults to the value of the ASM_POWER_LIMIT initialization parameter. If you omit the POWER clause, then Oracle ASM executes both automatic and specified rebalance operations at the power determined by the value of the ASM_POWER_LIMIT initialization parameter.

Note:

Beginning with Oracle Database 11g Release 2 (11.2.0.2), if the COMPATIBLE.ASM disk group attribute is set to 11.2.0.2 or higher, then you can specify a value from 0 to 1024 in the POWER clause.

Question No: 24 – (Topic 1)

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?

Ensurepass 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: A

Question No: 25 – (Topic 1)

Which of the following is a benefit of ASM fast disk resync?

  1. Failed disks are taken offline immediately but are not dropped.

  2. Disk data is never lost.

  3. By default, the failed disk is not dropped from the disk group ever, protecting you from loss of that disk.

  4. The failed disk is automatically reformatted and then resynchronized to speed up the recovery process.

  5. Hot spare disks are automatically configured and added to the disk group.

Answer: A Explanation:

ASM Fast Mirror Resync

Question No: 26 – (Topic 1)

ASM supports all but which of the following file types? (Choose all that apply.)

  1. Database files

  2. SPFILEs

  3. Redo-log files

  4. Archived log files

  5. RMAN backup sets

  6. Password files

  7. init.ora files

Answer: F,G Explanation:

What Types of Files Does Oracle ASM Support?

Ensurepass 2018 PDF and VCE

C:\Users\albo\Desktop\1-1.jpg

Question No: 27 – (Topic 1)

What are the advantages of variable extent size support for large ASM files? (Choose two.)

  1. It improves resync operations when the disk comes online after being taken offline for maintenance purposes.

  2. It improves performance in the extended cluster configuration by reading from a local copy of an extent.

  3. Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool.

  4. This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents.

Answer: C,D

Question No: 28 – (Topic 1)

Users are connected to a database instance that is using Automatic Storage Management (ASM). The DBA executes the command as follows to shut down the ASM instance:

SQLgt; SHUTDOWN IMMEDIATE;

What happens to the database instance?

  1. It shuts down long with the ASM instance.

  2. It is aborted and the ASM instance shuts down normally.

  3. It stays open and SHUTDOWN command for the ASM instance fails.

  4. It shuts down only after all pending transactions are completed and the ASM instance waits for this before shutting down.

Answer: C Explanation:

IMMEDIATE or TRANSACTIONAL Clause (link)

Oracle ASM waits for any in-progress SQL to complete before performing an orderly dismount of all of the disk groups and shutting down the Oracle ASM instance. Oracle ASM does not wait for users currently connected to the instance to disconnect. If any database instances are connected to the Oracle ASM instance, then the SHUTDOWN command returns an error and leaves the Oracle ASM instance running. Because the Oracle ASM instance does not contain any transactions, the TRANSACTIONAL mode behaves the same as IMMEDIATE mode.

Question No: 29 – (Topic 1)

As the DBA, you run the following query on your ASM instance. What is the implication of the results of the query? (Choose two.)

SQLgt; select group_number, name, state from v$ASM_DISKGROUP; GROUP_NUMBER NAME STATE

============ ======= ========== 0 DGROUP1 DISMOUNTED

  1. DGROUP2 MOUNTED

  2. DGROUP3 MOUNTED

    1. The DGROUP1 disk group was unmounted by another DBA.

    2. A datafile has been lost, causing the ASM disk group DGROUP1 to go into the DISMOUNTED state

    3. One of the redundant disks (DGROUP1) has been lost in a disk group.

    4. This query has no meaning in an ASM instance.

    5. A disk associated with a disk group was discovered after the ASM instance initially opened.

    Answer: A,E

    Question No: 30 – (Topic 1)

    How can you reverse the effects of an ALTER DISKGROUP … DROP DISK command if it has NOT yet 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: B

    100% Ensurepass Free Download!
    Download Free Demo:1z0-053 Demo PDF
    100% Ensurepass Free Guaranteed!
    Download 2018 EnsurePass 1z0-053 Full Exam PDF and VCE

    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 *