Tag: asp

Questions Related to asp

  1. ADODB.Connection

  2. ADODB.Recordset

  3. ADODB.Command

  4. All of the above


Correct Option: D

What is the sequential procedure in working with databases?

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

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


Correct Option: B

AI Explanation

To answer this question, you need to understand the sequential procedure in working with databases.

Option A) Open the database, interact with the db, close the database - This option is incorrect because it does not follow the standard procedure for working with databases. Opening and closing the database typically refers to starting and stopping the database service, not establishing and closing a connection.

Option B) Open a connection, interact with the db, close the connection - This option is correct because it outlines the correct sequential procedure for working with databases. To interact with a database, you first need to establish a connection to the database. Once the connection is established, you can perform various operations such as querying data, inserting records, updating records, etc. Finally, after you have completed your tasks, you need to close the connection to release any resources and ensure proper termination.

The correct answer is B) Open a connection, interact with the db, close the connection. This option is correct because it follows the standard procedure for working with databases by establishing a connection, interacting with the database, and then closing the connection when finished.

  1. Connection object, RecordingSet object

  2. Connection object, Recordset object

  3. Connect object, RecordingSet object

  4. Connect object, Recordset object


Correct Option: B
  1. Specifies whether to use a DSN or DSN-less connection

  2. Specifies which type of database is being used

  3. Specifies the type of driver to use, database format and filename

  4. First opens the initial connection to a database before giving any database information


Correct Option: D
  1. Specifies whether to use a DSN or DSN-less connection

  2. Specifies which type of database is being used

  3. Specifies the type of ODBC driver to use, database format and filename

  4. Opens the initial connection to a database


Correct Option: C
  1. DNS, DNS-less

  2. DSN, DSN-less

  3. ODBC, ADO

  4. OLEDB, ADO


Correct Option: B
  1. Type of database

  2. Type of driver to use

  3. Location of database

  4. username

  5. All Of The Above


Correct Option: E