FREE Oracle APEX Developing Web Applications Questions and Answers

Question 1

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

Which step most accurately helps you achieve this?

Accepted Answer

Enter an alphanumeric alias in the Page Alias attribute.

Answer

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

Answer

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

Answer

Enter an alphanumeric name in the Page Title attribute.

Question 2

Which processing point is enabled for computations during page processing?

Accepted Answer

Processing

Answer

After Submit

Answer

After Processing

Answer

Validating

Question 3

In Application Express, how do you enable a database schema assigned to the current workspace so that it can be used to serve ORDS-based RESTful Services?

Accepted Answer

Navigate to the ORDS RESTful services section of SQL workshop, select the appropriate schema, and click the "Register Schema with ORDS" button.

Answer

Install the Sample REST Services packaged application.

Answer

Navigate to the Shared Components section and configure a REST Enabled SQL resource.

Answer

Navigate to workspace administration and in the Set Workspace Preferences section, set Enable RESTful Services to "Yes".

Question 4

Which is a predefined authentication scheme in Oracle Application Express?

Accepted Answer

HTTP Header Variable

Answer

Universal Authentication Framework (UAF)

Answer

SAML 2.0 Sign-On

Answer

OpenID Connect Sign-On

Answer

Client Certificate Authentication

Question 5

John has a form page with an email item and a status item. What must John do to ensure that the email item is populated before users can enter any value into the status item on the form page?

Accepted Answer

Validation on the email item

Answer

Dynamic action on the email item

Answer

Plug-in for the status item

Answer

Server-side condition on the status item

Question 6

David has created Page 10 as a form page using an Automatic Row Fetch process. A column named LOCATION has been added to the underlying table, and the form needs to include this new column. You decide to copy an existing page item :P10_DEPTNO and use that to represent the LOCATION column.

What is the minimum action required on the copied item to get the form working correctly?

Accepted Answer

Set the source database column to LOCATION.

Answer

Set value required to No.

Answer

Update the item name.

Answer

Change the source type to NULL.

Question 7

Which is true about a workspace in Oracle APEX?

Accepted Answer

It can be associated with multiple schemas in the same database.

Answer

It can be associated only with one schema.

Answer

It can be associated with multiple schemas from different databases.

Answer

It is not associated with any schemas.

Question 8

Where is the Oracle APEX session state stored between calls from the browser?

Accepted Answer

In the browser in the form of cookies

Answer

In the workspace schema

Answer

In the APEX metadata schema

Answer

Is passed back and forth between the database and browser with each call

Question 9

Rick has created an ""editable"" interactive grid on a table that includes four audit columns: CREATED, CREATED_BY, UPDATED, and UPDATED_BY.

The four audit columns are included in the report with the read-only type set to Always.

How can Rick update all four audit columns when a user inserts a row, and the UPDATED and UPDATED_BY columns when a user updates a row?

Accepted Answer

Using "Enable" Dynamic Actions

Answer

Using default values on the report columns

Answer

Using After Header Computations

Answer

Defining an After Submit process

Question 10

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?

Accepted Answer

Under Authentication, select Single Sign On (SSO).

Answer

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

Answer

Include the Access Control feature.

Answer

Update Advanced Settings to specify authentication.