Back
0

ADO ASP Quiz

Description: ADO ASP Quiz
Number of Questions: 10
Created by:
Tags: asp ado
Start the Quiz
Attempted 0/10 Correct 0 Score 0
‹
›

Database connectivity with ADO has 3 main objects:

asp ado

  1. ADODB.Connection

  2. ADODB.Recordset

  3. ADODB.Command

  4. All of the above

Show answer
Correct Option: D

What is the sequential procedure in working with databases?
asp ado

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

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

Show answer
Correct Option: B

ActiveX Data Objects (ADO) comes installed with ASP and allows your pages to easily connect to databases. Which two ADO objects are used to open a connection and interact with the database?
asp ado

  1. Connection object, RecordingSet object

  2. Connection object, Recordset object

  3. Connect object, RecordingSet object

  4. Connect object, Recordset object

Show answer
Correct Option: B

What is a connection object?
asp ado

  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

Show answer
Correct Option: D

What is a connection string?

asp ado

  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

Show answer
Correct Option: C

There are two methods of connecting to an Access database. Which are they?

asp ado

  1. DNS, DNS-less

  2. DSN, DSN-less

  3. ODBC, ADO

  4. OLEDB, ADO

Show answer
Correct Option: B

Which connection method requires a connection object?
asp ado

  1. DSN

  2. DSN-less

  3. Both

Show answer
Correct Option: C

Which connection method requires a connection string?

asp ado

  1. DSN

  2. DSN-less

  3. Both

Show answer
Correct Option: C

What information can a connection string contain about the database you are trying to connect to?

asp ado

  1. Type of database

  2. Type of driver to use

  3. Location of database

  4. username

  5. All Of The Above

Show answer
Correct Option: E

What must your ASP code have if you are using the DSN method of connecting?

asp ado

  1. Connection object

  2. Connection string

  3. Both

Show answer
Correct Option: C

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) Connection object - This option is incorrect because while using the DSN method of connecting, you need both a connection object and a connection string.

Option B) Connection string - This option is incorrect because while using the DSN method of connecting, you need both a connection object and a connection string.

Option C) Both - This option is correct because if you are using the DSN method of connecting in ASP code, you need both a connection object and a connection string. The connection object is used to establish the connection to the database server, and the connection string contains the necessary information (such as the DSN name) to establish the connection.

The correct answer is C. This option is correct because when using the DSN method of connecting in ASP code, you need both a connection object and a connection string.

- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions