error of perpendicularity
side error
prismatic error
centering error
第1题:
Consider the query:Mysql> SET @run = 15;Mysql> EXPLAIN SELECT objective, stage, COUNT (stage)FROM iteminformationWHERE run=@run AND objective=’7.1’GROUP BY objective,stageORDER BY stage;The iteminformation table has the following indexes;Mysql> SHOW INDEXES FROM iteminformation:This query is run several times in an application with different values in the WHERE clause in a growing data set.What is the primary improvement that can be made for this scenario?()
A.Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to use indexes
B.Add an index on the objective column so that is can be used in both the WHERE and GROUP BY operations
C.Drop the run_2 index because it has caused a conflict in the choice of key for this query
D.Execute the run_2 index because it has caused a conflict in the choice of key for this query
E.Add a composite index on (run,objective,stage) to allow the query to fully utilize an index
第2题:
在使用之前打开非结构索引文件,应用( )命令。
A.INDEX ON
B.SET INDEX TO
C.SET ORDER TO
D.SEEK
第3题:
It is agreed that America has zero culture.()
第4题:
SET INDEX TO 命令不能关闭结构化复合索引文件.
第5题:
The Great Barrier Reef is included on the World Heritage list because()
Ait has the most beautiful seascape in the world
Bit has the greatest number of islands in the world
Cit has the most diverse and complex marine life in the world
Dit has the longest coast in the world
第6题:
在SQL中,建立索引的命令是( )。
A. ALTER INDEX
B. SET ORDER T0
C. SET INDEX TO
D. INDEX ON
第7题:
A sextant having an index error that is "off the arc" has a ______.
A.positive correction
B.dip error
C.negative correction
D.semidiameter error
第8题:
A. set SHARED_POOL_SIZE to zero
B. set STATISTICS_LEVEL to BASIC
C. set SGA_TARGET to a non-zero value
D. set DB_CACHE_SIZE to a non-zero value
E. set STATISTICS_LEVEL to TYPICAL or ALL
第9题:
int index = 1; String test = new String; String foo = test[index]; What is the result?()
第10题:
The Great Barrier Reef is included on the World Heritage list because()