takes Boolean condition as parameter and shows error dialog if condition is true; but proceeds without interruption if condition is false.

takes Boolean condition as parameter and throws exception if condition is false; but proceeds without interruption if condition is true.

takes Boolean condition as parameter and shows error dialog if condition is false; but proceeds without interruption if condition is true.

None of above

Structs are value-type variables

Structs are saved on stack

structs can be inherited.

None of the above.

Both 1 and 2

Only 1

Only 2

Both 1 and 3

SQLServer.NET data provider is faster than any other provider.

OLE-DB.NET is universal for accessing various data sources other than SQL Server also, but it’s a .NET layer on top of OLE layer, so is comparatively slow.

ODBC.NET is a deprecated layer provided for backward compatibility to ODBC engines.

None of the above

Both are same.

A table can have multiple primary key and unique key.

Primary keys does not allow null values, but unique key allows only one null value.

Both does not allow null values

string strMessage = "Processing Successful"; string strScript = "alert('" + strMessage + "');"; if(!ClientScript.IsClientScriptBlockRegistered("Startup")) {ClientScript.RegisterClientScriptBlock(Page.GetTy

string strMessage = "Processing Successful"; string strScript = " alert('" + strMessage + "');"; if(!ClientScript.IsClientScriptBlockRegistered("Startup")) {ClientScript.RegisterClientScriptBlock(Page.GetType(), "startup", strScript);}

string strMessage = "Processing Successful"; string strScript = "alert('" + strMessage + "');"; ClientScript. RegisterStartupScript(Page.GetType(), "startup", strScript);

string strMessage = "Processing Successful"; string strScript = " alert('" + strMessage + "');"; ClientScript. RegisterStartupScript(Page.GetType(), "startup", strScript);

Truncate command is same as delete command with no where clause.

Data cannot be rolled back when Truncate command is used, while data can be rolled back when delete command used.

Data cannot be rolled back when Delete command is used, while data can be rolled back when truncate command used.

Both are DML commands.

2

4

5

6

SUM

>

Group by

ASC

using System.Collections.Generic; Dictionary < string , StringBuilder >() dctobj = new Dictionary < string , StringBuilder >;

using System.Collections.Generic; Dictionary < string , StringBuilder > dctobj = new Dictionary < string , StringBuilder >();

using System.Collections.Generic; Dictionary < string , StringBuilder > dctobj = new Dictionary < string , StringBuilder >;

using System.Text; Dictionary < string , StringBuilder > dctobj = new Dictionary < string , StringBuilder >();

Both cross browser and cross platform compatible

XAML can be used for programming user interface

Can be considered as replacement for Windows Presentation Foundation

All of the above

both can create connection to excel and flat files

only second can create connection to excel

first one can create connection to both excel and flat files, whereas second one can craete connection only to Excel

None of the above

grdtest.AllowCustomPaging = true;

grdtest.AllowPaging = true;

grdtest.CurrentPageIndex = E.NewPageIndex;

Both i and ii

Late binding defers type identification process until run time, so prefer Late Binding whenever possible

Always enable Option Explicit and Option Strict options(while using Visual Basic.NET)

If Com objects is referred in code, destroy COM objects always after use

While implementing threading, do not use Thread.Abort to terminate other threads

XPathDocument class is very fast, but it is read-only

The XmlDocument class provides editable representation of XML document, but is comparatively slower.

XPathNavigator object can be created using both XPathDocument and XmlDocument classes, which can be used to to select and navigate XML data.

None of the above

One row

Two rows

Three rows

Four rows

Create CHECK constraints on the tables

Create a DDL trigger to rollback any changes to the tables if then changes affect the columns in the view.

Create the view, specifying the WITH SCHEMABINDING option.

Create the view, specifying the WITH CHECK option.

xp command shell can be enabled by sysadmin by executing following: EXEC sp_configure 'xp_cmdshell', 0;

xp command shell is enabled by default;

xp command shell can be used to run bcp utility

None of above

First Deallocate and then close

Use @@FETCH_STATUS = 0 instead of @@FETCH_STATUS <> 0

No need to use "FETCH NEXT FROM test_cursor INTO @Name" again before END statement

Both i and ii

SQL Server Management Studio

CLR User Defined Type

CLR Stored Procedure

T-SQL View