神州泰岳测试试题
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
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