微软认证模拟试题：SQLServer考题

1、微软认证模拟试题：SQL Server考题A. Create a database backup.B. Trun cate the tran sacti on log.C. Backup the tran sacti on log.D. Create a differe ntial database backup.An swer: DYou want to improve the performa nee of a SQL Server 7.0 database by distributi ngin put/outputoperati onsacrossmultiple physical di

2、sks. You know which tables and in dexesare queried most freque ntly, 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?A nswer: One each disk, create a filegroup con sisti ng of a sin gle file and p

3、lace each table andin dex in its own filegroup. You are pla nning to use SQL Server Profiler to debug and optimize queries and applicationsinSQL Server 7.0. Youwant to be able to use SQL Server query-processingtoolsan alyze thedata captured by Profiler. Where should you save the eve nt data that wil

4、l be captured by the Profiler trace?A. I n a text fileiB. In a Win dows NT Application logC. I n the trace defi niti on file.D. In a SQL Server tableAn swer: DNotice: If you want to use SQL Server query process ingtools to analyzethe captured data, thenyou should save theeve nt data to a table .You

5、must perform multiple ide ntical installations of SQL Server 7.0 in remotebranches ofyourcompany that are not connected to the central office. The n etwork admi nistrators in thebra nches have not bee n trained to in stall SQL Server 7.0. How can you facilitate the in stallati ons so that most of th

6、e work will be done automatically?A nswer: Run SQL Server Setup in teractively to in stall SQL Server on a computer in the centraloffice.During installation,assign theMSSQLServer and SQLServerAge nt services to the localsystem user acco unt Send the iss file to the bran ches .Your Compa ny is using

7、Sql Server 7.0 store corporate bus in ess data on a Win dowsNT Server computer. To assess disk spacerequirementsand to optimize disk space usage you want toknow how ofte n new data is record in database, what tool will provide you with informationabout the frequencyof write operati ons:An swer: Win

8、dows NT Performa nee Mon itorYou are the SQL Server 7.0 administrator for your eompa ny. You want to ide ntify all errors in the SALES database, but repair only the alloeationerrors, Which two of thefollowing statements should you issue to identify all errors and repair only all alloeati on errors?(

9、Choose TWO An swers)An swer:DBCCCHECKDB( sal es? DBCC CHECKALLOC ?'sales 'REPAIR_ALLOW_DATA_LOSS ?/PYou provide tech ni eal support to eompa nies that use SQLServer 7.0. A eustomer reportsthat there is a problem, and you are asked to inv estigate it. You want to eapture a traee in SQL server

10、 Profiler. What are the minimum permissions that you must have at theeustomer ' s S QL Server eo mput er t o be ab l e t o ereat e and eapt ure a Profil er traeeA nswer: You must have the EXEC permission for the Profiler extended stored proeedures. You are running a web site, you want aeeo untin

11、g who is aeeess ing speeifie tables. Whiehshould you use performa nee mon itor to mon itor?A. Conn eet eve nt, exeeutio n pla n eve nt, serviee eon trol eve nt, SQL user name, NT user n ame.B. Atte nti on eve nt, exee prepared sql eve nt, sql user name,NT user n ameC. Conn ect eve nt, disc onn ect e

12、ve nt, existi ngconn ecti on eve nt, NT user n ameD. Object: ope ned eve nt, sql user n ame, NT user n ame.An swer: DThedepartme ntalserver has Full Text searchimplemented onits SQL server database. Currently both theFull Text database and the database files reside on the same logical drive. You do

13、not want the Full Text indexing to use more tha n 25% of the available drive space because you want to allow space for dynamic expansion of the data files. You want to be able to remotely mon itor the amount of space in use by the catalogs. How should you remotely monitor the space usage with a mini

14、mum nu mber of additi onal admi nistrative steps?A. Use the wi ndows NT Performa nee Mon itor to conn ect to the Server and to mon itor the size of the Microsoft Search catalogB. Create a scheduled job to regularly mon itor the size ofthe Full Text indexes and send the result to your E-MAILaddressC.

15、 Create a batch file to monitorthe size of Full Textin dexes and send the result to you viaNetwork Message. Usethe Win dows NT Scheduler Service to schedule the batch file to runregularlyD. Create a batch file to mon itor the size of the Full Textindexes and send the result to you via Network Messag

16、e. Create a scheduled job to run the batch file regularly.An swer: AYou are a SQL Server 7.0 system administrator 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 N

17、T Workstati on computer, you want to remotely mon itor the size of the Full Text catalog on Win dows NT server computer that is running SQL Server. Which of the followi ng tools is the most convenient to use for mon itor the Full Text catalog?A. Performa nee Mon itorB. Query An alyzerC. The SP_MONIT

18、OR system stored procedureD. SQL Server Profiler.An swer: ANotice: To obtai n real-time in formatio n about the size ofa specific full-text catalog, you can continu ously mon itor the appropriate in sta nee of the Microsoft search In dexer Catalogs You load a lot data into your database, the n you f

19、ind that the space for log is almost full, how can you do to ensure the restore: (Choose all that apply)A. Make a full backupB. Make a differe ntial backupC. Backup the tran sacti on log with the default opti onsD. Backup the tran sacti on log with trun cate onlyAn swer: A, DThe enginemanu facturi n

20、gapplicatio n records dataabout all the engines that are manu factured at your pla nt, the database contains approximately 500 Millionrecords and isapproximately 50GB in size. The database in creases by 1000 records per day. You want to accomplish the follow ing goals:1. Mini mize the time required

21、to recover the database2. Provide the ability to recover the database to a specifictime3. Mini mize the nu mber of tran sacti on logs that n eed tobe duri ng recovery4. Mini mize the time required to backup the databaseYou take the followingactions : 1. Schedule a fulldatabase backup of the en tire

22、database to occur every Sun day at AM 1:00 2. Schedule tran sacti on log backup to occur every day at PM Which result or results do these action produce? (Choose all that apply )A. The time required to recover the database is mini mizedB. The database can be recovered to a specific time.C. The number of transactionlogs that need to beapplied duri ng recovery is mini mizedD. The time required to backup the database is mini mizedAn swer: 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 transact