declare
v_wage NUMBER NOT NULL := 1000;
v_total_wage v_wage%TYPE; -- cant use without value initialization
work_complete CONSTANT BOOLEAN := TRUE;
all_work_complete work_complete%TYPE;
begin
null;
end;
Only B is correct on version 18. Line 3 does not compile due to error "PLS-00218: a variable declared NOT NULL must have an initialization assignment".
Other lines compiles successfully, value of 'all_work_complete' is null.
Answer is correct (B and D)
Line 3: Variable v_total_wages will have same Data type and NOT NULL constraint than v_wage. However no default value is assigned to it, so compiler will throw an error in this line.
Line 5: %Type can be used with columns and variables (not constants).
This section is not available anymore. Please use the main Exam Page.1z0-144 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.
trex_fcs
2 years, 2 months agoBM2000
2 years, 3 months agoPaps23
2 years, 7 months agoneziniukas
3 years, 11 months agoLimak665
4 years agoluiseng
4 years, 10 months agonadzeya_bdc
4 years, 10 months agoromsav
5 years agochamisso
5 years, 4 months agoCosminCof
5 years, 3 months ago