Alien head

ADO ASP Quiz

Description: ADO ASP Quiz
Number of Questions: 10
Created by:
Tags: asp ado

Database connectivity with ADO has 3 main objects:

  1. ADODB.Connection

  2. ADODB.Recordset

  3. ADODB.Command

  4. All of the above

Answer: 4

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

Answer: 2

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?

  1. Connection object, RecordingSet object

  2. Connection object, Recordset object

  3. Connect object, RecordingSet object

  4. Connect object, Recordset object

Answer: 2

What is a connection object?

  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

Answer: 4

What is a connection string?

  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

Answer: 3

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

  1. DNS, DNS-less

  2. DSN, DSN-less

  3. ODBC, ADO

  4. OLEDB, ADO

Answer: 2

Which connection method requires a connection object?

  1. DSN

  2. DSN-less

  3. Both

Answer: 3

Which connection method requires a connection string?

  1. DSN

  2. DSN-less

  3. Both

Answer: 3

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

  1. Type of database

  2. Type of driver to use

  3. Location of database

  4. username

  5. All Of The Above

Answer: 5

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

  1. Connection object

  2. Connection string

  3. Both

Answer: 3
+ View questions