Oracle 1Z0-058 Online Practice Questions and Exam Preparation

Oracle 1Z0-058 Online Questions & Answers

• Question 31:

  The disk groups on the current ASM instance at version 11.2 were configured to support a version 10.2 database instance. The 10.2 instance has the COMPATIBLE parameter defined as 10.2.0. The compatible.asm attribute is set to 11.2 for each disk group. The database has been upgraded to 11.2. Which statement indicates the proper time to change the compatible.rdbms disk group attribute to 11.2?

  A. Change the disk group attribute after the database instance COMPATIBLE parameter is upgraded to 11.2.
  B. Change the disk group attribute after the database instance is started with the 11.2 software.
  C. Change the disk group attribute after the database instance optimizer_features_enabled parameter is set to 11.2.
  D. Change each disk group after the 11.2 features are required for use on the disk group.
  E. Never, upgrading the attribute is not reversible.
  A. Change the disk group attribute after the database instance COMPATIBLE parameter is upgraded to 11.2.

  ---

  COMPATIBLE.RDBMS The value for the disk group COMPATIBLE.RDBMS attribute determines the minimum COMPATIBLE database initialization parameter setting for any database instance that is allowed to use the disk group. Before advancing the COMPATIBLE.RDBMS attribute, ensure that the values for the COMPATIBLE initialization parameter for all of the databases that access the disk group are set to at least the value of the new setting for COMPATIBLE.RDBMS.

  Oracle?Automatic Storage Management Administrator's Guide 11g Release 2 (11.2)

• Question 32:

  Choose four tools that can be used to create ASM disk groups.

  A. Enterprise Manager
  B. SRVCTL
  C. ASMCMD
  D. CRSCTL
  E. ASMCA
  F. SQL*Plus
  A. Enterprise Manager
  C. ASMCMD
  E. ASMCA
  F. SQL*Plus

• Question 33:

  You plan to use Enterprise Manager to locate and stage patches to your Oracle Home. The software library has been configured to be downloaded to /u01/app/oracle and your "My Oracle Support" credentials have been entered.

  You want to start the provisioning daemon in order to use the deployment procedure manager to view, edit, monitor, and run deployment procedures.

  How would you start the provisioning daemon?

  A. using pafctl start
  B. using crsctl start paf
  C. using srvctl start paf
  D. using emctl start paf
  A. using pafctl start

  ---

  Starting the Provisioning Daemon The provisioning daemon is started with: $ pafctl start Enter repository user password : Enter interval [default 3]: Provisioning Daemon is Up, Interval = 3 D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 4 26

• Question 34:

  In your two-instance RAC database, you find that FAST_START_MTTR_TARGET is set to 300 on both the nodes. The ESTD_CLUSTER_AVAILABLE_TIME column in the V$INSTANCE_RECOVERY view shows the value 100. What is the correct interpretation? (Choose 2)

  A. In the event of an instance failure, the database will become partially available In 100 seconds.
  B. In the event of an instance failure, the database will become fully available in 100 seconds.
  C. In the event of an instance failure, the failed instance will become fully available In 300 seconds.
  D. In the event of an instance failure, the database will become partially available in 200 seconds.
  E. In the event of an instance failure, the failed instance will become available In 300 seconds.
  A. In the event of an instance failure, the database will become partially available In 100 seconds.
  E. In the event of an instance failure, the failed instance will become available In 300 seconds.

  ---

  FAST_START_MTTR_TARGET

  

  FAST_START_MTTR_TARGET enables you to specify the number of seconds the database takes to perform crash recovery of a single instance. When specified, FAST_START_MTTR_TARGET is overridden by LOG_CHECKPOINT_INTERVAL.

  V$INSTANCE_RECOVERY Estimated time (in seconds) that the cluster would become partially available should this instance fail. This column is only meaningful in an Oracle Real Application Clusters (Oracle RAC) environment. In a non- Oracle RAC environment, the value of this column is null.

  Oracle?Database Reference 11g Release 2 (11.2)

