1Z0-146 · Question #44
Which two types of metadata can be retrieved by using the various procedures in the BMS_METADATA PL/SQL package? (Choose two.)
The correct answer is C. DDL for all object grants on a table in the database D. data definition language (DDL) for all objects in a schema. 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…
Question
Which two types of metadata can be retrieved by using the various procedures in the BMS_METADATA PL/SQL package? (Choose two.)
Options
- Areport of invalidated objects in a schema
- Breport of statistics of an object in the database
- CDDL for all object grants on a table in the database
- Ddata definition language (DDL) for all objects in a schema
How the community answered
(23 responses)- A9% (2)
- B13% (3)
- C78% (18)
Explanation
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)."
Topics
Community Discussion
No community discussion yet for this question.