Knowledge Measure

  1. What is the current preferred term for OLE Automation?

  2. True or false: The sp_OA family of extended procedures are actually “spec procs”—their entry points do not reside in an external DLL.

  3. What well-known COM interface does sp_OA use to invoke a method on a COM object?

  4. How does ODSOLE react when an array value is returned from an sp_OA call?

  5. True or false: It is not necessary to release COM object instances created by sp_OA calls because ODSOLE will release them for you automatically at the end of the current batch.

  6. Describe, in general terms, the function of a process's main STA.

  7. True or false: On SQL Server 2000 and earlier, using the sp_OA procedures to instantiate managed code classes that have been published as COM objects is ...

Get Guru's Guide to SQL Server Architecture and Internals, The now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial