Oracle
1Z0-141 · Question #108
1Z0-141 Question #108: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-141 to reveal the answer and full explanation for question #108. The question stem and answer options stay visible for context.
Question
View the Exhibit. You are coding a When-New-Form-Instance trigger to populate a hierarchical tree item called Emp_Tree that should initially appear as shown in the exhibit. Mr. King, the president of the company, is the only employee who does not have a manager. In the trigger, you declare a variable called rg_emps that is of the RECORDGROUP data type. You will use this record group to populate the tree. You use the following code to create the record group: rg_emps := Create_Group_From_Query('rg_emps', 'select 1, level, last_name, NULL, to_char(employee_id) from employees connect by prior employee_id = manager_id start with manager_id is null'); You then programmatically populate the record group, and then populate the tree with the record group. You run the form to test it. Will the tree initially appear as shown? If not, why not?
Options
- AYes, the tree will appear as shown.
- BNo. The first element selected in the select statement should be 4 because you want four
- CNo. You should eliminate the last element selected in the select statement, because you do
- DNo. The "connect by" statement should be "connect by prior manager_id = employee_id".
Unlock 1Z0-141 to see the answer
You've previewed enough free 1Z0-141 questions. Unlock 1Z0-141 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.