單項選擇題

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.

你可能感興趣的試題

多項選擇題

Which two are true regarding external tables？（）

A.External tables can be updated.
B.External tables are read-only tables.
C.Indexes can be created on external tables.
D.Indexes cannot be created on external tables.

單項選擇題

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 size AUTO’ of the METHOD_OPT option？（）

A.The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema.
B.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.
C.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.
D.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.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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

你可能感興趣的試題

Which two are true regarding external tables？ （）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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

Which two are true regarding external tables？（）