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

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

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

A.
report of invalidated objects in a schema

B.
report of statistics of an object in the database

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

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

Show Hint

Leave a Reply 3

Your email address will not be published. Required fields are marked *

morriarti

morriarti

C,D
https://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_metada.htm#BABFBDDG
Look for GET_xxx Functions
“These functions allow you to fetch metadata for objects with a single call. They encapsulate calls to OPEN, SET_FILTER, and so on. The function you use depends on the characteristics of the object type and on whether you want XML or DDL.

GET_xxx is used to fetch named objects, especially schema objects (tables, views).
GET_DEPENDENT_xxx is used to fetch dependent objects (audits, object grants).
GET_GRANTED_xxx is used to fetch granted objects (system grants, role grants).”

Reply