YOU NEED TO WRITE A QUERY THAT JOINS DATA FROM YOUR LOCAL SQL SERVE...

9. You need to write a query that joins data from your local SQL Server Instance

with data from an Oracle instance. You need to be able to submit specific

syntax to the Oracle instance to get the correct results by using a pass-through

query. No linked servers currently exist for the remote Oracle instance. You are

not an administrator on the system. Which one of the following choices meets

your needs?

A. Use OPENQUERY( )

B. Use OPENDATASOURCE( )

C. Use OPENROWSET( )

D. Create a Linked Server