对于在财产清查中经查实无法支付的应付账款，在按规定的程序报经批准后作（)。A．借：应付账款 贷：营

baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window？（）

A. The collection level for the AWR should be set to BASIC

B. The moving window size must be less than Undo Retention

C. The moving window size should be greater than the Automatic Workload Repository (AWR) retention period

D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period

A. Cursor cache

B. Stored outline

C. SQL Tuning Set

D. Automatic Workload Repository (AWR) snapshots

A. the SQL text SQL

B. the execution plan

C. the execution context

D. the execution frequency

E. the system change number (SCN)

ently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance？（）

A. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.

B. Run the Automatic Workload Repository Monitor (ADDM).

C. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.

D. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments.On further investigation, you find that buffer busy waits is caused by contention on data blocks.Which option would you consider first to decrease the wait event immediately？（）

A. Decreasing PCTUSED

B. Decreasing PCTFREE

C. Increasing the number of DBWN process

D. Using Automatic Segment Space Management (ASSM)

E. Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

When you return next year, the school ______.

A) will be set up B) will set up

C) will have been set up D) will have set up

The reason why a good business plan is important is that it can

A．make you be prepared for your enterprise adventure.

B．persuade the bank to lend you the large sum of money you require.

C．help you get grants, raise finance and improve financial management.

D．help you make the right first step to set up your own business.

tions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time.How would you accomplish this task？（）

A. Set metric threshold

B. Implement Database Resource Manager

C. Enable resumable timeout for user sessions

D. Add directives to Automatic Database Diagnostic Monitor (ADDM)

To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message:SQL > startupORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.Identify the reason the instance failed to start.（）

A.The PGA_AGGREGATE_TARGET parameter is set to zero.

B.The STATISTICS_LEVEL parameter is setto basic.

C.Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.

D.The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.