微軟認證模擬試題：SQLServer考題

1、微軟認證模擬試題：SQL Server考題A. Create a database backup.B. Truncate the transaction log.C. Backup the transaction log.D. Create a differential database backup.Answer: DYou want to improve the performance of a SQL Server 7.0 database by distributing input/output operations across multiple physical disks. Yo

2、u know which tables and indexesare queried most frequently, and you want to place each of them on a separate disk. How canyou place each of the most frequently queried tables and indexes on its own separate disk?Answer: One each disk, create a filegroup consisting of a single file and place each tab

3、le andindex in its own filegroup.You are planning to use SQL Server Profiler to debug and optimize queries and applicationsin SQL Server 7.0. You want to be able to use SQL Server query-processing tools analyze thedata captured by Profiler. Where should you save the event data that will be captured

4、by the Profiler trace?A. In a text fileB. In a Windows NT Application logC. In the trace definition file.D. In a SQL Server tableAnswer: DNotice: If you want to use SQL Server query processing tools to analyzethe captured data, thenyou should save theevent data to a table.You must perform multiple i

5、dentical installations of SQL Server 7.0 in remote branches ofyour company that are not connected to the central office. The network administrators in thebranches have not been trained to install SQL Server 7.0. How can you facilitate theinstallations so that most of the work will be done automatica

6、lly?Answer: Run SQL Server Setup interactively to install SQL Server on a computer in the centraloffice. During installation, assign the MSSQLServer and SQLServerAgent services to the localsystem user account Send the iss file to the branches.Your Company is using Sql Server 7.0 store corporate busi

7、ness data on a WindowsNT Server computer. To assess disk spacerequirements and to optimize disk space usage you want to know how often new data is record in database, what tool will provide you with information about the frequency of write operations:Answer: Windows NT Performance MonitorYou are the

8、 SQL Server 7.0 administrator for your company. You want to identify all errors in the SALES database, but repair only the allocation errors, Which two of the following statements should you issue to identify all errors and repair only all allocation errors?(Choose TWO Answers)Answer:DBCCCHECKDB( sa

9、l es? DBCC CHECKALLOC ?sales REPAIR_ALLOW_DATA_LOSS ?/PYou provide technical support to companies that use SQL Server 7.0. A customer reportsthat there is a problem, and you are asked to investigate it. You want to capture a trace inSQL server Profiler. What are the minimum permissions that you must

10、 have at thecustomer s S QL Server co mput er t o be ab l e t o creat e and capt ure a Profil er traceAnswer: You must have the EXEC permission for the Profiler extended stored procedures.You are running a web site, you want accounting who is accessing specific tables. Whichshould you use performanc

11、e monitor to monitor?A. Connect event, execution plan event, service control event, SQL username, NT user name.B. Attention event, exec prepared sql event, sql username,NT user nameC. Connect event, disconnect event, existingconnection event, NT user nameD. Object: opened event, sql user name, NT us

12、er name.Answer: DThe departmental server has Full Text search implemented on its SQL server database. Currently both the Full Text database and the database files reside on the same logical drive. You do not want the Full Text indexing to use more than 25% of the available drive space because you wa

13、nt to allow space for dynamic expansion of the data files. You want to be able to remotely monitor the amount of space in use by the catalogs. How should you remotely monitor the space usage with a minimum number of additional administrative steps?A. Use the windows NT Performance Monitor to connect

14、 to the Server and to monitor the size of the Microsoft Search catalogB. Create a scheduled job to regularly monitor the size of the Full Text indexes and send the result to your E-MAILaddressC. Create a batch file to monitor the size of Full Text indexes and send the result to you viaNetwork Messag

15、e. Use the Windows NT Scheduler Service to schedule the batch file to runregularlyD. Create a batch file to monitor the size of the Full Text indexes and send the result to you via Network Message. Create a scheduled job to run the batch file regularly.Answer: AYou are a SQL Server 7.0 system admini

16、strator for you company. To provide users with Full Text search capabilities, you create a Full T ext catalog and enable Full Text indexing for specific tables in a database. From your Windows NT Workstation computer, you want to remotely monitor the size of the Full Text catalog on Windows NT serve

17、r computer that is running SQL Server. Which of the following tools is the most convenient to use for monitor the Full Text catalog?A. Performance MonitorB. Query AnalyzerC. The SP_MONITOR system stored procedureD. SQL Server Profiler.Answer: ANotice: To obtain real-time information about the size o

18、f a specific full-text catalog, you can continuously monitor the appropriate instance of the Microsoft search Indexer Catalogs You load a lot data into your database, then you find that the space for log is almost full, how can you do to ensure the restore: (Choose all that apply)A. Make a full back

19、upB. Make a differential backupC. Backup the transaction log with the default optionsD. Backup the transaction log with truncate onlyAnswer: A, DThe engine manufacturing application records data about all the engines that are manufactured at your plant, the database contains approximately 500 Millio

20、n records and is approximately 50GB in size. The database increases by 1000 records per day. You want to accomplish the following goals:1. Minimize the time required to recover the database2. Provide the ability to recover the database to a specific time3. Minimize the number of transaction logs tha

21、t need tobe during recovery4. Minimize the time required to backup the databaseYou take the following actions : 1. Schedule a full database backup of the entire database to occur every Sunday at AM 1:00 2. Schedule transaction log backup to occur every day at PM Which result or results do these acti

22、on produce? (Choose all that apply )A. The time required to recover the database is minimizedB. The database can be recovered to a specific time.C. The number of transaction logs that need to be applied during recovery is minimizedD. The time required to backup the database is minimizedAnswer: B, DYou check the free space on a log file and run a BACKUPLOG WITH NO_LOG on a database that is a publisher for transactiona