Exam 1z0-149 All QuestionsBrowse all questions from this exam
Question 52

Examine these statements which execute successfully:

Which anonymous block executes successfully?

    Correct Answer: B

    The table definition includes an invisible column 'c'. When a column is invisible, it cannot be referenced directly in SQL queries or PL/SQL blocks unless it's explicitly referred. The only anonymous block that does not attempt to reference the invisible column is the one that will execute successfully. Hence, it is B. The block in option B processes only the visible columns 'a' and 'b', making it the correct answer.

Discussion
thranduylOption: B

Cant reference a invisible column