网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
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
热门标签
最新试卷