1Z0-750 試験問題を無料オンラインアクセス
| 試験コード: | 1Z0-750 |
| 試験名称: | Oracle Application Express 18: Developing Web Applications |
| 認定資格: | Oracle |
| 無料問題数: | 75 |
| 更新日: | 2026-05-31 |
Michael has developed an app for tracking product defects. His navigation menu lists each product. He has defined application items and computations to hold the number of defects for each product.
For example, for Hedgers, he has defined the application item HEDGER_DEFECT.
How can Michael add the number of open defects in the navigation menu entries?
Robert has a form page, Page 5, on the EMP table. He has defined two validations.
Validation 1 checks that P5_MGR is not null.
Validation 2 checks that the employee selected in P5_MGR has a job of PRESIDENT or MANAGER.
How can Robert prevent the employee job validation (Validation 2) from firing when the P5_MGR is NOT NULL validation (Validation 1) has failed?
Susan created Page 10 as an interactive report, called Departments, on the DEPT table. She also created Page
11 as an interactive report on the EMP table, called Employees.
Susan would like to add a link in the Departments report (Page 10) that redirects to the Employees report (Page 11) and displays only employees for the selected department.
How would Susan set items in the link builder on Page 10 to correctly call the report on Page 11?
Kyle is developing a page with an interactive report, called Employees, using this query:
SELECT EMPNO, ENAME, JOB, DEPTNO FROM EMP WHERE DEPTNO = nvl(:P3_DEPTNO, DEPTNO) On the page, Kyle adds a select list, called P3_DEPTNO, using this query:
SELECT dname, deptno FROM dept;
He creates a dynamic action on change of P3_DEPTNO, with a true action of "Refresh" against the Employees region.
Kyle then runs the page and selects ACCOUNTING in the P3_DEPTNO item. However, the report still shows employees from all departments.
What must Kyle do to correctly display only employees from the department selected?