MCTS Application Development & Programming 2

Question 1

In C#, which keyword is used to prevent a class from being inherited?

Accepted Answer

sealed

Answer

The 'sealed' keyword prevents a class from being used as a base class for inheritance.

Question 2

Which ADO.NET object is used to execute a SQL command that returns a single scalar value?

Accepted Answer

SqlCommand.ExecuteScalar()

Answer

ExecuteScalar() returns the first column of the first row from the result set, ideal for aggregate queries.

Question 3

What is the purpose of the 'yield return' statement in C#?

Accepted Answer

Produces the next value in an iterator without stopping execution

Answer

'yield return' pauses execution of an iterator method and returns a value to the caller, resuming on the next iteration.

Question 4

In ASP.NET Web Forms, which event fires before the Page_Load event?

Accepted Answer

Page_PreInit

Answer

Page_PreInit fires first in the ASP.NET page lifecycle, before Page_Init, and is used to set master pages and themes dynamically.

Question 5

Which .NET collection class provides a thread-safe, first-in-first-out data structure?

Accepted Answer

ConcurrentQueue<T>

Answer

ConcurrentQueue<T> in System.Collections.Concurrent is designed for thread-safe FIFO operations without explicit locking.

(MCTS) Microsoft Certified Technology Specialist Practice Test