Create Next App

Exam contains 75 questions

Page 5 of 13

Question 25 🔥

The STUDENTS table with column LAST_NAME of data type VARCHAR2 exists in your database schema.Examine this PL/SQL block:Which two actions must you perform for this PL/SQL block to execute successfully?

Which database solution meets these requirements?

A. Replace the FOR loop with FOR name_rec IN names_varray.FIRST .. names_varray.LAST LOOP.

Highly voted

B. Replace the L_NAME_TYPE declaration with TYPE 1_name_type IS VARRAY (25) OF SYS_REFCURSOR;

Highly voted

C. Add name_rec name_cur%ROWTYPE; at the end of the DECLARE section.

Highly voted

D. Replace the NAMES_VARRAY declaration with names_varray 1_name_type := 1_name_type ();

Highly voted

E. Replace the NAMES_VARRAY declaration with names_varray 1_name_type := null;

Highly voted

F. Add names_varray.EXTEND after the FOR …LOOP statement.

Highly voted

Discussion of the question

Question 26 🔥

Which two blocks of code execute successfully?

Which database solution meets these requirements?

A. DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type; BEGIN my_tab (1) :=1; END;

Highly voted

B. DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type := tab_type(2); BEGIN my_tab(1) :=55; END;

Highly voted

C. DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type; BEGIN my_tab. EXTEND (2); my_tab (1) := 55; END;

Highly voted

D. DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type; BEGIN my_tab := tab_type (); my_tab (1) := 55; END;

Highly voted

E. DECLARE TYPE tab_type IS TABLE OF NUMBER my_tab tab_type := tab_type (2, NULL, 50); BEGIN my_tab.EXTEND (3, 2);

Highly voted

Discussion of the question

Question 27 🔥

Examine this code:Users of this function may set different date formats in their sessions.Which two modifications must be made to allow the use of your sessions date format when outputting the cached result of this function?

Which database solution meets these requirements?

A. Change the RETURN type to DATE.

Highly voted

B. Change AUTHID to CURRENT_USER.

Highly voted

C. Use the TO_CHAR function around SYSDATE, that is, 1_date := TO_CHAR (SYSDATE).

Highly voted

D. Change the data type of 1_date to DATE.

Highly voted

E. Set NLS_DATE_FORMAT to ‘DD-MM-YY’ at the instance level.

Highly voted

F. Set the RESULT_CACHE_MODE parameter to FORCE.

Highly voted

Discussion of the question

Question 28 🔥

Which statement is true about internal and external LOBs?

Which database solution meets these requirements?

B. A NOEXIST_DIRECTORY exception can be raised when using internal and external LOBs.

Highly voted

C. Internal and external LOBs can be written using DBMS_LOB.

Highly voted

D. After an exception transfers program control outside a PL/SQL block, all references to open external LOBs are lost.

Highly voted

E. When using DBMS_LOB.INSTR for internal and external LOBs, DBMS_LOB.OPEN should be called for each LOB.

Highly voted

A. An external LOB can be loaded into an internal LOB variable using the DBMS_LOB package.

Highly voted

Discussion of the question

Question 29 🔥

Which two statements about the PL/SQL hierarchical profiler are true?

Which database solution meets these requirements?

A. Access it using the DBMS_PROFILER package.

Highly voted

B. Access it using the DBMS_HPROF package.

Highly voted

C. Profiler data is recorded in tables and published in HTML reports.

Highly voted

D. It is only accessible after a grant of the CREATE PROFILE privilege.

Highly voted

E. It helps you identify subprograms that are causing bottlenecks in application performance.

Highly voted

Discussion of the question

Question 30 🔥

The STUDENTS table exists in your schema.Examine the DECLARE section of a PL/SQL block:Which two blocks are valid?

Which database solution meets these requirements?

B. BEGIN OPEN stcur; cursor1 :=stcur; END;

Highly voted

A. BEGIN OPEN cursor3 FOR SELECT * FROM students; cursor1 :=cursor3; END;

Highly voted

C. BEGIN OPEN cursor1 FOR SELECT * FROM students; stcur :=cursor1; END;

Highly voted

D. BEGIN OPEN stcur; cursor3 :=stcur; END;

Highly voted

E. BEGIN OPEN cursor1 FOR SELECT * FROM students; cursor2 :=cursor1;

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_148

Exam contains 75 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us