神州泰岳测试笔试题
31、You need to produce a list of the five highest revenue transactions from t
he Orders table in the Sales database.The Orders table is defined as follows:
Which statement will produce the report?
A. SELECT TOP 5 OrderAmount,SalePersonID FROM Orders ORDER BY OrderAmount.
B. SELECT TOP5 OrderAmount,SalePersonID FROM Orders.
C. SELECT TOP 5 with TIES OrderAmount,SalePersonID FROM Orders ORDER BY OrderA
D. SELECT TOP 5 with TIES OrderAmount,SalePersonID FROM Orders ORDER BY OrderI
D.
32、You are creating a large index on the EMP table.This index will have a hig
h number of inserts.To speed up creation of the index, what can be done?
A. Use the NOLOGGING clause in the CREATE INDEX command.
B. Use the same INITRANS value of the corresponding table on the index.
C. SET the DB_BLOCK_SIZE to multiples of 5.
D. Place indexes in separate tablespaces.
33、The CALC_COMM procedure is no longer needed and should be remouved. Which
command will successfully drop this procedure?
A. DROP calc_comm;
B. REMOVE calc_comm;
C. DROP PROCEDURE calc_comm;
D. ALTER calc_comm. DROP PROCEDURE;
34、Which of these statements is always true?
A.A database must contain at least three datafiles.
B.Control files must be mirrored.
C.A database has at least two groups of redo log files.
D.The members of a redo log group can have various sizes if they can be stored
on one disk.
35、For which column would you create an index?
A.A column that is small
B.A column that is updated frequently
C.A column containing a wide range of values
D.A column with a small number of null values
阅读本文后毕业生简历网还为您推荐了更多相关的文章参考：
20xx年中国人民银行英语专业笔试题 汉王科技20xx年部分笔试题及答案 中信证券各部门笔试