考题内容摘自 更新时间：2008-9-17
11. Smith is a DBA with ABC Corp. He is in the process of tuning the database. He has received various problem
statements from the customers. Identify three appropriately defined problem statements that Smith can use to tune
the database correctly. (Choose three.)
A.The system is too slow.
B.Online response is very slow.
C.Sometimes the batch process throws errors.
D.The weekly backup took 30 minutes, and earlier it used to take 5 minutes.
E.The batch process is taking 2 hours, whereas it should take only 30 minutes.
F.The system currently has 100 users. We wish to increase the number of users to 250. The users’ response time
should not be affected.
Answer:: DEF
12. Smith is a DBA with XYZ Corp. There are 500 data entry users in an online transaction processing (OLTP)
environment. The current response time is 15-20 seconds. The company wants the response time to be brought
down to 10 seconds or less.
What is the first thing that Smith should do to diagnose the cause of the slow response time?
A.determine whether there is contention for locks
B.determine whether the file system is fast enough
C.determine whether more memory needs to be allocated to PGA
D.determine whether more memory needs to be allocated to SGA
E.determine whether the slow response is wait bound or CPU bound
Answer:: E
13. Which two activities would adversely affect database performance? (Choose two.)
A.doing a soft parse
B.performing archiving
C.less frequent checkpointing
D.defining multiple buffer pools
E.taking online back up of data files
Answer:: BE
14. The following are the tasks that you need to perform to create a resource plan:
A) Creating resource consumer groups
B) Validating pending area
C) Creating a pending area
D) Creating resource plans
E) Creating plan directives
F) Submitting pending area
In which order would you perform these tasks?
A.C, D, A, E, B, F
B.C, B, F, E, A, D
C.C, B, E, D, A, F
D.C, F, E, A, D, B
Answer:: A
15. View the Exhibit and examine the steps to create a database resource plan. Execution of the following
procedure resulted in an error:
SQL> EXECUTE dbms_resource_manager.validate_pending_area();
What could be the reason for this?
A.The ADMINISTER_RESOURCE_MANAGER privilege is not granted to the user.
B.The procedure should be executed before creating the resource plan directive.
C.The SYS_GROUP resource consumer group is not included in the resource plan directive.
D.The OTHER_GROUPS resource consumer group is not included in the resource plan directive.
Answer:: D
阅读(157) | 评论(0) | 转发(0) |
