单选题When does Oracle9i flag an index as being used in the V$OBJECT_USAGE view？（）ADuring a query’s parse time only. BDuring a query’s execution time only. CDuring any kind of DML statement execution. DDuring the execution of an INSERT statement only.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
The man page for command shows the following syntax: The man page for command shows the following syntax: command [ －a | －b ] Which of the following statements is true regarding this entry?() 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.
The boom stops are installed on an offshore crane to ______.A.prevent the boom from being raised too highB.prevent the boom from swingingC.support the boom when not in useD.prevent the boom from being lowered
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 dropB.stopsC.receives ice damageD.becomes icebound
The boom stops on a pedestal crane prevent the boom from ______.A.being raised too highB.swinging at seaC.overloading when not in useD.being lowered too low
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.
Which GSS "source access list" is used to allow access to GSS by clients when GSS is being used as the DNS？（）A、 Client IPB、 Proxy IPC、 Client and proxy IPD、 Neither client nor proxy IP
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 preferenceB、MEDC、weightD、or iginE、next - hopF、AS - path
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
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
在船上应当日落时降下国旗.（）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.
Which of the following multimeter settings should only be used when there is no electrical flow through the part being tested? （）(Select TWO).A、AmpereB、ContinuityC、VoltD、ResistanceE、Wattage
When does an MDisk become managed by an IBM Storwize V7000？（）A、when a volume is created using thatMDiskB、when theMDisk is first imported into the clusterC、when the LUN is first presented to theStorwize V7000D、when theMDisk is assigned to a storage pool
What does the FREQ column show when running the tprof option? （）A、Total amount of Ticks used by all usersB、Total amount of Ticks used by all processesC、Total amount of Ticks used by a specific userD、Total amount of Ticks used by a specific type of process
How does DB2 protect the integrity of indexes when data is updated?（）A、Locks are acquired on the data.B、Locks are acquired on index keys.C、Locks are acquired on index pages.D、Locks are acquired on index pointers.
The man page for command shows the following syntax: The man page for command shows the following syntax: command [ -a | -b ] Which of the following statements is true regarding this entry?（）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.
An administrator attempts to create a link of /etc/db_conf to the target directory /db/v9.7/install/config. The following n?command failed toAn administrator attempts to create a link of /etc/db_conf to the target directory /db/v9.7/install/config. The following ?n?command failed to create the link.ln/db/v9.7/install/config /etc/db_conf. Which option should be used when re-running the command to resolve the problem?（）A、-s flag to create a soft linkB、-n flag to force create a hard linkC、-N flag to force create a hard linkD、-S flag to force create a soft link
In which scenarios would you rebuild an index？（）A、 when you need to disable the index usageB、 when you need to change storage optionsC、 when you need to enable index monitoringD、 when you need to move the index to another tablespace
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？（） A、 INDEX_STATSB、 DBA_INDEXESC、 DBA_IND_COLUMNSD、 V$OBJECT_USAGE
单选题When does Oracle9i flag an index as being used in the V$OBJECT_USAGE view？（）ADuring a query’s parse time only. BDuring a query’s execution time only. CDuring any kind of DML statement execution. DDuring the execution of an INSERT statement only.
单选题在船上应当日落时降下国旗.（）AWe should lower national flag when the sun sets.BWe should lower national flag when the ship is in port.CWe should lower national flag when loading and unloading.DWe should lower national flag when the sun rises.
单选题When should distress flares and rockets be used? （）AImmediately upon abandoning the vesselBOnly when there is a chance of their being seen by a rescue vesselCAt one hour intervalsDAt half hour intervals
单选题An administrator attempts to create a link of /etc/db_conf to the target directory /db/v9.7/install/config. The following n?command failed toAn administrator attempts to create a link of /etc/db_conf to the target directory /db/v9.7/install/config. The following ?n?command failed to create the link.ln/db/v9.7/install/config /etc/db_conf. Which option should be used when re-running the command to resolve the problem?（）A-s flag to create a soft linkB-n flag to force create a hard linkC-N flag to force create a hard linkD-S flag to force create a soft link
多选题Which of the following multimeter settings should only be used when there is no electrical flow through the part being tested? （）(Select TWO).AAmpereBContinuityCVoltDResistanceEWattage
单选题A vessel which is being assisted by an icebreaker would display a flag hoist consisting of the code numeral 4 when the vessel（）.Aspeed begins to dropBstopsCreceives ice damageDbecomes icebound
单选题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？（）A INDEX_STATSB DBA_INDEXESC DBA_IND_COLUMNSD V$OBJECT_USAGE
单选题You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to achieve this？（）Aenable index monitoring and query the DBA_OBJECTS viewBenable index monitoring and query the DBA_INDEXES viewCenable index monitoring and query the V$OBJECT_USAGE viewDenable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
多选题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（）AIt is ignored by the query optimizer.BIt is not used while the index is being rebuilt.CThe index cannot be rebuilt， and has to be re-created.DThe index is automatically rebuilt when used the next time
单选题Which GSS "source access list" is used to allow access to GSS by clients when GSS is being used as the DNS？（）A Client IPB Proxy IPC Client and proxy IPD Neither client nor proxy IP