Oracle Application Express 18: Developing Web Applications (1Z0-750) Free Practice Test

Question 1

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

Correct Answer: A

Question 2

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?

A. Set Start New Row to "No" for the Last Name item.

B. Set Start New Row to "Yes" and New Column to "Yes" for the Last Name item.

C. Set Column to "2" for the Last Name Item.

D. Set Column Span to "2" for the First Name item.

Correct Answer: B

Question 3

ABC Company developed an employee directory by using an Interactive report.
The HP. manager (an end user) has customized his or her report to show only employees In the HR department, and wants to review the same report weekly.
How can the HR manager achieve this?

A. Download the report to a CSV or HTML file.

B. Save the report as a named report.

C. Add a control break on Department.

D. Add a filter to the report

E. Save the report as the primary report.

Correct Answer: E

Question 4

Sam is updating an application with a report (page 10) and form (page 11), where the form page has Page Mode "Normal." She wants to update the form page to a modal dialog, so it can be called from multiple report pages.
Sam has already changed Page Mode to "Modal Dialog." removed the breadcrumb region, added a button region to the dialog footer, and moved the buttons to the new region.
Whenever she opens the form page from a different report page (page is), it keeps returning to the original report page (Page 10) when she cancels or submits the form page.
Which three steps must Sam perform to get the modal page to always return to the report page from which it was called?

A. Create a Dynamic Action of type Cancel Dialog that fires when the CANCEL button is clicked.

B. Change the action on the CANCEL button to "Defined by Dynamic Action."

C. Add a Close Dialog process.

D. Update the branch to return to the correct calling page.

E. Create a hidden page item to hold the calling page and update the calls to the form page to populate the item.

F. Add a branch that redirects to an item holding the calling page.

G. Create a Dynamic Action of type Close Dialog that fires whenever the DELETE, SAVE, or CREATE button is pressed.

Correct Answer: A,B,C

Question 5

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

A. The wizard builds two pages, an interactive report page and a form page.

B. The report and form must both be based on the same table or view.

C. The first page allows users to update records.

D. The wizard builds two p3ges using an interactive grid page and a form page.

E. The second page allows users to select the previous and next records.

Correct Answer: B,C

Question 6

As a project manager, you use spreadsheets to keep track of multiple projects. As you took-responsibility of more projects, you become tired of managing them in spreadsheets.
You have collected all of your project data in one single spreadsheet. You also want to maintain the data in an Oracle Database table by using an Oracle Apex application.
Which two action can you take?

A. Use the Create Application Wizard and select ''From a Spreadsheet.''

B. Create a new table by using SQL Workshop > Object Browser .Create Table, and then use the Create Application Wizard to Create an application based on the new table.

C. Create an application by using the Create Application Wizard, and then add a table for the spreadsheet data.

D. Define a Data Loading page in the Create Application Wizard.

E. Use SQL Workshop >Utilities > Data Workshop to load the data into a new table, and then use the Create Application wizard to create an application on the new table.

Correct Answer: C,D

Question 7

Brian created a page with multiple regions. He now wants to include a list of links to selectively display each region.

How can Brian achieve this?

A. Create a parent region called REGIONS. For each region, update the Parent Region attribute to REGIONS.

B. Create a region of type Region Display Selector, and ensure that each region has Region Display Selector set to Yes.''

C. Define static IDs for each region, Create a region called REGION of Type Static Content with named anchors to other regions.

D. Create a list in Shared Components containing each region, Create a region of type List and associate the list created.

Correct Answer: B

Question 8

Which three item types support defining a list of values?

A. Shuttle

B. Color Picker

C. Text Field with autocomplete

D. List Manager

E. Switch

F. file Browse

Correct Answer: B,C,D

Welcome to TestSimulate

Oracle Application Express 18: Developing Web Applications (1Z0-750) Free Practice Test