GET_OBJECT_REFERENCES can identify references to which objects?

• A. Only views
• B. Views and Tables
• C. Only tables
• D. Views, Tables, and Materialized views

Answer: (B)

GET_OBJECT_REFERENCES is used to discover which objects reference a given object, helping you understand dependencies and impact. It can identify dependencies involving views and tables, showing which views or other tables rely on a particular table or view. It does not return references to materialized views, so materialized views aren’t included in its results. In practice, you can see how a table is used by various views, and how a view might depend on other views or tables, but you won’t get references to materialized views from this function.