单项选择题
You executed the following commands：
SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false；
SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）；
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）；
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.
相关考题
-
单项选择题
Multiple RMAN sessions are connected to the database instance. Examine the following output when backup commands are running in server sessions: What could have helped you to correlate server sessions with channels?（）
A. Implement RMAN multiplexing
B. Set the DEBUG ON in the RMAN script
C. Specify the command ID in the RMAN script
D. Use a tag with the RMAN BACKUP command -
多项选择题
Youwanttoenableresumablespaceallocationattheinstancelevel.Whichtwoactionswouldenableresumablespaceallocationattheinstancelevel？（）
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=；statement -
多项选择题
YouwanttoanalyzeaSQLTuningSet（STS）usingSQLPerformanceAnalyzerinatestdatabase.WhichtwostatementsaretrueregardingtheactivitiesperformedduringthetestexecutionofSQLsinaSQLTuningSet？（）
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.
