违法和不良信息举报 联系客服
免费注册 登录

单选题Examine the command：  SQL DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）A Automatic statistics collection is stopped for the CUSTOMERS table.B Statistics for the CUSTOMERS 

题目
单选题
Examine the command：  SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）
A

Automatic statistics collection is stopped for the CUSTOMERS table.

B

Statistics for the CUSTOMERS table are locked and cannot be overwritten.

C

Existing statistics for the CUSTOMERS table become unusable for the query optimizer.

D

Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Examine the following command that is executed for the TRANSPORT table in the SH schema:Which statement describes the significance of this command?()

A. It collects statistics into the pending area in the data dictionary

B. It creates a virtual hidden column in the CUSTOMERS_OBE table

C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT

D. It creates a histogram to hold skewed information about the data in the columns


参考答案：B

第2题：

Examine the data from the ORDERS and CUSTOMERS table.Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin places his orders?（）

A.

B.

C.

D.


参考答案：B

第3题：

View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?()

A. Accept the recommended SQL profile.

B.Collect statistics for the related objects.

C. Run the Access Advisor for the SQL statement.

D. Run the Segment Advisor for recommendations.


参考答案：C

第4题：

Examine the command： SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）；  Which statementdescribes the effect of the above command（）

  • A、Automatic statistics collection is stopped for the CUSTOMERS table.
  • B、Statistics for the CUSTOMERS table are locked and cannot be overwritten.
  • C、Existing statistics for the CUSTOMERS table become unusable for the query optimizer.
  • D、Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics

正确答案:D

第5题：

While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）

  • A、It updates the existing SQL profiles with current statistics
  • B、It makes the statistics information available to GATHER_STATS_JOB
  • C、It initiates the statistics collection process by running GATHER_STATS_JOB
  • D、It logs a warning message in the alert log so that the DBA can perform statistics collection manually

正确答案:B

第6题：

Youexecutedthefollowingcommands：SQL>ALTERSESSIONSETOPTIMIZER_USE_PENDING_STATISTICS=false；SQL>EXECUTEDBMS_STATS.SET_TABLE_PREFS（’SH’，’CUSTOMERS’，’PUBLISH’，’false’）；SQL>EXECUTEDBMS_STATS.GATHER_TABLE_STATS（’SH’，’CUSTOMERS’）；WhichstatementiscorrectregardingtheabovestatisticscollectionontheSH.CUSTOMERStableintheabovesession？（）

A.Thestatisticsarestoredinthependingstatisticstableinthedatadictionary.

B.Thestatisticsaretreatedasthecurrentstatisticsbytheoptimizerforallsessions.

C.Thestatisticsaretreatedasthecurrentstatisticsbytheoptimizerforthecurrentsessionsonly.

D.Thestatisticsaretemporaryandusedbytheoptimizerforallsessionsuntilthissessionterminates.


参考答案：A

第7题：

Examinethecommand:SQL>DBMS_STATS.SET_TABLE_PREFS(’SH’,’CUSTOMERS’,’PUBLISH’,’false’);Whichstatementdescribestheeffectoftheabovecommand()

A.AutomaticstatisticscollectionisstoppedfortheCUSTOMERStable.

B.StatisticsfortheCUSTOMERStablearelockedandcannotbeoverwritten.

C.ExistingstatisticsfortheCUSTOMERStablebecomeunusableforthequeryoptimizer.

D.Subsequently，statisticsgatheredontheCUSTOMERStablearestoredaspendingstatistics


参考答案：D

第8题：

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.


参考答案：A

第9题：

While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）

  • A、It updates the existing SQL profiles with current statistics.
  • B、It makes the statistics information available to GATHER_STATS_JOB
  • C、It initiates the statistics collection process by running GATHER_STATS_JOB
  • D、It logs a warning message in the alert log so that the DBA can perform statistics collection manually.

正确答案:B

第10题：

You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）

  • A、Restore the backup control file and open the database with RESETLOGS option.
  • B、Perform point-in-time recovery because flashback cannot be performed again on this table
  • C、Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
  • D、Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

正确答案:D

更多相关问题
相关内容