Top 80+ Solved ASP.NET MCQ Questions Answer
Q. Which SqlCommand execution returns the number of effected records in the table?
a. ExecuteNonQuery
b. ExecuteReader
c. ExecuteXmlReader
d. ExecuteScalar
Q. 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
Q. 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
Q. 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
Q. Which ADO.NET class provide Connected Environment?
a. DataReader
b. DataSet
c. Command
d. DataWriter
Q. On what object would you set the properties to create a primary key for a DataTable?
a. DataRelation
b. DataColumn
c. DataSet
d. DataTable