ExamQuestions.com

Register
Login
Oracle Application Express 18: Developing Web Applications Exam Questions

Oracle

Oracle Application Express 18: Developing Web Applications

33 / 36

Question 33:

Maurice wants to have a report on employees, which shows only employees or the department selected in a select list item. He has created a report, called REPORT_1, based on the EMP table. Above the region, he has defined a select list called P6_DEPTNO. Maurice has added the correct Where clause for REPORT_1 and defined an "on change" dynamic action on P6_DEPTNO to refresh the REPORT_1 region. When he runs the page, no data is displayed, irrespective of the department selected. What must Maurice do to get the page to work correctly? 

Answer options:

A. Add a set value action, before the refresh action, of type PL/SQL Expression with code of :P6_DEPTNO and items to submit to P6_DEPTNO.
B. On the REPORT_1 region, set page items to submit to P6_DEPTNO.
C. In the "on change" dynamic action, set page items to submit to P6_DEPTNO.
D. In the "on change" dynamic action, set event scope to "dynamic".