单选题in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impactof this setting（）AOptimizer statistics are collected automatically.BOnly timed operating system （OS） statistics and plan execution statistics are collected.CThe snapshots for the Automatic Workload Repository （AWR） are not generated automatically.DSnapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.EThe Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
单选题
in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impactof this setting（）
A
Optimizer statistics are collected automatically.
B
Only timed operating system （OS） statistics and plan execution statistics are collected.
C
The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.
D
Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
E
The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
参考解析
解析：
暂无解析
相关考题：
Which setting enables the baselines by default in Oracle Database 11g?() A. setting the STATISTICS_LEVEL parameter to TYPICALB. adding filters to the Automatic Database Diagnostic Monitor (ADDM)C. enabling Automated Maintenance Task using Oracle Enterprise ManagerD. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
You are connected to a pluggable database (PDB) as a common user with DBA privileges.The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:SQL ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE;Which is true about the result of this command?（）A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.
Examine the parameter for your database instance:You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:Identify the reason why the optimizer chose different execution plans.（）A. The optimizer used a dynamic plan for the query.B. The optimizer chose different plans because automatic dynamic sampling was enabled.C. The optimizer used re-optimization cardinality feedback for the query.D. The optimizer chose different plan because extended statistics were created for the columns used.
Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future. What action would you take to achieve this task？（）A、Set the STATISTICS_LEVEL initialization parameter to ALL.B、Create a baseline on a pair of snapshots that have the statistics of the peakload period in the database.C、Decrease the snapshot interval in the AWR to collect more number of snapshots during the peakload period.D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid theautomatic purging of the snapshots.
The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD. You create a database user OPS$SKD， and then assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege. What would youachieve by the above process（）A、The database user OPS$SKD will be able to administer the database.B、The authentication detail for the database user OPS$SKD is recorded in the password file.C、The local operating system user SKD will be able to access the database instance without specifying the username and password.D、The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.
Examine the parameter for your database instance: You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan: Identify the reason why the optimizer chose different execution plans.（）A、The optimizer used a dynamic plan for the query.B、The optimizer chose different plans because automatic dynamic sampling was enabled.C、The optimizer used re-optimization cardinality feedback for the query.D、The optimizer chose different plan because extended statistics were created for the columns used.
In your database，the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）A、The optimizer statistics are collected automatically.B、Only the timed operating system （OS） statistics and plan execution statistics are collected.C、The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.D、The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. E、Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.
Which setting enables the baselines by default in Oracle Database 11g？（） A、 setting the STATISTICS_LEVEL parameter to TYPICALB、 adding filters to the Automatic Database Diagnostic Monitor （ADDM）C、 enabling Automated Maintenance Task using Oracle Enterprise ManagerD、 setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB DB_CACHE_SIZE = 1GB SHARED_POOL_SIZE = 3GB STATISTICS_LEVEL = BASIC PGA_AGGREGATE_TARGET = 0 You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）A、The STATISTICS_LEVEL initialization parameter is set to BASICB、The PGA_AGGREGATE_TARGET initialization parameter is set to zero.C、The SGA_MAX_SIZE initialization parameter is set to less than 20 GBD、The DB_CACHE_SIZE initialization parameter is set to less than 5 GBE、The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）A、Set MEMORY_TARGET to zeroB、Set the STATISTICS_LEVEL parameter to BASICC、Set the WORKAREA_SIZE_POLICY parameter to MANUALD、Set the PGA_AGGREGATE_TARGET parameter to nonzero value
The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege. What would you achieve by the above process（）A、The database user OPS$SKD will be able to administer the database.B、The authentication detail for the database user OPS$SKD is recorded in the password file.C、The local operating system user SKD will be able to access the database instance without specifying theusername and password.D、The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.
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.
Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback?（）A、The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.B、The optimizer can re optimize a query only once using cardinality feedback.C、The optimizer enables monitoring for cardinality feedback after the first execution of a query.D、The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.E、After the optimizer identifies a query as a re-optimization candidate, statistics collected by thecollectors are submitted to the optimizer.
Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of thedatabase in the future. What action would you take to achieve this task？（）A、Set the STATISTICS_LEVEL initialization parameter to ALL.B、Create a baseline on a pair of snapshots that have the statistics of the peak-load period in the database.C、Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak-load period.D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid the automatic purging of the snapshots.
in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impactof this setting（）A、Optimizer statistics are collected automatically.B、Only timed operating system （OS） statistics and plan execution statistics are collected.C、The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.D、Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.E、The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
In your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What isthe impact of this setting（）A、Optimizer statistics are collected automatically.B、Only timed operating system （OS） statistics and plan execution statistics are collected.C、The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.D、Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.E、The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
单选题Which setting enables the baselines by default in Oracle Database 11g？（）A setting the STATISTICS_LEVEL parameter to TYPICALB adding filters to the Automatic Database Diagnostic Monitor （ADDM）C enabling Automated Maintenance Task using Oracle Enterprise ManagerD setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
单选题Which setting enables the baselines by default in Oracle Database 11g?（）Asetting the STATISTICS_LEVEL parameter to TYPICALBadding filters to the Automatic Database Diagnostic Monitor (ADDM)Cenabling Automated Maintenance Task using Oracle Enterprise ManagerDsetting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
单选题Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future. What action would you take to achieve this task？（）ASet the STATISTICS_LEVEL initialization parameter to ALL.BCreate a baseline on a pair of snapshots that have the statistics of the peakload period in the database.CDecrease the snapshot interval in the AWR to collect more number of snapshots during the peakload period.DSet the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid theautomatic purging of the snapshots.
单选题You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE; Which is true about the result of this command?（）AThe STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.BThe STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.CThe STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.DNothing happens; because there is no SPFILE for each PDB, the statement is ignored.
单选题In your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What isthe impact of this setting（）AOptimizer statistics are collected automatically.BOnly timed operating system （OS） statistics and plan execution statistics are collected.CThe snapshots for the Automatic Workload Repository （AWR） are not generated automatically.DSnapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.EThe Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
单选题Examine the parameter for your database instance: You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan: Identify the reason why the optimizer chose different execution plans.（）AThe optimizer used a dynamic plan for the query.BThe optimizer chose different plans because automatic dynamic sampling was enabled.CThe optimizer used re-optimization cardinality feedback for the query.DThe optimizer chose different plan because extended statistics were created for the columns used.
单选题In your database，the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）AThe optimizer statistics are collected automatically.BOnly the timed operating system （OS） statistics and plan execution statistics are collected.CThe Oracle server dynamically generates the necessary statistics on tables as part of query optimization.DThe snapshots for the Automatic Workload Repository （AWR） are not generated automatically. ESnapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.
单选题You want to enable automatic PGA memory management in your database. Which setting is required to achieve this？（）A Set MEMORY_TARGET to zeroB Set the STATISTICS_LEVEL parameter to BASICC Set the WORKAREA_SIZE_POLICY parameter to MANUALD Set the PGA_AGGREGATE_TARGET parameter to nonzero value
单选题In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB DB_CACHE_SIZE = 1GB SHARED_POOL_SIZE = 3GB STATISTICS_LEVEL = BASIC PGA_AGGREGATE_TARGET = 0 You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）AThe STATISTICS_LEVEL initialization parameter is set to BASICBThe PGA_AGGREGATE_TARGET initialization parameter is set to zero.CThe SGA_MAX_SIZE initialization parameter is set to less than 20 GBDThe DB_CACHE_SIZE initialization parameter is set to less than 5 GBEThe SHARED_POOL_SIZE initialization parameter is set to a nonzero value.
单选题The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD. You create a database user OPS$SKD， and then assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege. What would youachieve by the above process（）AThe database user OPS$SKD will be able to administer the database.BThe authentication detail for the database user OPS$SKD is recorded in the password file.CThe local operating system user SKD will be able to access the database instance without specifying the username and password.DThe database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.
多选题Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback?（）AThe optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.BThe optimizer can re optimize a query only once using cardinality feedback.CThe optimizer enables monitoring for cardinality feedback after the first execution of a query.DThe optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.EAfter the optimizer identifies a query as a re-optimization candidate, statistics collected by thecollectors are submitted to the optimizer.