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:
Identify what Recordset exposes: Properties (CursorType, LockType), Collections (Fields), Methods (Open, Close, MoveNext, AddNew).Map these to ADO usage patterns: read metadata via Properties; iterate via Collections; act via Methods.Conclude the correct feature set is Properties, Collections, and Methods.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