🎴 Flashcard Mode
SQL Server and Oracle Database Programming Quiz
Card1 / 11
Mastered0
Review0
QuestionClick to flip
Which two types of metadata can be retrieved by using the various procedures in the DBMS_METADATA PL/SQL package? (Choose two.)
AnswerClick to flip back
A
data definition language (DDL) for all objects in a schema
B
DDL for all object grants on a table in the database
💡 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.