Oracle
1Z0-146 · Question #24
1Z0-146 Question #24: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #24. The question stem and answer options stay visible for context.
Question
Examine the PL/SQL code for the GET_TABLE_MD function given below: CREATE OR REPLACE FUNCTION get_table_md RETURN CLOB IS h NUMBER; th NUMBER; doc CLOB; BEGIN h := DBMS_METADATA.OPEN('TABLE'); DBMS_METADATA.SET_FILTER(h,'SCHEMA','HR'); DBMS_METADATA.SET_FILTER(h,'NAME','TIMECARDS'); th := DBMS_METADATA.ADD_TRANSFORM(h,'DDL'); doc := DBMS_METADATA.FETCH_CLOB(h); DBMS_METADATA.CLOSE(h); RETURN doc; END; Which statement is true about the compilation and execution of the function?
Options
- AThe function retrieves the metadata in Extensible Markup Language (XML) format for creating the
- BThe compilation produces an error because DBMS_METADATA.SET_FILTER(h,'SCHEMA','HR')
- CThe function retrieves the metadata as a data definition language (DDL) statement for creating the
- DThe execution of the function produces an error because multiple objects are fetched and
Unlock 1Z0-146 to see the answer
You've previewed enough free 1Z0-146 questions. Unlock 1Z0-146 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.