8. You have created a linked server to your Oracle instance to control access to
the data in the Oracle instance via SQL Server. You now want to prevent your
users from performing distributed ad hoc queries against your Oracle instance.
However, there are situations where developers need to perform distributed
ad hoc queries against SQL Server instances. What could you do to prevent ad
hoc access to only the Oracle instances?
A. Use sp_configure to set “Ad Hoc Distributed Queries” to 0
B. Enable the “Disallow adhoc access” property on the Oracle OLE DB
provider
C. Un-install the Oracle providers from the server
D. Create a linked server to the Oracle instance
Bạn đang xem 8. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P82 PPSX