Saturday, May 25, 2013
Link Dir
Download
Resources
Music
Home
IT Quiz Menu
Quizzes Home Page
General Quizzes and Trivia
PC Troubleshooting
Networking Guide
Info Tech Glossary
Code Bank
Web Development
IT Quizzes Category
ASP
ASP 2
ASP ADO
ASP Server Side Include
ASP.NET
C# .NET
CISCO-CCNA
Computer Hardware
Computer Technolgy
Computer Trivia
CSS
Database Management
HTML
IIS 6 Administration
Java
JavaScript
Javascript Fundamental
Linux
MCSE 70-291
Network Plus
Networking
Networking 2
OSI Model
PERL
PHP
Project Management
Search Engine Optimization
Server Administrator
SQL
SQL Advanced
SQL Server Administration
VB.NET
Web Designer
Windows 2000 Server
Windows 2003 Server Adminstration
XHTML
XML
Search Web Link
Search Software
Quizzes Main Page
IT Quizzes
ASP ADO Quiz
E-mail this Quiz to a friend
Bookmark this Quiz
ASP ADO Quiz
There are 18 questions in this quiz. Good luck!
Passing grade is 70% = C.
1)
Database connectivity with ADO has 3 main objects:
a)
ADODB.Connection
b)
ADODB.Recordset
c)
ADODB.Command
d)
All of the above
2)
What is the sequential procedure in working with databases?
a)
Open the database, interact with the db, close the database
b)
Open a connection, interact with the db, close the connection
3)
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?
a)
Connection object, RecordingSet object
b)
Connection object, Recordset object
c)
Connect object, RecordingSet object
d)
Connect object, Recordset object
4)
What is a connection object?
a)
Specifies whether to use a DSN or DSN-less connection
b)
Specifies which type of database is being used
c)
Specifies the type of driver to use, database format and filename
d)
First opens the initial connection to a database before giving any database information
5)
What is a connection string?
a)
Specifies whether to use a DSN or DSN-less connection
b)
Specifies which type of database is being used
c)
Specifies the type of ODBC driver to use, database format and filename
d)
Opens the initial connection to a database
6)
There are two methods of connecting to an Access database. Which are they?
a)
DNS, DNS-less
b)
DSN, DSN-less
c)
ODBC, ADO
d)
OLEDB, ADO
7)
Which connection method requires a connection object?
a)
DSN
b)
DSN-less
c)
Both
8)
Which connection method requires a connection string?
a)
DSN
b)
DSN-less
c)
Both
9)
What information can a connection string contain about the database you are trying to connect to?
a)
Type of database
b)
Type of driver to use
c)
Location of database
d)
username
e)
All Of The Above
10)
What must your ASP code have if you are using the DSN method of connecting?
a)
Connection object
b)
Connection string
c)
Both
11)
What must your ASP code have if you are using the DSN-less method of connecting?
a)
Connection object
b)
Connection string
c)
Both
12)
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
a)
DSN
b)
DSN-less
c)
Neither - the code is wrong
13)
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
a)
DSN
b)
DSN-less
c)
Neither - the code is wrong
14)
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
a)
DSN
b)
DSN-less
c)
Both A and B
d)
Neither - the code is wrong
15)
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
a)
DSN
b)
DSN-less
c)
Neither - the code is wrong
16)
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
a)
True
b)
False
17)
It is okay to have connections open to multiple Access databases
a)
True
b)
False
18)
What is the sequential procedure in working with databases?
a)
Connection string, connection object, close connection string, close connection object
b)
Connection object, connection string, close connection string, close connection object
c)
Connection object, connection string, close connection object, close connection string
E-mail this Quiz to a friend
Bookmark this Quiz
IT Quiz Menu
IT Quizzes Category
IT Quiz Menu IT Quizzes Category
