CMS专题
单选题Consider the following statement： SQL> EXECUTE DBMS_STATS.GATHER_SHEMA_STATS （- 2> ownname => ‘OE’， - 3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE， - 4> method opt => ‘for all columns size AUTO’）； What is the effect of ‘for all columns siz
题目
The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema.
The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.
The Oracle server creates a histogram based on data and application usage of the column/s for all table, column, and index statistics for the OE schema.
The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.
参考答案和解析
相似问题和答案
第1题：
You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privilegesand execute the following sequence statements:What is the result of the last SET CONTAINER statement and why is it so?（）
A. It succeeds because the PDB_ADMIN user has the required privileges.
B. It fails because common users are unable to use the SET CONTAINER statement.
C. It fails because local users are unable to use the SET CONTAINER statement.
D. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).
第2题：
Which of the following servers would execute SQL？（）
- A、 Database Server
- B、 DNS Server
- C、 NAS Server
- D、 Web Server
正确答案:A
第3题：
You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing.DoWork() must run as many times as possible while the SQL query is executing.Which code segment should you use?（）
A.
B.
C.
D.
第4题：
Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?（）
- A、SQL Repair Advisor
- B、SQL Optimizer
- C、SQL Access Advisor
- D、SQL Tuning Advisor
正确答案:D
第5题：
Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?（）
- A、Task Center
- B、Command Editor
- C、Developer Workbench
- D、Command Line Processor
正确答案:B
第6题：
A.0
B.1
C.3
D.6
第7题：
Application A is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary = salary * 0.5 WHERE empno='000010' Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?（）
- A、The database manager will rollback the transaction in both applications.
- B、The database manager will rollback the transaction in one of the two applications.
- C、Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.
- D、Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.
正确答案:B
第8题：
A. A single SQL statement provided by a user
B. An existing SQL Tuning Set (STS)
C. A preprocessed Database Replay workload
D. A schema name
E. SQL statement identified in EM as using excessive resources
第9题：
Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（）
- A、 The SGA Tuning Advisor
- B、 The SQL Access Advisor
- C、 The SQL Tuning Advisor
- D、 The Memory Advisor
正确答案:C
第10题：
Which of the following cannot be used as input to the SQL Tuning Advisor?（） (Choose all that apply.)
- A、A single SQL statement provided by a user
- B、An existing SQL Tuning Set (STS)
- C、A preprocessed Database Replay workload
- D、A schema name
- E、SQL statement identified in EM as using excessive resources
正确答案:C,D