Question 1

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

Connection object
Connection string
Both

Answer

Correct Option: C

Question 2

Which connection method is this code using?...Dim dbConn Set dbConn = Server.CreateObject("ADOBD.Connection") dbConn.Connectionstring = "DSN=Quiz; uid=login; pwd=password" dbConn.Open

asp ado

DSN
DSN-less
Neither - the code is wrong

Answer

Correct Option: C

Question 3

Which connection method is this code using?.. Dim dbConn Set dbConn = Server.CreateObject("ADODB.Connection") dbConn.Connectionstring = "DSN=Quiz; uid=login; pwd=password" dbConn.Open

asp ado

DSN
DSN-less
Neither - the code is wrong

Answer

Correct Option: A

Question 4

Which connection method is this code using?..Dim dbConn Set dbConn = Server.CreateObject("ADODB.Connection") dbConn.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};" & _ "DBQ=C:\wwwroot\username\database.mdb" dbConn.open

asp ado

DSN
DSN-less
Both A and B
Neither - the code is wrong

Answer

Correct Option: D

Question 5

Which connection method is this code using?..Dim dbConn Set dbConn = Server.CreateObject("ADODB.Connection") dbConn.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};" & _ "DBQ=C:\wwwroot\username\database.mdd" dbConn.Open

asp ado

DSN
DSN-less
Neither - the code is wrong

Answer

Correct Option: C

Question 6

While it is important to properly open the connection to the database, it is equally important to close the connection. Leaving a connection open is the same as leaving your house with the door open...Dim dbConn Set dbConn = Server.CreateObject("ADODB.Con

asp ado

True
False

Answer

Correct Option: B

Question 7

It is okay to have connections open to multiple Access databases

asp ado

True
False

Answer

Correct Option: A

Question 8

What is the sequential procedure in working with databases?

asp ado

Connection string, connection object, close connection string, close connection object
Connection object, connection string, close connection string, close connection object
Connection object, connection string, close connection object, close connection string

Answer

Correct Option: B

Description: ADO ASP Quiz - 1
Number of Questions: 8
Created by: Aliensbrain Bot
Tags: asp ado

ADO ASP Quiz - 1

Find more quizzes from top tags