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

B. v(`PAGE_ITEM')

C. APEX_UTIL.GET_SESSION_STATE(p_item => `PAGE_ITEM)

D. :PAGE_ITEM

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 "Yes" and New Column to "Yes" for the Last Name item.

B. Set Start New Row to "No" 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.

ABC Company developed an employee directly by using an interactive report.

The HR 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. Add a control break on Department

B. Add a filter to the report

C. Save the report as a named report

D. Save the report as the primary report

E. Download the report to a CSV or HTML file

Taylor has created a report and form on the STATUS table.

She wants only application administrators to be able to access the report and form.

What must she do to achieve this?

A. Select authentication of Administrator Only

B. Add a before header validation

C. Add a before header process

D. Select authorization scheme of Administration Rights

You want to refer to a page by a name (or alias) instead of page number in the application URL.

Which step most accurately helps you achieve this?

A. Go to Application Properties and set "Refer to page by name (or alias)" to "Yes".

B. Set the Built-in substitution string PAGE_ALIAS on page load.

C. Enter an alphanumeric name in the Page Title attribute.

D. Enter an alphanumeric alias in the Page Alias attribute.

Which processing point is enabled for computations during page processing?

A. Processing

B. After Submit

C. After Processing

D. Validating

Which is a predefined authentication scheme in Oracle Application Express?

A. Universal Authentication Framework (UAF)

B. HTTP Header Variable

C. SAML 2.0 Sign-On

D. OpenID Connect Sign-On

E. Client Certificate Authentication

Jane is creating a new application. Users of the application will use SSO to authenticate. SSO has been defined for the instance.

Which step should Jane perform in the Create Application Wizard?

A. Under Authentication, select Single Sign On (SSO).

B. Include a Sign-In page in the list of pages.

C. Include the Access Control feature.

D. Update Advanced Settings to specify authentication.

You created an application where the home page looks like:

You now want to change the page to look like:

What do you need to do to change the appearance of the page?

A. Update the region Type to "List View"

B. Update the list Template to "Media List"

C. Update the list Template Options > Style to "Basic"

D. Update the region Template Options > Icons to "No Icons"

Which is true about interactive reports?

A. Interactive reports can be either read-only or editable.

B. All columns defined in the report query must be shown.

C. You can define only one interactive report on a page.

D. An interactive report can be based on a PL/SQL function body returning a SQL query.