Oracle Exam 1Z0-750 Topic 8 Question 24 Discussion

Actual exam question for Oracle's 1Z0-750 exam

Question #: 24
Topic #: 8

Maurice wants to have a report on employees, which shows only employees tor 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?

AAdd 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.

BOn the report_1 region, set page Items to submit to p6_deptno.

CIn the 'on change' dynamic action, set page Items to submit to p6_DEPTNO.

DIn the 'on change' dynamic action, set event scope to 'dynamic.'

Show Suggested Answer

Suggested Answer: C

by France at May 04, 2022, 09:17 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!