CMS专题
单选题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.
题目
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.
参考答案和解析
相似问题和答案
第1题：
A vessel which is being assisted by an icebreaker would display a flag hoist consisting of the code numeral "4" when the vessel ______.
A.speed begins to drop
B.stops
C.receives ice damage
D.becomes icebound
第2题：
When we use the word（）we mean that an idea or theory is being applied: that whatever the teacher does, certain theoretical principles are always borne in mind.
approach
略
第3题：
A. Either the -a or flag -b may be used, but not both.
B. If the flag -a is used then the flag -b also must be used.
C. One of the -a or -b flags must be used, but not both at the same time.
D. Both the flags may be used together, but neither are mandatory.
第4题：
What does the FREQ column show when running the tprof option?（）
- A、 Total amount of Ticks used by all users
- B、 Total amount of Ticks used by all processes
- C、 Total amount of Ticks used by a specific user
- D、 Total amount of Ticks used by a specific type of process
正确答案:D
第5题：
When the BGP path selection process is being performed on a Cisco router, which BGP attribute is used first when determining the best path?（）
- A、local preference
- B、MED
- C、weight
- D、or igin
- E、next - hop
- F、AS - path
正确答案:C
第6题：
The boom stops on a pedestal crane prevent the boom from ______.
A.being raised too high
B.swinging at sea
C.overloading when not in use
D.being lowered too low
第7题：
Which GSS "source access list" is used to allow access to GSS by clients when GSS is being used as the DNS？（）
- A、 Client IP
- B、 Proxy IP
- C、 Client and proxy IP
- D、 Neither client nor proxy IP
正确答案:A
第8题：
The boom stops are installed on an offshore crane to ______.
A.prevent the boom from being raised too high
B.prevent the boom from swinging
C.support the boom when not in use
D.prevent the boom from being lowered
第9题：
Examine the following output： SQL> SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）
- A、It is ignored by the query optimizer.
- B、It is not used while the index is being rebuilt.
- C、The index cannot be rebuilt， and has to be re-created.
- D、The index is automatically rebuilt when used the next time
正确答案:A,B
第10题：
在船上应当日落时降下国旗.（）
- A、We should lower national flag when the sun sets.
- B、We should lower national flag when the ship is in port.
- C、We should lower national flag when loading and unloading.
- D、We should lower national flag when the sun rises.
正确答案:A