[Free] 2018(Jan) Latesttests Testking Oracle 1z0-053 Dumps with VCE and PDF Download 31-40

Latesttests 2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!

Oracle Database 11g: Administration II

Question No: 31 – (Topic 1)

What are three benefits of using ASM? (Choose three.)

  1. Ease of disk administration and maintenance

  2. Load balancing across physical disks

  3. Software RAID-1 data redundancy with double or triple mirrors

  4. Automatic recovery of failed disks

Answer: A,B,C

Question No: 32 – (Topic 1)

What components are present in an ASM instance? (Choose three.)

  1. SGA

  2. Database processes

  3. Database datafiles

  4. Control files

  5. Database parameter file or SPFILE

Answer: A,B,E

Question No: 33 – (Topic 1)

What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?

  1. The number of DBWR processes increases

  2. The number of ASMB processes increases

  3. The number of DBWR_TO_SLAVES increases

  4. The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/O overhead

Answer: D

Question No: 34 – (Topic 1)

What is the proper command to shut down the database in a consistent manner?

  1. shutdown abort

  2. shutdown kill

  3. shutdown nowait

  4. shutdown immediate

  5. shutdown halt

Answer: D

Question No: 35 – (Topic 1)

The ORACLE_SID environment variable is set to ASM. ASMLIB is not used in the

configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance.


Which two activities are performed during a successful start up operation? (Choose two.)

  1. The databases configured to use the ASM instance are mounted

  2. The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter

  3. ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started

  4. ASM discovers and examines the contents of all files that are in the paths specified in the

    ASM_DISKGROUPS initialization parameters

    Answer: B,C Explanation:

    Refer to Starting Up an ASM Instance. To start up an ASM instance, you must:

    1. To connect to the ASM instance with SQL*Plus, you must set the ORACLE_SID environment variable to the ASM SID.

    2. The initialization parameter file, which can be a server parameter file, must contain: INSTANCE_TYPE = ASM

    3. The STARTUP command, tries to mount the disk groups specified by the initialization parameter ASM_DISKGROUPS.

      If ASM_DISKGROUPS is blank, the ASM instance starts and warns that no disk groups were mounted. You can then mount disk groups with the ALTER DISKGROUP…MOUNT command.

      The Cluster Synchronization Services (CSS) daemon is required to enable synchronization between ASM and its client database instances. The CSS daemon is normally started (and configured to start upon reboot) when you use Database Configuration Assistant (DBCA) to create your database. If you did not use DBCA to create the database, you must ensure that the CSS daemon is running before you start the ASM instance.

      Question No: 36 – (Topic 1)

      Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g

      database in a multiprocessor environment.

      At the end of the upgrade, you observe that the DBA executes the following script: SQLgt; @utlrp.sql

      What is the significance of executing this script?

      1. It performs parallel recompilation of only the stored PL/SQL code.

      2. It performs sequential recompilation of only the stored PL/SQL code.

      3. It performs parallel recompilation of any stored PL/SQL as well as Java code.

      4. It performs sequential recompilation of any stored PL/SQL as well as Java code.

Answer: C Explanation:

Recompile invalid objects with utlrp.sql

Question No: 37 – (Topic 1)

Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)

  1. It can be used to back up all data on ASM disks.

  2. It can be used to recover the damaged ASM disk group along with the data.

  3. It can be used to gather information about a pre-existing ASM disk group with disk paths, disk name, failure groups, attributes, templates, and alias directory structure.

  4. It can be used to re-create the ASM disk group with its attributes.

Answer: C,D

Question No: 38 – (Topic 1)

Examine the following ALTER command;


What is the purpose of the command?

  1. It cancels all pending disk drops within the disk group.

  2. It adds previously dropped disks back into the disk group.

  3. It restores disks that are being dropped as the result of a DROP DISKGROUP operation.

  4. It mounts disks in the disk group for which the drop-disk operation has already been completed.

  5. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed.

Answer: A Explanation:

The key point is PENDING.

Question No: 39 – (Topic 1)

Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablspace. A user issues a query on the ORDERS table and receives the following error:

ERROR at line 1:

ORA-01565: error in identifying file #39;/u01/app/oracle/oradata/TEST/temp01.tmp#39; ORA-27037: unable to obtain file status

What would be the most efficient way to rectify this error? ##

  1. Add a new tempfile to the user#39;s temporary tablespace and drop the tempfile that produced the error.

  2. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.

  3. Allow the database to continue running, drop the temp01.tmp temporary file, and then re-create it with new tempfiles.

  4. Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online.

Answer: A

Question No: 40 – (Topic 1)

What is the default AU size of an ASM disk group? What is the maximum AU size in an ASM disk group?

  1. 100KB default, 10TB maximum

  2. 256KB default, 1024MB maximum

  3. 10MB default, 126PB maximum

  4. 64KB default, 1EB maximum

  5. 1MB default, 64MB maximum

Answer: E Explanation:

The AU size is determined at creation time with the allocation unit size (AU_SIZE) disk group attribute. The values can be 1, 2, 4, 8, 16, 32, and 64 MB.

Refer to here

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

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

2018 Latesttests IT Certification PDF and VCE