Syntax for closing and opening the connection in ADO.net is_________

ADO.NET - Quiz(MCQ)

sqlConn.open() and sqlConn.Close()

sqlConn.Open() and sqlConn.close()

sqlConn.Open() and sqlConn.Close()

None of the above

Correct Answer : sqlConn.Open() and sqlConn.Close()

Explanation : The Close method rolls back any pending transactions and releases the Connection from the SQL Server Database.

Recently Updated in ADO.NET Questions

MARS feature is disabled by default. What action you will perform in connection string to enable this feature?

Set ResultSets=True

Set MultipleActiveResultSets=True

Set MultipleResultSets=true

None of the above.

Correct Answer : Set MultipleActiveResultSets=True

What are the three main objects of DataSet in ADO.NET?

DataTable, DataColumn, and type.

DataReader,DataAdapter, and Command.

DataTable, DataRelation, and DataAdapter.

DataTable, DataColumn, and DataRelation.

Correct Answer : DataTable, DataColumn, and DataRelation.

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?

ASPNET_WP.EXE

ASPNET_REGIIS.EXE

ASPNET_REGSQL.EXE

None of the above.

Correct Answer : ASPNET_REGIIS.EXE

New Technologies MCQ's

Machine Learning

Artificial Intelligence