Know-IT-all Chapter Quiz #18 The Guru's Guide to SQL Server Architecture and Internals

Think you know everything about SQL Server's Open Data Services Object Linking and Embedding (ODSOLE)? Don't be so sure! Check your know-how and get a chance to win a copy of The Guru's Guide to SQL Server Architecture and Internals by best-selling author Ken Henderson, courtesy of Addison-Wesley.

This Content Component encountered an error
This Content Component encountered an error
Think you know everything about SQL Server's Open Data Services Object Linking and Embedding (ODSOLE)? Don't be so sure! We challenge you to test your know-how by taking our new quiz! Share the results with us and get a chance to win a copy of The Guru's Guide to SQL Server Architecture and Internals by best-selling author Ken Henderson, courtesy of Addison-Wesley. All answers to this quiz are found in the June 25-July 1 featured chapter download, but be warned - this quiz is designed to be challenging! Good luck!

How to take the quiz:
- After reading the question, note the letter of your answer. Check your answers by clicking the link to the answer key at the end of the quiz.
- Send us an e-mail telling us how you did to participate in our book giveaway this week.
NOTE: The weekly prize drawing is random - your score will not affect your chances of winning.
- To read more about a topic, open the chapter and locate the indicated page after each answer.



Chapter Quiz #18

1. What sets CoInitalizeEx apart from CoInitialize and OleInitialize?

a. It's made up while the other two really exists.
b. It permits the threading model to be specified.
c. CoInitalizeEx forces the STA model.
d. It is hard-coded to use the STA model.

2. You can pass context parameters into sp_OACreate. However, this parameter in turn becomes what?

a. A parameter for the CLSIDFromProgID API function.
b. Moot.
c. A component of one of two possible ODS event handlers.
d. The dwClsContext parameter to CoCreateInstance.

3. What is the current preferred term for OLE automation?

a. Automation
b. SOLE
c. SOLE automation
d. SQL automation

4. When setting up an sp_exporttable proc, you start with creating an SQLServer object. What is the next step?

a. Call the ExportData method.
b. Check the DMO specs for potential replication conflicts.
c. Create a BulkCopy object.
d. It's a trick question - the first step is to create a BulkCopy object.

5. The ODSOLE facility uses late binding to interact with COM objects. This means what, specifically?

a. It makes calls to the IDispatch COM interface.
b. You can create D-COM objects.
c. It enables you to automate the STA threading process.
d. SQL-DMO calls can be enabled and disabled by simple user commands.



CLICK HERE FOR ANSWER KEY AND TO WIN A FREE BOOK!


This was first published in June 2004

Dig deeper on Windows Operating System Management

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchServerVirtualization

SearchCloudComputing

SearchExchange

SearchSQLServer

SearchWinIT

SearchEnterpriseDesktop

SearchVirtualDesktop

Close