O'Reilly logo

Guru's Guide to SQL Server Architecture and Internals, The by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required