网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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?()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

考题 单选题在船上应当日落时降下国旗.()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.

考题 单选题When should distress flares and rockets be used? ()A Immediately upon abandoning the vesselB Only when there is a chance of their being seen by a rescue vesselC At one hour intervalsD At 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().A speed begins to dropB stopsC receives ice damageD becomes 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?()A enable index monitoring and query the DBA_OBJECTS viewB enable index monitoring and query the DBA_INDEXES viewC enable index monitoring and query the V$OBJECT_USAGE viewD enable 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