Contents

Which objects represent a set of records from a table, command object, or SQL query?
a) command object           
b) connection object
c) record set object
d) all of these

c

Which can only interact with relational database and table-like data structure?
a) OLE DB                           
b) ODBC
c) ASP                                   
d) all of these

b

Explanation: ODBC stand for open database connectivity


Which of the following are properties of connection object?
a) command Timeout property       
b) connection String property
c) connection Timeout property
d) all of these

d

How many collections of connection object?
a) one                                    
b) two
c) three                                  
d) four

b

Explanation: error collection, properties collection


How many methods of connection object?
a) five                                   
b) six
c) four                                   
d) eight

b

Explanation: Begin Trans method, close method, Commit Trans method, execute method, open method, Roll back Trans method


Which method begins a new transaction and returns a long value indicating the number of nested transactions?
a) open method  
b) beginTrans method
c) close method   
d) execute method

b