Call
whatsapp
9447387064 | 9847003556
0471-2335855 | 8089080088 | 0471-2334855
9447387064 | 9847003556
0471-2335855 | 8089080088 | 0471-2334855
Cisco Training in Trivandrum, Trinity Technologies

No.1 Training Institute in Kerala

ASP.NET QUESTIONS : PART 4

How to open more than one datareader at a time

 

Use different data reader variable

Use different data reader and connection variable

Cannot be done

SHOW ANSWER

What is the advantage of disconnected mode of ADO.Net in ASP.Net?

Automatically dump data at client PC

 Not necessary to connect with server

User data can update and retrieve in dataset and when connection connected, update values with server

All of the above

SHOW ANSWER

Which namespace would you use if you need to create an ASP.NET application with Microsoft SQL Server 2000 as the database. 

System.Data.SQLServer

System.Data.SQLClient

1. System.Data.OleDb

System.Data.Microsoft

SHOW ANSWER

How can you load an XML file directly into a DataSet

By setting the XML property of the DataSet class

By using the GetXML() method of the DataSet classSet

By using the ReadXml() method of the DataSet class

1You cannot load an XML file directly into a DataSet

SHOW ANSWER

By using which of the following web server control can be retrieved              from a relational database?

ObjectDatasource

Sqldatasourse

Accessdatasource

Xmldatasource

SHOW ANSWER

Which SqlCommand execution returns the value of the first column of the first row from a table?

 

ExecuteNonQuery

 ExecuteReader

ExecuteXmlReader

ExecuteScalar

SHOW ANSWER

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

ExecuteNonQuery

ExecuteReader

ExecuteXmlReader

ExecuteScalar

SHOW ANSWER

The best way for handling exception when dealing with a database connection?

Implement a try / catch block that catches System.Exceptions.

 Implementing custom error page.

Implement a try / catch block that catches individual exception types, such as SQLException.

Display an error message.

SHOW ANSWER

Which ADO.NET class provide Disconnected Environment?

 

DataReader 

DataSet

Command

None of the above. 

SHOW ANSWER

Which ADO.NET class provide Connected Environment?

 

DataReader,command

DataSet,dataadapter

Command,dataset

None of the above

SHOW ANSWER

What are the Command Object Methods?

ExecuteNonQuery

 ExecuteReader

ExecuteScalar

All of the above.

SHOW ANSWER

A____block enclose the code that could throw an exception.

Try

Catch

Exception

Error

a and b

SHOW ANSWER

What is the sequential procedure in working with databases?

Open the database, interact with the db, close the database

Open a connection, interact with the db, close the connection 

SHOW ANSWER
BACK | NEXT
TRINITY SOFTWARE SOLUTIONS,IInd floor, Radheyam Towers, Gandhari Amman Kovil Road, Pulimood, Trivandrum - 1
0471-2334855 | 2335855 | 9447387064 | 9847003556 info@trinitytechnology.in