单选题When does Oracle9i flag an index as being used in the V$OBJECT_USAGE view？（）A During a query’s parse time only. B During a query’s execution time only. C During any kind of DML statement execution. D During the execution of an INSERT statement only.

题目

单选题

When does Oracle9i flag an index as being used in the V$OBJECT_USAGE view？（）

During a query’s parse time only.

During a query’s execution time only.

During any kind of DML statement execution.

During the execution of an INSERT statement only.

参考答案和解析

正确答案： B

解析：暂无解析

如果没有搜索结果，请直接联系老师获取答案。

更多相关问题

相关问题 1：

单选题In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）A It degrades the run time and compiler performance.B It provides better run time and compiler performance.C It provides better optimization of the statement during parse time.D It forces the rule based optimizer to be used for statement optimization.E It provides better run time performance but slightly degraded compiler performance.F It provides better run time performance but slightly degraded run time performance.

点击查看答案
相关问题 2：

单选题During the Clinton presidency, the U.S. enjoyed more than any time in its history peace and economic well being.A the U.S. enjoyed more than any time in its history peace and economic well beingB the U.S. enjoying more than any other time in its history peace and economic well beingC more peace and economic well being was enjoyed by the U.S. than any other timeD economic peace and well being was enjoyed by the U.S. more so than any other ~ time in the country’s historyE the U.S. enjoyed more peace and economic well being than at any other time in its history

点击查看答案
相关问题 3：

单选题You issued the following statement to monitor the usage of the index： SQL> ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE； Which view will you query to ensure that the index is being monitored？（）AINDEX_STATSBDBA_INDEXESCDBA_IND_COLUMNSDV$OBJECT_USAGE

点击查看答案
相关问题 4：

单选题Which is an example of a dynamic SELECT statement? （）A A query whose object names change during its execution. B A query whose object names are not known until run time. C A query whose bind variables values change during execution. D A query whose bind variable values are not known until run time.

点击查看答案
相关问题 5：

多选题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 the collectors are submitted to the optimizer.

点击查看答案
相关问题 6：

多选题You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？（）ATo recover a dropped table.BTo recover a dropped schema.CTo recover data from a truncated table.DTo view changes made by all the transactions during a given period of time.ETo view changes made by a single transaction during a given period of time.

点击查看答案
相关问题 7：

多选题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.

点击查看答案

1Z0-032

单选题When does Oracle9i flag an index as being used in the V$OBJECT_USAGE view？（）A During a query’s parse time only. B During a query’s execution time only. C During any kind of DML statement execution. D During the execution of an INSERT statement only.

题目

参考答案和解析

更多相关问题

相关问题 1：

相关问题 2：

相关问题 3：

相关问题 4：

相关问题 5：

相关问题 6：

相关问题 7：

相关内容