Oracle 10g Rac

7 Questions

Settings
Please wait...
Oracle Quizzes & Trivia

Questions and Answers
  • 1. 
    Using Oracle Database 10.2 Enterprise Edition, you can create and configure a new ASM instance for a new RAC cluster using which two tools? (Choose two.)
    • A. 

      CRSCTL

    • B. 

      Oracle Universal Installer (OUI)

    • C. 

      Enterprise Manager Grid Control

    • D. 

      Database Configuration Assistant (DBCA)

    • E. 

      .ASMCMD

  • 2. 
    Over a six-month period, you have been regularly monitoring your four-instance RAC database,which is running on the first 4 nodes of a 6-node cluster, by using ADDM and by monitoring wellknown combinations of wait event and statistics in AWR reports. Two weeks ago, a newer version of your main application went live. Starting last week, you noticed a large increase in CPU time (consumed by the three application services on your RAC database) due to increased workload. The OLTP and DSS services have not had a decrease in the percentage of time spent using CPU. However, for the BATCH service the percentage of time spent using CPU has gone down and the wait-time percentage has increased. You want to recommend a tuning exercise to your team. Which two recommendations wouldyou make first, based on the symptoms described? (Choose two.)
    • A. 

      Tune SQL from the BATCH service programs because they may benefit from SQL tuning

    • B. 

      The BATCH service programs may scale well and could benefit from adding new database instances on either node 5 or 6, or on both.

    • C. 

      Tune SQL for the OLTP and DSS service programs because they may benefit from SQL tuning.

    • D. 

      The OLTP and DSS service programs may scale well and could benefit from adding new database instances on either node 5 or 6, or on both.

    • E. 

      The OLTP and DSS service programs may scale well and could benefit from adding new database instances on one or both of nodes 5 and 6, and by adding more nodes the SQL for BATCH service programs would perform better due to more CPU power.

  • 3. 
    To complete a cluster database creation, the DBA must choose the cluster database storage method. Which storage choice is not correct? (Select the incorrect answer.)  
    • A. 

      Cluster File System

    • B. 

      Raw Devices

    • C. 

      Automatic Storage Management (ASM)

    • D. 

      Supported SAN/NAS storage

    • E. 

      Standard UNIX File System

  • 4. 
    What must be true to allow client-server connection to the DBA service? (Select TWO.)
    • A. 

      All the listeners must be reloaded using LSNRCTL RELOAD to recongnize the dynamically created service

    • B. 

      The ALTER SYSTEM REGISTER command must be used to include PMON to register the service with the listeners

    • C. 

      The service must have at least one preferred or available instance that is running and accepting logins

    • D. 

      The services must be started using the SRVCTL START SERVICE command

    • E. 

      The TNSNAMES.ORA file or a name server must contain the net service entries for the DBA service

  • 5. 
    You are asked to investigate a problem regarding client connectivity between the HR service and a database, which is on a four-node RAC cluster. The HR service has four preferred instances on the RAC cluster. This cluster also supports five other services. Occasionally, a client-connect request for the HR service takes several minutes to connect, whereas the other five services connect within a second or two. Client-side and server-side connection load balancing are used for all the services. Which combination of network settings would explain these symptoms? (Select TWO.)
    • A. 

      The TNSNAMES.ORA file has an entry for all six services that uses the host name for the Public IP address and not the Virtual IP Address

    • B. 

      The listener on one or more nodes is listening on both the Public IP Address and the Virtual IP Address and HR TNSNAMES entry uses the Virtual IP Address

    • C. 

      A. The TNSNAMES.ORA file has an entry for the HR service that uses only the most host name for the public IP Address and all the listeners listen on both the Public and Virtual IP addresses

    • D. 

      The listener on one or more nodes is listening only on the virtual IP address and the HR TNSNAME entry uses the hostnames for the virtual IP addresses

    • E. 

      The TNSNAMES.ORA file has an entry for the five other services that use the hostnames for the Virtual IP Addresses and all the listeners listen on both the Public and Virtual IP Addresses

  • 6. 
    Which three types of events can you trap using server-side callouts? (Select THREE.)
    • A. 

      Service cardinality low

    • B. 

      Shadow application service up

    • C. 

      EM Agent down

    • D. 

      Service member down

    • E. 

      Oracle instance up

  • 7. 
    You have migrated your 10g R1 cluster to 10g R2. You wish to create multiple copies of the voting disk. What must you consider when doing this?
    • A. 

      Since ASM is the stated direction of Oracle, ASM is the best storage for voting disks

    • B. 

      If multiplexing, three voting disks on independent devices is ideal

    • C. 

      If multiplexing, two voting disks on independent devices is ideal

    • D. 

      For the voting disk, it is better to rely on multipathing solutions instead of multiplexing