1z0-148 Exam QuestionsBrowse all questions from this exam

1z0-148 Exam - Question 40


Examine these statements:

Which two corrections will allow this anonymous block to execute successfully? th

Show Answer
Correct Answer: BC

To ensure this code executes successfully, two main corrections are needed. Firstly, the nested table needs to be extended to accommodate new elements, which is achieved by adding wk#.EXTEND (1); before line 5. Without extending the table, any attempt to directly assign values would lead to errors. Secondly, the variable 'i' used in the loop should be properly declared. This can be done by adding i PLS_INTEGER; before line 3. Declaring 'i' ensures the scope and type of the iterator are correctly set, avoiding undeclared variable errors.

Discussion

2 comments
Sign in to comment
chrishillingerOptions: BC
Aug 24, 2022

BC is correct - nested table needs to be extended and var i needs to be declared

chrishillingerOptions: CE
Sep 7, 2022

Sorry, wrong answer, CE is actually correct