Question 1

Which SqlCommand execution returns the number of effected records in the table?
A)ExecuteNonQuery
B)ExecuteReader
C)ExecuteXmlReader
D)ExecuteScalar

Accepted Answer

ExecuteNonQuery is used for executing SQL commands that do not return any data but affect the data in the database, such as INSERT, UPDATE, DELETE, and returns the number of rows affected.

Question 2

Which CommandType value is incorrect?
A)StoredProcedure
B)TableDirect
C)TableSchema
D)Text

Accepted Answer

The CommandType enumeration in ADO.NET does not include a value named "TableSchema." The valid CommandType values are StoredProcedure, TableDirect, and Text.

Question 3

Which data provider gives the maximum performance from a connection to SQL Server?
A)The OLE DB data provider.
B)The JDBC data provider.
C)The SqlClient data provider.
D)The Oracle data provider

Accepted Answer

The SqlClient data provider is specifically optimized for accessing SQL Server databases, providing the best performance due to its direct access to SQL Server features and optimizations.

Question 4

In a SQL Statement while working with SqlCommand it returns a single value, at that time which method of Command Object will be used?
A)ExecuteNonQuery
B)ExecuteReader
C)ExecuteScalar
D)NonQuery

Accepted Answer

ExecuteScalar is used when the command is expected to return a single value. This method is efficient for queries that return a single value, such as an aggregate value or the result of a scalar function.

Question 5

You want to secure the connection strings contained within your Web.config file to ensure that no one can open the file easily and see the connection information. Which tool must you use to encrypt the connection strings?
A)ASPNET_WP.EXE
B)ASPNET_REGSQL.EXE
C)ASPNET_REGIIS.EXE
D)ASP.NET SYSTEM

Accepted Answer

ASPNET_REGIIS.EXE is the tool used to encrypt and decrypt sections of the Web.config file in ASP.NET applications, including connection strings, to enhance security.

Question 6

Which ADO.NET class provide Connected Environment?
A)DataReader
B)DataSet
C)Command
D)DataWriter

Accepted Answer

DataReader provides a connected environment in ADO.NET, allowing for fast, forward-only, read-only access to data from a data source.

Question 7

On what object would you set the properties to create a primary key for a DataTable?
A)DataRelation
B)DataColumn
C)DataSet
D)DataTable

Accepted Answer

The answer of On what object would you set the...

Quiz 2: ASP.net Authentication, State Management, and Data Access

Which SqlCommand execution returns the number of effected records in the table?

Which CommandType value is incorrect?

Which data provider gives the maximum performance from a connection to SQL Server?

In a SQL Statement while working with SqlCommand it returns a single value, at that time which method of Command Object will be used?

You want to secure the connection strings contained within your Web.config file to ensure that no one can open the file easily and see the connection information. Which tool must you use to encrypt the connection strings?

Which ADO.NET class provide Connected Environment?

On what object would you set the properties to create a primary key for a DataTable?