HP HP0-850 认证题库

1.If a system has 4GB of memory and the 4GT tuning feature has not been applied, what is the maximum amount of RAM that can be allocated to Oracle9i?

A: 1GB

B: 2GB

C: 3GB

D: 4GB

 

2.In which section of the Oracle StatsPack report can you find the size of the redo log buffer?

 

A: instance and cache information

B: instance efficiency percentages

C: load profile

D: top 5 timed events

 

3.Click the Exhibit button.

 

You query the V$PGA_TARGET_ADVICE view to determine the ideal size of the process global area (PGA) and retrieve the results listed in the table displayed in the Exhibit.  If you want to prevent PGA memory over-allocation, what should be the minimum size of the PGA?

A: 125MB

B: 250MB

C: 375MB

D: 1500MB

 

4.What measures the scalability deviation from perfect (linear) scalability?

 

A: processor scale-up

B: processor speed-up

C: scalability curve

D: scalability slope

 

5.What measures the absolute performance gains resulting from an increased number of processors?

 

A: processor scale-up

B: processor speed-up

C: scalability curve

D: scalability slope

 

6.If you have a high volume of random disk I/O requests, what provides the highest disk subsystem performance?

 

A: fast transfer protocol

B: large number of disk drives and proper data distribution

C: large number of high-bandwidth disk controllers

D: low number of fast-spinning disk drives

 

7.To improve storage efficiency and performance, relational database management systems allocate disk space in sets of contiguous pages that are called:

 

A: keys.

B: freelists.

C: clusters.

D: extents.

 

8.What is the minimum online redo log storage required by the ProLiant Transaction Processing Sizer for Oracle9i?

 

A: 1 hour

B: 1 day

C: 2 days

D: 5 days

 

9.When can raw partitions improve the performance of Oracle9i?

 

A: when your database server is memory-bound

B: when your database server is processor-bound

C: when your database server has four or more processors

D: when two or more Oracle9i Real Application Clusters instances are deployed per cluster node

 

10.Your disk subsystem volume contains ten 9.1GB, 10K-rpm disk drives with a random I/O requests-per-second rate of 90. You have deployed RAID 0 over these drives. You measure a combined logical transfer rate of 1500 I/O requests-per-second and determine that the disk queue length for this volume is 67. What should you do to increase the system performance?

 

A: Both the random I/O requests-per-second rate per disk drive and the disk queue length indicate a disk bottleneck. Add more disk controllers.

B: Both the random I/O requests-per-second rate per disk drive and the disk queue length indicate that the disk subsystem is not a performance bottleneck. An investigation into other system areas is necessary.

C: The random I/O requests-per-second rate per disk drive indicates a disk bottleneck, which is also confirmed by the longer-than-recommended disk queue length. Adding more disk drives is necessary to increase the performance.

D: The random I/O requests-per-second rate per disk drive indicates a disk bottleneck, which is also confirmed by the longer-than-recommended disk queue length. Before adding more disk drives, an analysis of the memory utilization is necessary.