Home › Quizzes › ASP Database Connection Methods with ADO

ASP Database Connection Methods with ADO

Test your knowledge of ADO database connection methods in ASP, including DSN vs DSN-less connections, connection management best practices, and sequential database operation procedures.

8 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

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

  1. Connection object
  2. Connection string
  3. Both
Question 2 Multiple Choice (Single Answer)

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
Question 3 Multiple Choice (Single Answer)

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
Question 4 Multiple Choice (Single Answer)

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
Question 5 Multiple Choice (Single Answer)

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
Question 6 Multiple Choice (Single Answer)

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
Question 7 Multiple Choice (Single Answer)

It is okay to have connections open to multiple Access databases

  1. True
  2. False
Question 8 Multiple Choice (Single Answer)

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
← Back to Quizzes