FREE Oracle APEX Developer and Application Questions and Answers

Question 1

The Oracle APEX was formerly known as:

Accepted Answer

HTML DB

Answer

Oracle APX

Answer

Oracle DB

Answer

Oracle Tool

Question 2

The Oracle APEX supports these operating systems except:

Accepted Answer

Chrome OS

Answer

Windows

Answer

Linux

Answer

IBM AIX

Question 3

Which of these is the developer of Oracle APEX?

Accepted Answer

Oracle Corporation

Answer

Oracle Team

Answer

Oracle Inc

Answer

Oracle Company

Question 4

Concerning the Oracle APEX names, which of these is odd?

Accepted Answer

APEX Tool

Answer

Flows

Answer

Oracle Platform

Answer

Project Marvel

Question 5

The following are classes of vulnerability that affect APEX applications except:

Accepted Answer

Automated control

Answer

SQL injection

Answer

Access control

Answer

Cross-site scripting

Question 6

Who created APEX?

Accepted Answer

Mike Hichida

Answer

Andrew Flow

Answer

Mike Robbin

Answer

Lord Thomas

Question 7

The following are third-party libraries with which APEX comes standard with except:

Accepted Answer

JQuery System

Answer

JQuery Mobile

Answer

CKEditor

Answer

AnyChart

Question 8

Michael has developed an app for tracking product defects. His navigation menu lists each product. He has defined application items and computations to hold the number of defects for each product. For example, for Hedgers, he has defined the application item HEDGER_DEFECTS.

How can Michael add the number of open defects in the navigation menu entries?

Accepted Answer

Update the List Entry Label for Hedgers to Hedgers &HEDGER_DEFECTS., and similarly for other products.

Answer

Update the Navigation Menu template to Include Count.

Answer

Update Template Options and set Display Count to True.

Answer

Add &HEDGER_DEFECTS. to User Defined Attribute 01 in the navigation menu for Hedgers, and similarly for other products.

Question 9

John is evaluating an old APEX application that has over 20 tabular forms. He wants to update the application and replace all of the tabular forms with interactive grids.

What is the fastest way for John to replace the old reports?

Accepted Answer

Go to each report and change the type from Tabular Form to Interactive Grid.

Answer

Go to each page with a tabular form, copy the SQL Source from the Tabular Form region, and use it to create a new interactive grid.

Answer

Use the Create Page Wizard to create new pages with interactive grids, and then delete the old pages with tabular forms.

Answer

Use the Upgrade Application utility and select the candidate objects listed for "Upgrade Tabular Form to Interactive Grid", select all, and then click Upgrade.

Question 10

Which statement is true about creating and using a report with form?

Accepted Answer

Both the Create Application Wizard and Create Page Wizard support the creation of an interactive report or classic report and form combination.

Answer

The Create Page Wizard doesn't support the creation of a classic report and formcombination

Answer

The Create Application Wizard doesn't support the creation of an interactive report and form combination.

Answer

In the Create Application Wizard, you can select a data source (that is, Local Database, REST Enabled SQL Service, or REST Data Source).