View the Exhibit to examine the PL/SQL code for the GET_METADATA function.
Which statement is true about the metadata gathered by the function?
A.
The end result is the creation of DDL for the TIMECARDS table with all instances of the HR
schema changed to SCOTT.
B.
The end result is the creation of an XML document for all tables with all physical, storage,
logging, and other segment attributes.
C.
The end result is the creation of DDL for all tables with all instances of the HR schema
changed to SCOTT along with all physical, storage, logging, and other segment attributes.
D.
The end result is the creation of DDL for all tables and associated indexes with all instances of
the HR schema changed to SCOTT along with all physical, storage, logging, and other
segment attributes.
This part of procedure filters result, only TIMECARDS table from HR schema will remain:
DBMS_METADATA.OPEN(‘TABLE’)
DBMS_METADATA.SET_FILTER(h,’SCHEMA’,’HR’)
DBMS_METADATA.SET_FILTER(h,’NAME’,’TIMECARDS’)
So the answer is A
A
A.
TIMECARDS table from HR schema:
DBMS_METADATA.OPEN(‘TABLE’)
DBMS_METADATA.SET_FILTER(h,’SCHEMA’,’HR’)
DBMS_METADATA.SET_FILTER(h,’NAME’,’TIMECARDS’)
B,C,D false
… DDL for all tables …