• Question 35:

  Which three actions would be helpful in determining the cause of a node reboot?

  A. determining the time of the node reboot by using the uptime command and subtracting the up time from the current system time
  B. looking for messages such as "Oracle CSSD failure. Rebooting for cluster integrity" in /var/log/ messages
  C. using the crsctl command to view tracing information
  D. inspecting the ocssd log for "Begin Dump" or "End Dump" messages
  E. inspecting the database alert log for reboot messages
  A. determining the time of the node reboot by using the uptime command and subtracting the up time from the current system time
  B. looking for messages such as "Oracle CSSD failure. Rebooting for cluster integrity" in /var/log/ messages
  D. inspecting the ocssd log for "Begin Dump" or "End Dump" messages

  ---

  Determining Which Process Caused Reboot

  

  First, determine the time of the node reboot by using the uptime command and subtracting the up time from the current system time. The reboot time will be used when examining log files. When the OCSSD daemon is responsible for

  rebooting a node, a message similar to "Oracle CSSD failure. Rebooting for cluster integrity" is written into the system messages log at /var/log/messages. The cssd daemon log file that is located at /log//cssd/

  ocssd.log may also contain messages similar to "Begin Dump" or "End Dump" just before the reboot. If hangcheck-timer is being used, it will provide message logging to the system messages log when a node restart is initiated by the module.

  To verify whether this process was responsible for the node reboot, examine the /var/log/messages file and look for an error message similar to:

  "Hangcheck: hangcheck is restarting the machine."

  Other useful log files include the Clusterware alert log in /log/ and the lastgasp log in /etc/oracle/lastgasp or /var/opt/oracle/lastgasp. If no indication of which process caused the reboot can be determined from these

  files, additional debugging and tracing may need to be enabled.

  Note: The oclsomon and the oprocd background processes have been eliminated in Oracle Database 11g Release 2.

  D60488GC11

  Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 6 - 21

• Question 36:

  You are ready to add two new nodes called RACNODE 5 and RACNODE 6 to your existing four-node cluster by using addNode.sh.

  You have run cluvfy -peer to check the new nodes against a reference node. When you originally created the cluster, the network administrators chose to statically define the SCAN VIP addresses in the corporate DNS server, and you

  installed the Oracle Grid Infrastructure without using GNS.

  What is the correct way to silently add the nodes?

  A. addNode.sh -silent "CLUSTER_NEW_NODES={RACNODE5, RACNODE6} "
  B. addNode.sh -silent " CLUSTER_NEW_VIRTUAL_HOSTNAMES={RACNODE5-VIP, RACNODE6-VIP} "
  C. addNode.sh -silent "CLUSTER_NEW_NODES={RACNODE5, RACNODE6}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={RACNODE5-VIP, RACNODE6-VIP}"
  D. addNode.sh -silent -responseFile mynewnodes.txt with the response file containing only "CLUSTER_NEW_NODES={RACNODE5, RACNODE6} "
  E. addNode.sh -silent -responseFile mynewnodes.txt With the response file containing "CLUSTER_NEW_VIRTUAL_HOSTNAMES={RACNODE3-VIP, RACNODE4-VIP}"
  C. addNode.sh -silent "CLUSTER_NEW_NODES={RACNODE5, RACNODE6}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={RACNODE5-VIP, RACNODE6-VIP}"

  ---

  Adding a Cluster Node on Linux and UNIX Systems If you are not using GNS, run the following command: $ ./addNode.sh "CLUSTER_NEW_NODES={node3}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={node3vip}"

  Oracle?Clusterware Administration and Deployment Guide 11g Release 2 (11.2)

