<center id="7hpxh"></center>

<ol id="7hpxh"><small id="7hpxh"></small></ol>

<samp id="7hpxh"></samp>

1z0-043單項(xiàng)選擇題每日一練(2019.01.12)

單項(xiàng)選擇題
In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（）
A. Recovery catalog
B. Oracle Enterprise Manager Repository
C. Automatic Workload Repository （AWR）
D. Oracle 10g Enterprise Manager Grid Control
E. Automatic Database Diagnostic Monitor （ADDM）
單項(xiàng)選擇題
Your system performs heavy transaction processing between 8：00 A.M. and 5：00 P.M. but runs batch processing and reports after that. You decide to create a separate resource plan to govern resource allocation for each time period. Which scheduler object will you use to switch automatically between the two resource plans？（）
A. Window
B. Program
C. Job_Class
D. Window group
單項(xiàng)選擇題
Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）
A. functions
B. package
C. procedure
D. database trigger
E. anonymous PL/SQL block
單項(xiàng)選擇題
You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan？（）
A.assign users to consumer groups
B.set the resource plan for the instance
C.configure a simple resource plan and specify plan directives
D.configure a complex resource plan and specify plan directives
單項(xiàng)選擇題
You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA？（）
A. SQL Tuning Advisor
B. Undo Advisor
C. ADDM
D. Memory Advisor