單項(xiàng)選擇題

You executed the following commands:

Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?（）

A. The statistics are stored in the pending statistics table in the data dictionary.
B. The statistics are treated as the current statistics by the optimizer for all sessions.
C. The statistics are treated as the current statistics by the optimizer for the current sessions only.
D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.

你可能感興趣的試題

多項(xiàng)選擇題

You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level?（）

A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statement
B. issuing the ALTER SESSION ENABLE RESUMABLE; statement
C. modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value
D. issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=<nonzero value>; statement

多項(xiàng)選擇題

You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?（）

A.Every SQL statement in the STS is considered only once for execution
B.The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics
C.The execution plan and execution statistics are computed for each SQL statement in the STS
D.The effects of DDL and DML are considered to produce the execution plan and execution statistics

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

You executed the following commands: Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?（）

你可能感興趣的試題

You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level?（）

You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?（）

You executed the following commands:

Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?（）