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?

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?

Accepted Answer

C. The function retrieves the metadata as a data definition language (DDL) statement for creating the

Answer

A. The function retrieves the metadata in Extensible Markup Language (XML) format for creating the

Answer

B. The compilation produces an error because DBMS_METADATA.SET_FILTER(h,'SCHEMA','HR')

Answer

D. The execution of the function produces an error because multiple objects are fetched and

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')…

Question

Options

How the community answered

Community Discussion