Multiple choice technology databases

Which two types of metadata can be retrieved by using the various procedures in the DBMS_METADATA PL/SQL package? (Choose two.)

  1. data definition language (DDL) for all objects in a schema

  2. DDL for all object grants on a table in the database

  3. report of invalidated objects in a schema

  4. report of statistics of an object in the database
Reveal answer Fill a bubble to check yourself
A,B Correct answer
Explanation

DBMS_METADATA package can retrieve DDL (Data Definition Language) for all objects within a schema, making option A correct. It can also retrieve DDL for object grants on database tables, making option B correct. Options C and D describe reports that are not the primary function of DBMS_METADATA.

Keep practicing — related questions