You use Microsoft .NET Framework 4 to develop an application that connects to a local Microsoft
SQL Server 2008 database. The application can access a high-resolution timer. You need to display

the elapsed time, in sub-milliseconds (<1 millisecond), that a database query takes to execute. Which
code segment should you use?

A.
Dim Stare As Integer = Environment.TickCount
command.ExecuteNonQuery()
Dim Elapsed As Integer = (Environment.TickCount) = Start
Console.WriteLine(“Time Elapsed: {0:N3} ms”, Elapsed)

B.
Dim sw As Stopwatch = New Stopwatch() sw.Start()
command.ExecuteNonQuery() su.Stop()
Console.MriteLine(“Time Elapsed: {0:N3} ms”, sw.ElapsedMilliseconds)

C.
Dim sw As Stopwatch = Stopwatch.StartNew() command.ExecuteNonQuery() sw.Stop()
Console.WriteLine(“Time Elapsed: {0:N3> ms”, sw.Elapsed.Totamilliseconds)

D.
Dim Start As DateTime = DateTime.UtcNow command.ExecuteNonQuery()
Dim Elapsed As TimeSpan = DateTime.UtcNow = Start Console.UriteLine(“Time Elapsed: <0:N3>
ms”, Elapsed.Milliseconds)

Explanation:
Stopwatch Class
(http://msdn.microsoft.com/en-us/library/system.diagnostics.stopwatch.aspx)