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 physical disks. You 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 table 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