MCSE模拟试题：SQLServer考题

MCSE模拟试题：SQLServer考题
 

Your company’s S QL Server 7 . 0 dat abase i s backed dail y at m i dn i ght. One morni ng you lOAd a large amount of data by using a nonlogged transaction. You then disable the selectinto/bulkcopy ption. What is the easIEst way to restore the validITy of the transaction logbackup sEQuence?
A. Create a database backup.

B. Truncate the transaction log.

C. Backup the transaction log.

D. Create a differential database backup.

Answer: D

You want to improve the performance of a SQL Server 7.0 database by distributing input/output operations across multiple
..............................