Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 631:

  What elements of globalization can be explicitly defined using the NLS_LANG environment variable? (Choose all that apply.)

  A. NLS_LANGUAGE

  B. NLS_SORT

  C. NLS_CALENDAR

  D. NLS_CHARACTERSET

  E. NLS_TERRITORY

  Correct Answer: ADE

• Question 632:

  Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B? (Choose all that apply.)

  A. A must contain all of the characters defined in B.

  B. A must be Unicode.

  C. The encoded values in A must match the encoded values in B for all characters defined in B.

  D. A must be a multi-byte character set.

  E. The encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B.

  Correct Answer: AC

• Question 633:

  The NLS_SORT parameter sets the default sort method for which of the following operations? (Choose all that apply.)

  A. WHERE clause

  B. ORDER BY clause

  C. BETWEEN clause

  D. NLSSORT function

  E. NLS_SORT function

  Correct Answer: AD

• Question 634:

  View Exhibit1 to examine the CRS11G disk group when all the disks are online. View Exhibit2 to examine the CRS11G disk group when one disk is offline.

  Why is the rebalancing not performed and the content of the disk group not empty in Exhibit2?

  ASM-disk-group-1 (exhibit): ASM-disk-group-2 (exhibit):

  

  

  A. Because the disk group is created with NORMAL redundancy

  B. Because the disk repair time attribute is set to a nonzero value

  C. Because the mirrored extents cannot be rebalanced across the other three disks

  D. Because the other three disks have 60% free space, the disk rebalancing is delayed

  Correct Answer: B

  Key points:

  1.

  The COMPATIBILITY.ASM>=11.1 and COMPATIBILITY.RDBMS>=11.1

  2.

  The DISK_REPAIR_TIME is set to non-zero. by default it is 3.6hr.

  Refer to here.

  Note: To use this feature, the disk group compatibility attributes must be set to 11.1 or higher. For more information, refer to "Disk Group Compatibility".

  Oracle ASM fast resync keeps track of pending changes to extents on an OFFLINE disk during an outage.

  The extents are resynced when the disk is brought back online. By default, Oracle ASM drops a disk in 3.6 hours after it is taken offline. You can set the DISK_REPAIR_TIME disk group attribute to delay the drop operation by specifying a

  time interval to repair the disk and bring it back online.

• Question 635:

  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 '/u01/app/oracle/oradata/TEST/temp01.tmp' ORA-27037: unable to obtain file status

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

  A. Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.

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

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

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

  Correct Answer: A

• Question 636:

  You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1.

  Which two statements are true in this scenario for the features enabled for ASM? (Choose two.)

  A. The ASM-preferred mirror read feature is enabled.

  B. The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.

  C. The ASM disk is dropped immediately from a disk group when it becomes unavailable.

  D. The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.

  Correct Answer: AB

• Question 637:

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

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

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

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

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

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

  Correct Answer: BD

• Question 638:

  You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:

  ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h';

  To which disks in the disk group will the new value be applicable?

  A. all disks in the disk group

  B. all disks that are currently in OFFLINE mode

  C. all disks that are not currently in OFFLINE mode

  D. all disks in the disk group only if all of them are ONLINE

  Correct Answer: C

  Check out the answer options, it is tricky. The NOT OFFLINE disks equals ONLINE disks. Refer to Set the DISK_REPAIR_TIME Disk Group Attribute Appropriately. The DISK_REPAIR_TIME disk group attribute specifies how long a disk remains offline before Oracle ASM drops the disk. If a disk is made available before the DISK_REPAIR_TIME parameter has expired, the storage administrator can issue the ONLINE DISK command and Oracle ASM resynchronizes the stale data from the mirror side. In Oracle Database 11g, the online disk operation does not restart if there is a failure of the instance on which the disk is running. You must reissue the command manually to bring the disk online.

• Question 639:

  The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You d the following command to startup the Automatic Storage Management (ASM) instance.

  SQL> STARTUP;

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

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

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

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

  D. ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters

  Correct Answer: BC

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

  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:

  ASMCMD> lsdsk -I -d DATA

  Which statement is true regarding the outcome of this command?

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

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

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

  D. The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.

  Correct Answer: D

  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.