READ Free Dumps For Oracle- 1z0-146

Question ID 2803	Which two statements are true about cursor variables? (Choose two.)
Option A	A.    Cursor variables can be parameterized like cursors.
Option B	B.    The query associated with a cursor variable cannot reference host variables and PL/SQL variables.
Option C	C.    The FETCH statement executes the query associated with a cursor variable and identifies the result set.
Option D	D.    Cursor attributes (%FOUND, %NOTFOUND, %ISOPEN, and %ROWCOUNT) can be applied to a cursor variable.
Option E	E.    The OPEN FOR statement executes the query associated with a cursor variable and identifies the result set.
Correct Answer	D,E

Explanation

Question ID 2804	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?
Option A	A.    The function retrieves the metadata in Extensible Markup Language (XML) format for creating the TIMECARDS table in the HR schema.
Option B	B.    The compilation produces an error because DBMS_METADATA.SET_FILTER(h,'SCHEMA','HR')is not placed in the correct order.
Option C	C.    The function retrieves the metadata as a data definition language (DDL) statement for creating the TIMECARDS table in the HR schema.
Option D	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.
Correct Answer	C

Explanation

Previous-Page 1 2. . . 33 34 35 36 37 38 39. . . 93 94 Next-Page

Send email to admin@getfreedumps for new dumps request!!!