1. Home
  2. Back Today Date :- Friday 15th of May 2026 01:56:57 PM

ASP.Net - Online Exam Test Papers | ASP.Net - MCQs[multiple choice questions and answers ] | ASP.Net - Mock Test Papers | ASP.Net - Practice Papers | ASP.Net - Sample Test Papers |

Question:
How do I explicitly turn on connection pooling for an OLE DB data source?

1.By setting the OLE DB Services connection string keyword to 0

2.By setting the OLE DB Services connection string keyword to -4

3.By setting the OLE DB Services connection string keyword to -1

4.By setting the OLE DB Services connection string keyword to -7

Posted Date:-2022-02-01 13:04:17

More MCQS Questions and answers

  1. When would you typically use an Input parameter? 1. When the parameter value is created based on user input 2. When the parameter is used to send data from the application to the database 3. When the command is set to execute a statement with a WHERE clause 4. When the parameter value is passed to an INSERT statement
  2. Which SqlCommand execution returns the value of the first column of the first row from a table?
  3. If you are using user control in ASP.NET page which directory will be used?
  4. If you must use a user name and password to connect to a database, where should you store the sensitive information?
  5. In which Event you can set the value of a Theme?
  6. What is Caspol?
  7. What is the file extension of web service in ASP.NET?
  8. What is the last event of web page life cycle?
  9. Which CommandType value is incorrect?
  10. Which control is required for every page that have AJAX Extensions for ASP.NET?
  11. Which method is used to dynamically register client script from code?
  12. Which of the following are reference types?
  13. Which of the following works on client side?
  14. You have to log the data into database if your session times out. Which event you will use?
  15. A web application can contain ____
  16. AnUpdatePanel control defined on a page. Button control is placed outside of the UpdatePanel. How to cause the UpdatePanel to execute an update.
  17. Application_Start event is available in which file?
  18. ByDefault ASP.Net SessionID is stored in _____
  19. How do I explicitly turn on connection pooling for an OLE DB data source?
  20. How do you determine the actual SQL data type of a SqlParameter (the type expected by the SQL Server)?
  21. If you are using the DataSet and you have to display the data in sorted order what will you do?
  22. If you are using Webparts in your web page then which control is necessary?
  23. If you want to access a web service method, which attribute it must have?
  24. 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
  25. Range Validator control in ASP.NET supports which type?
  26. What are the Command object property settings to execute a stored procedure? 1. CommandType = Text, CommandText = stored procedure name 2. CommandType= Text, CommandText = SQL syntax to execute the stored procedure 3. CommandType = StoredProcedure, CommandText = SQL syntax to execute the stored procedure 4. CommandType = StoredProcedure, CommandText = stored procedure name
  27. What are the element of code access security?
  28. 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
  29. What are the three primary kinds of parameters?
  30. What component do you need to enable for a user to add new web parts?
  31. 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
  32. 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.
  33. What is jQuery? 1. jQuery is an open source library 2. It works client side. 3. jQuery is java technology.
  34. What is the connection string’s key / value pair for using WindowsAuthentication in SQLServer 2000 and SQL Server 2005?
  35. 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
  36. What is the recommended method for securing sensitive connection string information?
  37. What property contains the actual error message returned by SQL Server? 1. SqlException.Source 2. SqlException.Message 3. SqlError.Class 4. SqlError.Message
  38. What should you do to access the returned tabular data after starting execution of a command that runs asynchronously? (Choose all that apply.) 1. Call the EndExecuteNonQuerymethod. 2. Call the EndExecuteReadermethod. 3. Wait for the StatementCompletedevent to fire and iterate through the DataReader. 4. Wait for the StatementCompletedevent to fire, call the EndExecuteReadermethod, and then iterate through the DataReader.
  39. When the garbage collector runs.
  40. Which data provider gives the maximum performance from a connection to SQL Server?
  41. Which interface you will use wrap an AJAX client control into a custom server control?
  42. Which of the following are required to enable users to change the title of web part?
  43. Which of the following is true ? 1. AJAX is a platform-independent technology 2. AJAX can work with web application 3. AJAX can only work with ASP.NET 4. AJAX is a platform-dependent technology
  44. Which of the following is true when referencing master page from content page?
  45. Which of the following is true?
  46. Which of the following template supports by Repeater control?
  47. Which of the following works on server side?
  48. Which SqlCommand execution returns the number of effected records in the table?
  49. Why should you write the cleanup code in Finally block?
  50. You need to initialize some variable only when the first user accesses the application. What should you do?
Search