create or replace procedure wording is
type definition is record(
word varchar2(20),
meaning varchar2(200));
lexicon definition;
procedure add_entry (word_list in out definition) is
begin
word_list.word:='aardvark';
lexicon.word:='aardwolf';
end add_entry;
begin
add_entry(lexicon);
dbms_output.put_line(word_list.word);
dbms_output.put_line(lexicon.word);
end wording;
/
Yes, A is correct here.
Tried and tested.
Errors: PROCEDURE WORDING
Line/Col: 13/1 PL/SQL: Statement ignored
Line/Col: 13/22 PLS-00201: identifier 'WORD_LIST.WORD' must be declared
Yes, A is the correct answer.
Explanation - the statement - DBMS_OUTPUT.PUT_LINE(word_list.word) will fail as wrod_list is a formal parameter which is visible only to the PROCEDURE add_entry
more exactly word_list is a pararmeter not a variable
upvoted 1 times
...
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.
Naveen_2022
2 years, 10 months agoNaveen_2022
2 years, 10 months agoAditya
3 years, 1 month agoAnubhav244
4 years, 4 months agonadzeya_bdc
4 years, 10 months agoCosminCof
5 years, 3 months ago