Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 681:

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

  A. Database files

  B. SPFILEs

  C. Redo-log files

  D. Archived log files

  E. RMAN backup sets

  F. Password files

  G. init.ora files

  Correct Answer: FG

  What Types of Files Does Oracle ASM Support?

  

• Question 682:

  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?

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

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

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

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

  E. None of the above is true.

  Correct Answer: C

  Once the DROP DISK operation is completed, you CANNOT run the UNDROP DISKS command any more.

• Question 683:

  What is the net effect of the following command?

  alter diskgroup dgroup1 drop disk abc;

  A. The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command, the data on that disk will be lost.

  B. The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.

  C. The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete, the disk will be dropped.

  D. This command will fail because you cannot drop a specific disk in an ASM disk group.

  E. The disk drop command will be suspended for a predetermined amount of time, waiting for you to also issue an alter diskgroup rebalance command. Once you have issued the rebalance command, ASM will proceed to rebalance the disk group and then drop the disk.

  Correct Answer: C

• Question 684:

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

  A. AU_SIZE

  B. COMPATIBLE.RDBMS

  C. COMPATIBLE.ASM

  D. DISK_REPAIR_TIME

  E. DG_DROP_TIME

  Correct Answer: E

  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 685:

  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: SQL> @utlrp.sql

  What is the significance of executing this script?

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

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

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

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

  Correct Answer: C

  Recompile invalid objects with utlrp.sql

• Question 686:

  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?

  A. ASM_POWER_LIMIT

  B. ASM_DISKSTRING

  C. ASM_DISKGROUPS

  D. INSTANCE_TYPE

  Correct Answer: A

• Question 687:

  What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? (Choose all that apply.)

  A. ORACLE_BASE should be set explicitly.

  B. An Oracle base should have only one Oracle home created in it.

  C. Flash recovery area and data file location should be on separate disks.

  D. Flash recovery area and data file location should be created under Oracle base in a non- Automatic Storage Management (ASM) setup.

  Correct Answer: ACD

• Question 688:

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

  A. The number of DBWR processes increases

  B. The number of ASMB processes increases

  C. The number of DBWR_TO_SLAVES increases

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

  Correct Answer: D

• Question 689:

  Identify three key features of ASM. (Choose three.)

  A. file striping

  B. allocation unit mirroring

  C. automatic disk rebalancing

  D. automatic file size increment

  E. automatic undo management

  Correct Answer: ABC

• Question 690:

  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:

  SQL> shutdown immediate;

  What is the result of executing this command?

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

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

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

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

  Correct Answer: B