• Question 37:

  Various clients can access and manipulate ASM files. Which two statements are true?

  A. The DBMS_FILE_TRANSFER.COPY_FILE procedure can move a database file from one ASM to another ASM, but not to an operating system file system.
  B. The ASMCMD cp command can move database files from a file system to ASM, but not from ASM to ASM.
  C. The SQL*Plus command ALTER DISKGROUP orcl MOVE '+DATA/orcl/example01.dbf' to '+OLDDATA/ orcl/example01.dbf' can move the example01 data file to a different diskgroup.
  D. The DBMS_FILE_TRANSFER.GET_FILE procedure reads an ASM file from a remote machine and makes a local copy on an ASM or a file system.
  E. The ASMCMD rm command will delete ASM files and directories, but not database files on an operating system file system.
  D. The DBMS_FILE_TRANSFER.GET_FILE procedure reads an ASM file from a remote machine and makes a local copy on an ASM or a file system.
  E. The ASMCMD rm command will delete ASM files and directories, but not database files on an operating system file system.

  ---

  DBMS_FILE_TRANSFER

  COPY_FILE Procedure

  This procedure reads a file from a source directory and creates a copy of it in a destination directory. The source and destination directories can both be in a local file system, or both be in an Automatic Storage Management (ASM) disk

  group, or between local file system and ASM with copying in either direction. You can copy any type of file to and from a local file system. However, you can copy only database files (such as datafiles, tempfiles, controlfiles, and so on) to and

  from an ASM disk group.

  GET_FILE Procedure

  This procedure contacts a remote database to read a remote file and then creates a copy of the file in the local file system or ASM. The file that is copied is the source file, and the new file that results from the copy is the destination file. The

  destination file is not closed until the procedure completes successfully.

  Examples

  CREATE OR REPLACE DIRECTORY df AS '+datafile' ;

  GRANT WRITE ON DIRECTORY df TO "user";

  CREATE DIRECTORY DSK_FILES AS ''^t_work^'';

  GRANT WRITE ON DIRECTORY dsk_files TO "user";

  -- asumes that dbs2 link has been created and we are connected to the instance. -- dbs2 could be a loopback or point to another instance.

  BEGIN

  -- asm file to an os file

  -- get an asm file from dbs1.asm/a1 to dbs2.^t_work^/oa5.dat DBMS_FILE_TRANSFER.GET_FILE ( 'df' , 'a1' , 'dbs1', 'dsk_files' , 'oa5.dat' ); -- os file to an os file -- get an os file from dbs1.^t_work^/a2.dat to dbs2.^t_work^/a2back.dat

  DBMS_FILE_TRANSFER.GET_FILE ( 'dsk_files' , 'a2.dat' , 'dbs1', 'dsk_files' , 'a2back.dat' ); END ; /

  Oracle?Database PL/SQL Packages and Types Reference 11g Release 2 (11.2) ASMCMD

  cp

  Purpose

  Enables you to copy files between Oracle ASM disk groups and between a disk group and the operating system.

  You can use the cp command to:

  Copy files from a disk group to the operating system Copy files from a disk group to a disk group Copy files from the operating system to a disk group

  rm

  Purpose

  Deletes the specified Oracle ASM files and directories. Oracle?Automatic Storage Management Administrator's Guide 11g Release 2 (11.2)

• Question 38:

  Which command will resize an ACFS file system on the DATA diskgroup?

  -The ADVM volume is named VOL1.

  -The mount point is >/u01/app/oracle/afsmounts/vol1.

  -The new, larger size is 20G.

  A. ASMCMD [+] > volsize -G data -s 20G VOL1
  B. /sbin/acfsutil size 20G /u01/app/oracle/afsmounts/vol1
  C. SQL> ALTER DISKGROUP data RESIZE VOLUME vol1 SIZE 20G;
  D. None, an ACFS file system cannot be resized.
  E. fsadm /u0l/app/orlacle/afsmounts/vol1 20G
  B. /sbin/acfsutil size 20G /u01/app/oracle/afsmounts/vol1

  ---

  acfsutil size Purpose Resizes an Oracle ACFS file system. Syntax and Description acfsutil size -h acfsutil size [+|-]n[K|M|G|T|P ] [device] mount_point acfsutil size -h displays help text and exits. Oracle?Automatic Storage Management Administrator's Guide 11g Release 2 (11.2) ALTER DISKGROUP RESIZE VOLUME Clause Use this clause to change the size of an existing Oracle ADVM volume. In an Oracle ASM cluster, the new size is propagated to all nodes. If an Oracle Automatic Storage Management File System (ACFS) exists on the volume, then you must use the acfsutil size command instead of the ALTER DISKGROUP statement.

  Oracle?Database SQL Language Reference 11g Release 2 (11.2)

