ASP NET Questions


Q.  You need to select a class that is optimized for key - based item retrieval from both small and large collections. Which class should you choose?

a. OrderedDictionary class
b. HybridDictionary class
c. ListDictionary class
d. Hashtable class


ANSWER: See Answer
 
No explanation is available for this question!
MCQs:  What is Caspol?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which data provider gives the maximum performance from a connection to SQL Server?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which CommandType value is incorrect?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which SqlCommand execution returns the value of the first column of the first row from a table?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which SqlCommand execution returns the number of effected records in the table?
Category: Computer Science MCQs,   Published by: teswesm
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: teswesm
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: teswesm
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: teswesm
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: teswesm
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: teswesm
MCQs:  How do I explicitly turn on connection pooling for an OLE DB data source?
Category: Computer Science MCQs,   Published by: teswesm
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: teswesm
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: teswesm
MCQs:  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.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  How do you execute multiple SQL statements using a DataReader?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  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
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  What are the three primary kinds of parameters?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  How do you determine the actual SQL data type of a SqlParameter (the type expected by the SQL Server)?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which of the following is true?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  If you are using the DataSet and you have to display the data in sorted order what will you do?
Category: Computer Science MCQs,   Published by: teswesm