Online Access Free 1Z1-750 Exam Questions

Which two are true about using the Create Page Wizard to create a report with "Report with Form on Table"?

• A.The second page allows users to select the previous and next records.
• B.The wizard builds two pages, an interactive report page and a form page.
• C.The report and form must both be based on the same table or view.
• D.The wizard builds two p3ges using an interactive grid page and a form page.
• E.The first page allows users to update records.

You want to use the session state value of a page item in the select statement for a report on another page.
What is the correct way to reference the value of a page item in a SQL statement?

• A.APEX_UTIL.GET_SESSION_STATE(p_item => 'PAGE_ITEM)
• B.&PAGE_ITEM
• C.v('PAGE_ITEM')
• D.:PAGE_ITEM

Jim has developed a form page. When running the page, the data displayed Is not what he expected. Therefore, he wants to review the information in session state while debugging the form.
How can Jim accomplish this?

• A.Add a debug flag to the URL and rerun the page.
• B.View page source Information in the browser.
• C.Edit the page and update session state items to "Display Only."
• D.Click the Session button on the Developer toolbar.
• E.Click the View Debug button on the Developer toolbar.

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?

• A.In the "on change" dynamic action, set page 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 event scope to "dynamic."
• D.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.

Trillian wants to pass an item value, which includes a comma, such as the value Donuts, Coffee, In the URL when calling another page.
How can Trillian escape the Item value so that the comma is interpreted correctly?

• A.Donuts\,Coffee
• B./Donuts,Coffee/
• C."Donuts,Coffee"
• D.\Donuts,Coffee\