《2021年微软认证模拟试题 SQLSERVER考题》由会员分享，可在线阅读，更多相关《2021年微软认证模拟试题 SQLSERVER考题（7页珍藏版）》请在金锄头文库上搜索。
1、微软认证模拟试题 SQLServer考题 a. create a database backup. b. truncate the transaction log. c. backup the transaction log. d. create a differential database backup. answer: d a. in a text file b. in a windows nt application log c. in the trace definition file. d. in a sql server table answer: d notice: if yo
2、u want to use sql server query processing tools to analyze the captured data, thenyou should save the event data to a table.you must perform multiple identical installations of sql server 7.0 in remote branches ofyour pany that are not connected to the central office. the work administrators in theb
3、ranches have not been trained to install sql server 7.0. how can you facilitate theinstallations so that most of the work will be done automatically?answer: run sql server setup interactively to install sql server on a puter in the centraloffice. during installation, assign the mssqlserver and sqlse
4、rveragent services to the localsystem user aount send the iss file to the branches.your pany is using sql server 7.0 store corporate business data on a windows nt server puter. to assess disk space requirements and to optimize disk space usage you want to know how often new data is record in databas
5、e, what tool will provide you with information about the frequency of write operations: answer: windows nt performance monitor answer: dbcheckdb(sal es?& db checkalloc ?salesrepair_allow_data_loss ?/p a. connect event, execution plan event, service control event, sql username, nt user name. b. atten
6、tion event, exec prepared sql event, sql username, nt user name c. connect event, disconnect event, existingconnection event, nt user name d. object: opened event, sql user name, nt user name. answer: d a. use the windows nt performance monitor to connect to the server and to monitor the size of the
7、 microsoft search catalog b. create a scheduled job to regularly monitor the size of the full text indexes and send the result to your e-mail address c. create a batch file to monitor the size of full text indexes and send the result to you viawork message. use the windows nt scheduler service to sc
8、hedule the batch file to run regularly d. create a batch file to monitor the size of the full text indexes and send the result to you via work message. create a scheduled job to run the batch file regularly. answer: a a. performance monitor b. query analyzer c. the sp_monitor system stored procedure
9、 d. sql server profiler. answer: a a. make a full backup b. make a differential backup c. backup the transaction log with the default options d. backup the transaction log with truncate only answer: a, d 1. minimize the time required to recover the database 2. provide the ability to recover the data
10、base to a specific time 3. minimize the number of transaction logs that need to be during recovery 4. minimize the time required to backup the database a. the time required to recover the database is minimized b. the database can be recovered to a specific time. c. the number of transaction logs that need to be applied during recovery is minimized d. the time required to backup the database is minimized answer: b, d a. the distributor database is full b. log reader agent has stopped answer: b answer: 3 a. transactional b. snapshot with pull c. snapshot with push d. merge answer: b 模板,内容仅供参考
