三、 數據庫開發(25分鐘)

　　23、ASP執行原理是：

　　A. Connection. B. ResordSet. C.存儲用戶信息，進行安全管理

　　D.應用服務器.

　　26、Exchange Server作為文檔管理服務器，常用的開發手段包括：

　　A.ADO. B.WebDAV. C.Socket. D.CDO.

　　27、MS SharePoint Portal Server實現的主要功能包括：

　　A.門戶服務. B.文檔管理服務. C.信息檢索服務. D.以上都是.

　　28、Every night the sales database backup fails. Which DBCC command could repa

　　ir the Sales database and check the data integrity and indices?

　　A.DBCC NEWALLOOC B.DBCC CHECKALLOC C.DBCC CHECKDB

　　D.DBCC DBREPAIR

　　29、You install SQL server on an IIS machine.You need to optimize IIS. What do

　　you configure on SQL Server?

　　A.Set working set size B.Min Server memory C.Max server memory

　　D.Max worker threads

　　30、It took you hours to create an index on a table.What should you do to prot )

　　A.Backup master database B.Backup user database

　　C.Make differential backup of user database D.Backup log

　　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