Oracle
1Z0-146 · Question #5
1Z0-146 Question #5: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #5. The question stem and answer options stay visible for context.
Question
Examine the structure of the PRODUCTS table. Name Null? Type --------------- ------------ --------------- PRODUCT_ID NOT NULL NUMBER(6) PRODUCT_NAME VARCHAR2(50) CATEGORY_ID NUMBER(2) SUPPLIER_ID NUMBER(6) LIST_PRICE NUMBER(8,2) View the Exhibit and examine the PL/SQL block. On execution, the PL/SQL block generates the following error: ORA-01001: invalid cursor What could be the reason?
Exhibit
Options
- ABoth the cursor variable arguments should have been passed in IN mode.
- BThe contents of one cursor variable cannot be assigned to another cursor variable using the :=
- CThe CLOSE statement closes both the cursor variables, therefore the last FETCH statement
- DThe name of the cursor variables defined and the name of the cursor variables passed as arguments
Unlock 1Z0-146 to see the answer
You've previewed enough free 1Z0-146 questions. Unlock 1Z0-146 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.