Examine this table in the SH schema: Now, examine this code: Which two changes are required to ensure that PDT_REPORT executes successfully? (Choose two.)
A.
In line 1, change IN OUT mode to IN mode.
B.
In line 2, change IN OUT mode to IN mode.
C.
In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.
D.
In line 1, add the default parameter DEFAULT 2000.
E.
In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.
F.
In line 2, add the default parameter DEFAULT 2000.
Only IN type parameter can take default value, parameterized cursors only can execute with IN parameters.
Answer B+F its correct
--correct
create or replace procedure proc1 (p1 in number default null) is
cursor c_emp(p_employee_id number default 20000)
is
select * from employees where employee_id = p_employee_id;
begin
dbms_output.put_line('error');
open c_emp(100);
end;
I mean as the other guy says this works without changing anything
But since you're not modifying the p_pdt_price just keep it as in. And also not like you're gonna change the cursor parameter so also keep it as in
This section is not available anymore. Please use the main Exam Page.1z0-149 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
abdullah_barham
Highly Voted 1 year, 9 months agoerykjuarez
Most Recent 10 months agothranduyl
1 year agoegznrd
1 year, 3 months agoTheOracleWasTaken
1 year, 3 months agoGoto10
1 year, 6 months agosorincirnu
1 year, 7 months ago