• Question 39:

  You have defined two server pools.

  One is called OLTP with MIN_SIZE=3, MAX_SIZE =5 and IMPORTANCE=3. The other is called DSS with MIN_SIZE =2, MAX_SIZE =4 and IMPORTANCE =5. Your cluster currently has four nodes with two nodes in each of the pools. A fifth

  node is added to the cluster. What is true about the server pool to which the node will be assigned?

  A. The node will have the server assigned to the DSS pool because the current size is less than MAX_SIZE and the DSS pool has a greater importance than the OLTP pool.
  B. The node will have the server assigned to the OLTP pool because the OLTP pool's MAX_SIZE is greater than MAX_SIZE of the DSS pool.
  C. The node will have the server assigned to the OLTP pool because the OLTP pool's current size is less than its MIN_SIZE and the DSS pool has enough servers to equal its own MIN_SIZE.
  D. The node will have the server assigned to the DSS pool on the basis of having a greater IMPORTANCE.
  C. The node will have the server assigned to the OLTP pool because the OLTP pool's current size is less than its MIN_SIZE and the DSS pool has enough servers to equal its own MIN_SIZE.

  ---

  Oracle Clusterware continues to assign servers to server pools until the following conditions are met:

  Until all server pools are filled in order of importance to their minimum (MIN_SIZE). Until all server pools are filled in order of importance to their maximum (MAX_SIZE). By default, any servers not placed in a server pool go into the Free

  server pool. Oracle?Clusterware Administration and Deployment Guide 11g Release 2 (11.2)

• Question 40:

  From a command line, you can create an ASM volume with the same properties by using either SQL or ASMCMD. Which two commands will create a 500 MB volume called TESTVOL in the ACFSDG ACFS diskgroup by storing only one copy of the volume file extents in the diskgroup

  A. SQL> alter diskgroup ACFSDG add volume TESTVOL size 500M unprotected;
  B. ASMCMD> volcreate -G ASMFS -s 500M
  C. SQL> alter diskgroup ACFS add volume TESTVOL size 500M;
  D. ASMCMD> volcreate -G ACFSDG -s 500M --redundancy unprotected TESTVOL
  E. SQL> create volume TESTVOL diskgroup ACFSDG size 500M unprotected;
  A. SQL> alter diskgroup ACFSDG add volume TESTVOL size 500M unprotected;
  D. ASMCMD> volcreate -G ACFSDG -s 500M --redundancy unprotected TESTVOL

  ---

  The ALTER DISKGROUP VOLUME SQL statements enable you to manage Oracle ADVM volumes, including the functionality to add, modify, resize, disable, enable, and drop volumes. You can create an Oracle ASM Dynamic Volume

  Manager (Oracle ADVM) volume in a disk group. The volume device associated with the dynamic volume can then be used to host an Oracle ACFS file system. If the volume is hosting an Oracle ACFS file system, then you cannot resize that

  volume with the SQL ALTER DISKGROUP statement. Instead you must use the acfsutil size command.

  volcreate

  Creates an Oracle ADVM volume in the specified disk group.

  Syntax and Description

  volcreate -G diskgroup -s size [ --column number ] [ --width stripe_width ] [--redundancy {high|mirror| unprotected} ]

  Redundancy of the Oracle ADVM volume which can be specified for normal redundancy disk groups. The range of values is as follows: unprotected for non-mirrored redundancy, mirror for double-mirrored redundancy, or high for triple-

  mirrored redundancy. If redundancy is not spe- cified, the setting defaults to the redundancy level of the disk group.