An administrator is planning a cluster running applications in 3 separate resource groups. RGA - Database 1 RGB - Web Server RGC - Database 2 Database 1 and Database 2 must be online before the Web Server. All resource groups have a Startup Policyof Onli

第1题：

A technical specialist has a requirement to implement a 4-way POWER5 server with a small Web server partition and a high performance database server partition. The Web server provides a client front-end to the database server. The most important concerns are speed of communication between the Web server and the database and I/O speed of the database. Which of the following virtualization features would be most appropriate？（）

• A、Virtual SCSI
• B、Virtual Ethernet
• C、Virtual I/O Server
• D、Micro-Partitioning

第2题：

The resource group configuration for a four node cluster is shown below：Which resource groups will be acquired by node N2 if it joins the cluster first？（）

• A、rgC、rgE
• B、rgC、rgD
• C、rgE、rgB、rgD
• D、rgC、rgD、rgE

第3题：

An enterprise has three nodes： -Node ’A’ is a production database， -Node ’B’ is a production  Application server， and -Node ’C’ is a test and development node. Node ’C’ is used by six programmers to develop and the production application as business critical and would like to make it highly available with HACMP. Application development and testing is not business critical.  Which of the following describes the best solution？（）  

• A、 There is not an adequate solution because HACMP should not be configured in this environment without a dedicated standby node.
• B、 Nodes ’A’ and ’B’ should be configured in a cluster with mutual fallover of two cascading resource groups to provide both nodes will deliver acceptable response time with both resource groups.
• C、 Nodes ’A’ and ’C’ should be configured in one cluster， and Nodes ’B’ and ’C’ in another cluster to prevent both the database and application server from falling over to Node ’C’ at the same time.
• D、 Nodes ’A’， ’B’， and ’C’ should be configured in a cluster with Node ’C’ the hot standby for both the database and application server resource groups. Workload Manager （WLM） must be configured on database and application developers from over utilizing the CPU resources.

第4题：

Company.com has a resource group that contains a database that is accessed by a web client  based on another system. The communication to the database is TCP/IP. Occasionally after a failure， the end users get unusual error messages that indicate the database server is not available. It has been determined that the web server is trying to access the database server’s information before it has completed file system recovery after a failure.  How can HACMP affect this problem？（）   

• A、 HACMP can resequence the order to the starting of the various resource group elements by utilizing Dynamic Node Priority.
• B、 The order of dependency can be controlled though the HACMP resource group configuration if the web server was made to be part of the HACMP cluster.
• C、 HACMP can delay making the network label available until after the filesystem checks have completed with the "filesystem mounted before IP is configured".
• D、 The IP service label can be in a second resource group allowing the sequential processing of resource groups to control when the IP service label is made available.

第5题：

You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（）  

• A、 V$SYSSTAT
• B、 V$SESSSTAT
• C、 V$RSRC_PLAN
• D、 V$RSRC_CONSUMER_GROUP

第6题：

Your database instance is currently configured to support 1，500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the server all the time.  You want to increase the scalability by configuring the database instance to handle more connections. Asa DBA，  which configuration would you set to support more than 1，500 connections at a time（）

• A、You would configure more listeners for the database.
• B、You would configure the database in shared server mode to use the connection pooling feature.
• C、You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.
• D、You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.

第7题：

Which two statements are true concerning the Resource Manager plans for individual pluggabledatabases (PDB plans) in a multitenant container database (CDB)?（）

• A、If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that pdb.
• B、In a PDB plan, subplans may be used with up to eight consumer groups.
• C、If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the cdb.
• D、If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
• E、If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

第8题：

In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server？ （）

• A、increase the size of the redo log buffer
• B、increase the number of redo log groups
• C、increase the number of log writer processes
• D、increase the number of ARCn processes
• E、change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location

第9题：

第10题：

第11题：

第12题：

第13题：

An administrator has configured a two node cluster， Node1 and Node2 with two resource groups， RG1 andRG2. The resource groups are configured as follows： RG1： Participating Nodes： Node1， Node2 Startup Policy： Online On Home Node Only Fallover Policy： Fallover To Next Priority Node In The List Fallback Policy Never Fallback RG2： Participating Nodes： Node2， Node1 Startup Policy： Online On Home Node Only Fallover Policy： Fallover To Next Priority Node In The List Fallback Policy： Fallback To Higher Priority NodeIn The List An Online on Different Nodes Dependency has been configured as：High Priority Resource Groups： RG2 Intermediate Priority Resource Group： RG1 The cluster has been running without any problems with both resource groups on their home nodes whenNode1 suffers a critical operating system problem causing the node to halt.What is the status of the resource groups？（）（）

