ASP NET Questions

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

a. Implement a try / catch block that catches System.Exceptions.
b. Implementing custom error page.
c. Implement a try / catch block that catches individual exception types, such as SQLException.
d. Display an error message.


ANSWER: See Answer
 
No explanation is available for this question!
MCQs:  AnUpdatePanel control defined on a page. Button control is placed outside of the UpdatePanel. How to cause the UpdatePanel to execute an update.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which method is used to dynamically register client script from code?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which interface you will use wrap an AJAX client control into a custom server control?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  What is jQuery? 1. jQuery is an open source library 2. It works client side. 3. jQuery is java technology.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  If you must use a user name and password to connect to a database, where should you store the sensitive information?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  What is the recommended method for securing sensitive connection string information?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  What are the element of code access security?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  What is Caspol?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which data provider gives the maximum performance from a connection to SQL Server?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which CommandType value is incorrect?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which SqlCommand execution returns the value of the first column of the first row from a table?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which SqlCommand execution returns the number of effected records in the table?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  OleDbConnectionobject works with? 1. When connecting to an Oracle database 2. When connecting to an Office Access database 3. When connecting to SQL Server 6.x or later 4. When connecting to SQL Server 2000
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  What is the minimal information needed by a connection string to open a connection to a SQL Server 2000 or SQL Server 2005 database? 1. A valid data source 2. A valid provider name 3. A valid file path 4. Appropriate credentials or Integrated Security settings
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  What happens when you call the Close method of a connection object? 1. The connection is destroyed. 2. The connection is returned to the connection pool. 3. The StateChangeevent is fired. 4. All non - committed pending transactions are rolled back.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  What determines the connection pool that a connection should use? 1. A connection string 2. The identity or credentials of the user opening the connection 3. The database being connected to 4. The connection object used to connect to the database
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  What are the recommended techniques for enabling connection pooling on for a SQL Server 2000 or SQL Server 2005 database? 1. Setting the OLE DB Services connection string keyword to -4 2. Opening a connection and not explicitly disabling pooling 3. Setting the connection string keyword Pooling = True in the connection string 4. Using the Connection Pooling tab of the ODBC Data Source Administrator dialog Box
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  How do I explicitly turn on connection pooling for an OLE DB data source?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  What property contains the actual error message returned by SQL Server? 1. SqlException.Source 2. SqlException.Message 3. SqlError.Class 4. SqlError.Message
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  What is the connection string’s key / value pair for using WindowsAuthentication in SQLServer 2000 and SQL Server 2005?
Category: Computer Science MCQs,   Published by: T-Code Scripts