最新的Oracle Application Express 18: Developing Web Applications - 1Z0-750免費考試真題
問題1
Bill has created a Maintain Customer form as shown in Exhibit 1.
Now he wants the Last Name item to be next to the First Name item as shown in Exhibit 2.
How can Bill achieve this?
Now he wants the Last Name item to be next to the First Name item as shown in Exhibit 2.
How can Bill achieve this?
正確答案: D
問題2
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?
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?
正確答案: C
問題3
Which is Hue about interactive reports?
正確答案: B
問題4
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?
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?
正確答案: A
問題5
Morgan has a report and form on the EMP table. He updated the form by adding a display-only item P5_LOC, and a change event dynamic action on P5_DEPTNO to populate the item using Set Value with this SQL:
select loc from dept
where deptno = :P5_DEPTNO;
When Morgan runs the page, he gets this error:
apex_error_code:
WWV_FLOW_DML.COLUMN_NOT_FOUND
original message: Column LOC not found in table EMP
What should Morgan do to prevent this error?
select loc from dept
where deptno = :P5_DEPTNO;
When Morgan runs the page, he gets this error:
apex_error_code:
WWV_FLOW_DML.COLUMN_NOT_FOUND
original message: Column LOC not found in table EMP
What should Morgan do to prevent this error?
正確答案: D
問題6
Bob' has created an interactive report on the EMP table. Oracle B1 Publisher has been configured as the report server in his environment. He has been asked to output a high-fidelity PDF report, which lists all employees.
How can Bob define the report?
How can Bob define the report?
正確答案: C
問題7
Mary wants to add feedback to an application. She uses the Create Page Wizard, selects Features, and then selects Feedback.
The wizard adds a feedback entry to the navigation bar and creates new pages. In her application, under Administration to review and disposition the feedback.
Which statement is true about feedback data?
The wizard adds a feedback entry to the navigation bar and creates new pages. In her application, under Administration to review and disposition the feedback.
Which statement is true about feedback data?
正確答案: C
問題8
Which two actions can be done by a Page Process of type Automatic Row Processing (DML)?
正確答案: B,C