• A、RG1 is Online RG2 is Online
• B、RG1 is Online RG2 is Offline
• C、RG1 is Offline RG2 is Online
• D、RG1 is Offline RG2 is Offline

第14题：

Company.com has a database application and a Web server application running on the same p5-570 server in a single partition. Recently there have been a number of instances where the increased load on the database server has impacted the performance of the Web server. What can the technical specialist recommend to keep the database application from impacting the performance of the Web server？（）

• A、Create a VLAN between the web server and database server.
• B、Purchase APV and install the VIOS.
• C、Increase the priority of the Web server.
• D、Create separate LPARs for Web and database workloads.

第15题：

During initial cluster planning session， a requirement is mandated that application monitoring will  Be used to monitor the production database and three application servers. Since all the application servers rely on the database being active， only one resource group has been planned to manage the starting/stopping of the cluster resources.  How ill the initial design impact the use of application monitoring？（）  

• A、 Only one application server per resource group can be monitored.
• B、 Process monitoring is part of RSCT and requires no special scripts.
• C、 Any application can be monitored as long as it has an application server.
• D、 Having all application servers in one resource group improves recovery time.

第16题：

An administrator has a two-node PowerHA cluster in a mutual takeover configuration. He needs to updatefrom 5.5 service pack 1 to 5.5 service pack 2. Which of the following actions will perform the updates with norisk of disruption to applications running in the cluster？（）

• A、Unmanage resource groups on all nodes， update the cluster filesets， start cluster services on all nodes，ensure cluster services stabilize
• B、Update the cluster filesets on all nodes. Run ’refresh -s clstrmgrES’ on one node， wait for the cluster tostabilize， repeat for all other nodes
• C、Unmanage resource groups on one node， update the cluster filesets， start cluster services. Wait for thecluster to stabilize and repeat for all other nodes.
• D、Bring resource groups （RGs） online on all nodes concurrently， bring RGs offline on one node， update thecluster filesets， bring RGs online， repeat for all other nodes

第17题：

Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）

• A、archival
• B、log writer
• C、database writer
• D、system monitor
• E、process monitor
• F、change tracking writer

第18题：

You work as a database administrator for Certkiller .com. In your production  database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task？（）

• A、You must have started the database instance in restricted mode.
• B、You must have started the database instance inNORMALmode.
• C、You must have started the database instance with server parameter file.
• D、You must have started the database instance but must not have mounted.
• E、You must have started the database instance but must not have opened.

第19题：

You are the Database Administrator for WonderWeb， which has recently acquired a media company TXGlobal. You have been assigned the task to migrate all the database applications of TXGlobal to the database server of WonderWeb. To accommodate more database applications， you need to add disks to the existing disk group. Whenever you add or remove disks from the disk group， Automatic Storage Management （ASM） rebalancing distributes the data evenly across all the disks of the disk group. Which background process performs this actual rebalancing activity， resulting in the movement of data extents in the disk groups？（）  

• A、 ASMB
• B、 ARBn
• C、 RBAL in the ASM instance
• D、 RBAL in the database instance

第20题：

You have lost all your online redo logs. As a result， your database has crashed. You have tried to restart the database and clear the online redo log files， but when you try to open the database you get the following error.   SQL> startup ORACLE instance started.  Total System Global Area 167395328 bytes Fixed Size 1298612 bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database mounted.  ORA-00313： open failed for members of log group 2 of thread 1 ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3  ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3  SQL> alter database clear logfile group 2； alter database clear logfile group 2 * ERROR at line 1：  ORA-01624： log 2 needed for crash recovery of instance orcl （thread 1） ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log   What steps must you take to resolve the error？（） a. Issue the recover database redo logs command.  b. Issue the Startup Mount command to mount the database.  c. Restore the last full database backup.  d. Perform a point-in-time recovery， applying all archived redo logs that are available.  e. Restore all archived redo logs generated during and after the last full database backup.  f. Open the database using the alter database open resetlogs command.  g. Issue the alter database open command.

• A、b， a， f
• B、e， b， a， f
• C、e， b， a， g
• D、b， a， g
• E、c， e， b， d， f

第21题：

第22题：

第23题：