Difficulty: Easy
Correct Answer: Properties, Collections, and Methods
Explanation:
Introduction / Context:
ADO (ActiveX Data Objects) presents data to developers through objects such as Connection, Command, and Recordset. These objects sit atop OLE DB providers and expose consistent, object-oriented interfaces to query and navigate tabular data.
Given Data / Assumptions:
Concept / Approach:
ADO objects are designed around three pillars: Properties (for configuration/state), Methods (to perform actions), and Collections (to enumerate related objects such as Fields). This trio provides a complete interaction surface without tying code to any specific DBMS.
Step-by-Step Solution:
Verification / Alternative check:
Reference any ADO Recordset documentation: its object model explicitly lists properties, methods, and collections (for example, Fields collection).
Why Other Options Are Wrong:
Common Pitfalls:
Assuming ADO Recordset equals a simple array. It is a rich COM object with navigational and update semantics, not just a passive container.
Final Answer:
Properties, Collections, and Methods
Discussion & Comments