Create Next App

Exam contains 75 questions

Page 7 of 13

Question 37 🔥

A products TABLE exists with a PROD_ID column.Examine this PL/SQL block:Which statement is true?

Which database solution meets these requirements?

A. It executes successfully only if v_ref_cur := DBMS_SQL.TO_REFCURSOR (V_CUR); is added before the FETCH statement.

Highly voted

B. It executes successfully.

Highly voted

C. It executes successfully only if v_ref_cur: = DBMS_SQL.TO_CURSOR_NUMBER (v_cur); is added before the FETCH statement.

Highly voted

D. It executes successfully only if the FETCH statement is replaced by DBMS_SQL.RETURN_RESULT (v_ref_cur);

Highly voted

E. It executes successfully only if the FETCH statement is replaced by DBMS_SQL.FETCH_ROWS (v_cur);

Highly voted

Discussion of the question

Question 38 🔥

Examine this PL/SQL function:What happens when the function is created with PLSQL_WARNINGS set to ENABLE: ALL?

Which database solution meets these requirements?

A. There are no compilation warnings or errors.

Highly voted

B. It fails compilation.

Highly voted

C. An information compilation warning is generated.

Highly voted

D. A performance compilation warning is generated.

Highly voted

E. A severe compilation warning is generated.

Highly voted

Discussion of the question

Question 39 🔥

In your schema, the DEPARTMENTS table contains the columns DEPARTMENT_ID and DEPARTMENT_NAME.You want to display the department name for existing department id 10.With SERVEROUTPUT enabled, which two blocks of code will give the required output?

Which database solution meets these requirements?

A. DECLARE TYPE dept_cur IS REF CURSOR; cv1 dept_cur; v_dept_name departments. department_name%TYPE; BEGIN OPEN cv1 FOR SELECT department_name FROM departments WHERE department_id=10; IF cv1 IS NOT NULL THEN FETCH cv1 INTO v_dept_name; DBMS_OUTPUT.PUT_LINE (v_dept_name); END IF CLOSE cv1; END;

Highly voted

B. DECLARE TYPE dept_cur IS REF CURSOR RETURN departments%ROWTYPE; cv1 dept_cur; v_dept_name departments.department_name%TYPE; BEGIN OPEN cv1 FOR SELECT * FROM departments WHERE department_id=10; FETCH cv1. department_name INTO v_dept_name; DBMS_OUTPUT.PUT_LINE (v_dept_name); CLOSE cv1; END;

Highly voted

C. DECLARE TYPE names_t IS TABLE OF SYS_REFCURSOR INDEX BY PLS_INTEGER; cv1 names_t; v_dept_name departments.department_name%TYPE; BEGIN OPEN cv1 FOR SELECT department_name FROM departments WHERE department_id=10; FETCH cv1 INTO v_dept_name; DBMS_OUTPUT.PUT_LINE (v_dept_name); CLOSE cv1; END;

Highly voted

D. DECLARE cv1 SYS_REFCURSOR; v_dept_name departments.department_name%TYPE; BEGIN EXECUTE IMMEDIATE BEGIN OPEN: cv1 FOR SELECT department_name FROM departmnets WHERE department_id=10: END; USING IN cv1; FETCH cv1 INTO v_dept_name; DBMS_OUTPUT.PUT_LINE (v_dept_name); CLOSE cv1;

Highly voted

Discussion of the question

Question 40 🔥

Which two statements are correct for collecting data about identifiers in PL/SQL source code?

Which database solution meets these requirements?

A. CREATE < function/Procedure> PLSCOPE_SETTINGS = ‘IDENTIFIERS: ALL’ AS …

Highly voted

B. ALTER SYSTEM SET PLSCOPE_SETTINGS = ‘IDENTIFIERS: NONE’

Highly voted

C. ALTER SESSION SET PLSCOPE_SETTINGS = ‘IDENTIFIERS: NONE’

Highly voted

D. ALTER SESSION SET PLSCOPE_SETTINGS = ‘IDENTIFIERS: ALL’

Highly voted

E. ALTER <function/Procedure> COMPILE PLSCOPE_SETTINGS = ‘IDENTIFIERS: ALL’

Highly voted

Discussion of the question

Question 41 🔥

Examine these statements:Which two corrections will allow this anonymous block to execute successfully? th

Which database solution meets these requirements?

A. Add wk# .NEXT; before the 7 line. rd

Highly voted

B. Add i PLS_INTEGER; before the 3 line.

Highly voted

C. Add wk#. EXTEND (1); before the 5 th line.

Highly voted

D. Change line #2 to wk# tp_test# := tp_test# (tp_rec# ());

Highly voted

E. Replace lines 5 and 6 with wk# (i) := tp_rec# (i, i);

Highly voted

Discussion of the question

Question 42 🔥

Select a valid reason for using VARRAYS.

Which database solution meets these requirements?

A. When the amount of data to be held in the collection is widely variable.

Highly voted

B. As a column in a table when you want to retrieve the collection data for certain rows by ranges of values.

Highly voted

C. When you want to delete elements from the middle of the collection.

Highly voted

D. As a column in a table when you want to store no more than 10 elements in each row’s collection.

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