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?()
AEvery SQL statement in the STS is considered only once for execution.
BThe SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.
CThe execution plan and execution statistics are computed for each SQL statement in the STS.
DThe effects of DDL and DML are considered to produce the execution plan and execution statistics.
相关问题推荐
-
什么是802.11WLAN的基本模块?
-
患者男性,50岁。以进行性吞咽困难半年之主诉入院。X线钡餐透视诊断为食管癌。为了解肿瘤向外扩展情况,该患者还需行的检查是()
A、B超
B、拍胸部X线正侧位片
C、CT
D、食管纤维镜检
E、食管拉网
-
You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.()
A、The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.
B、The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.
C、The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.
D、The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1
-
Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?()
A、 Create new indexes.
B、 Modify existing indexes.
C、 Implement partitioning on a nonpartitioned table.
D、 Create materialized views.
E、 All of the above
-
Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?()
A、NLS_SORT = BINARY
B、NLS_SORT = BINARY_AI
C、NLS_SORT = BINARY_CI
D、NLS_SORT = BINARY_AI_CI
E、Binary sorts are case insensitive and accent insensitive by default.