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?
-
Connection object, RecordingSet object
-
Connection object, Recordset object
-
Connect object, RecordingSet object
-
Connect object, Recordset object
The two primary ADO objects are Connection and Recordset. The Connection object establishes the link to the database. The Recordset object represents the set of records returned from a query and allows you to navigate and manipulate those records. Note the precise spelling: 'Recordset' (not 'RecordingSet') and 'Connection' (not 'Connect').
To answer this question, you need to understand the ActiveX Data Objects (ADO) and its objects used to interact with databases.
Option A) Connection object, RecordingSet object - This option is incorrect. The correct object names are "Recordset" and "Connection," not "RecordingSet."
Option B) Connection object, Recordset object - This option is correct. In ADO, the Connection object is used to establish a connection with the database, and the Recordset object is used to interact with the data returned from the database.
Option C) Connect object, RecordingSet object - This option is incorrect. The correct object names are "Recordset" and "Connection," not "RecordingSet."
Option D) Connect object, Recordset object - This option is incorrect. The correct object names are "Recordset" and "Connection," not "Connect."
The correct answer is B. This option is correct because the Connection object and Recordset object are the two ADO objects used to open a connection and interact with the database.