YOU HAVE CREATED A LINKED SERVER TO YOUR ORACLE INSTANCE TO CONTROL...

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 0B. Enable the “Disallow adhoc access” property on the Oracle OLE DB providerC. Un-install the Oracle providers from the serverD. Create a linked server to the Oracle instanceCorrect Answer and Explanation: B. By setting the “Disallow adhoc access” on the Oracle provider, you prevent any users who are not system administrators from accessing the Oracle provider in ad hoc queries.Incorrect Answers and Explanations: A, C, and D. Answer A is incorrect because it disables all ad hoc queries and prevents the required ad hoc access to other SQL Server instances. Answer C is incorrect because it would