0
Alien head

ADO ASP Quiz - 1

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

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

  1. Connection object

  2. Connection string

  3. Both

Answer: 3

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

  1. DSN

  2. DSN-less

  3. Neither - the code is wrong

Answer: 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

  1. DSN

  2. DSN-less

  3. Neither - the code is wrong

Answer: 1

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

  1. DSN

  2. DSN-less

  3. Both A and B

  4. Neither - the code is wrong

Answer: 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.mdd" dbConn.Open

  1. DSN

  2. DSN-less

  3. Neither - the code is wrong

Answer: 3

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

  1. True

  2. False

Answer: 2

It is okay to have connections open to multiple Access databases

  1. True

  2. False

Answer: 1

What is the sequential procedure in working with databases?

  1. Connection string, connection object, close connection string, close connection object

  2. Connection object, connection string, close connection string, close connection object

  3. Connection object, connection string, close connection object, close connection string

Answer: 2
+ View questions