Multiple choice technology databases

Which two reports can be retrieved by using the various procedures in the DBMS_METADATA PL/SQL package?

  1. DDL report for all objects dependent on a table

  2. DDL report for all the invalidated objects in a schema

  3. data definition language (DDL) report for all the tables in a schema

  4. DDL report for all the objects stored in a tablespace
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

DBMS_METADATA package provides GET_DEPENDENT_DDL to retrieve DDL for all objects that depend on a specified object (like a table). GET_DDL can fetch DDL for objects of a specific type within a schema, such as all tables. It doesn't directly track object invalidation status (B is false) or provide tablespace-level object listings (D is false).

Keep practicing — related questions