ExamQuestions.com

Register
Login
Oracle Database 11g Advanced PLSQL Exam Questions

Oracle

Oracle Database 11g Advanced PLSQL

5 / 68

Question 5:

See the Exhibit and examine the PL/SQL code for the following table: 
image
Which statement is true about the compilation and execution of the function? 

Answer options:

A. The function retrieves the metadata in Extensible Markup Language (XML) format for creating the TIMECARDS table in the HR schema
B. The compilation produces an error because DBMS_METADATA.SET_FILTER(h,`SCHEMA`,`HR`) is not placed in the correct order
C. The function retrieves the metadata as a data definition language (DDL) statement for creating the TIMECARDS table in the HR schema
D. The execution of the function produces an error because multiple objects are fetched and DBMS_METADATA.FETCH_CLOB is not called in a LOOP