Which of the Following SQL Statements Will Remove the SELECT

question 93

Multiple Choice

Which of the following SQL statements will remove the SELECT ANY TABLE privilege from the database so it can never be granted to another user?​

• A) ​REVOKE SELECT ANY TABLE;
• B) ​REVOKE SELECT ANY TABLE FROM data_dictionary;
• C) ​REMOVE SELECT ANY TABLE;
• D) ​none of the above

---

Definitions:

Sub-subsidiaries

Entities that are controlled by a subsidiary of a parent company, thus being one level below subsidiaries in the ownership hierarchy.

Sequence of Acquisition Dates

Refers to the chronological order in which significant ownership interests in other entities are obtained, impacting the consolidation process and valuation of investments.

Indirect NCI

Represents the portion of equity in a subsidiary not attributable directly to the parent company, often arising in complex group structures.

Tiered Group

A structure of multiple groups or entities arranged in a hierarchy, where control or ownership is exercised through several layers.