ANSWER:
D: The adExecuteNoRecords constant is normally used in conjunction with the adCmdText or adCmdStoredProc command types. This will optimize the command execution because the provider is aware that no records should be returned, and the provider does not need to keep listening for returned records.

Answers in Depth...