Oracle APEX Quiz

Using the App Builder component, you can perform which three tasks?

• Create a new App

• Edit pages in the page designer

• Run SQL scripts and commands

• Install a sample App

Which is a valid Page Process type?

• Set Value

• Execute JavaScript Code

• Send E-Mail

Which two statements are true about Faceted Search pages?

• A facet's chart can be seen only in a nonmodal dialog.

• Facets map to specific database columns.

• Multiple charts are not visible in the same region.

• Faceted Search supports the ability to filter columns storing multiple values as one string.

You must use a Static Content region type to display messages about the employees of the month. Employee names are stored in the P1 ENAME page item. Which text, when placed in Source, will display the message correctly?

• Join me in congratulating v('P1_ENAME') as the new employee of the month!

• Join me in congratulating :P1_ENAME as the new employee of the month!

• Join me in congratulating &P1_ENAME, as the new employee of the month!

In a faceted search page, facets can be displayed as different UI types. Which two facet item types are supported in the faceted search region?

• Checkbox Group

• Popup LOV

• Range

• Date Picker

Choose the three correct options in the given friendly URL syntax:

• mycompany is the path-prefix which is by default the workspace name

• update-employees is the PL/SQL procedure to update the employee details.

• 13766599855150 is the session I A new ID is generated for each session.

Which statement is true about creating and using pages in an APEX Application?

• Modal and nonmodal dialog pages are supported only if the current application theme contains at least one page template of type Dialog Page.

• A user cannot interact with a nonmodal dialog and content on the page

• You can copy a page only from the current application

Which statement is true about using SQL Commands?

• You can search and filter database objects.

• You can design and prototype data models using a markdown-like shorthand syntax.

• In SQL Commands, you can view queries saved in Query Builder.

• You can unload data from the database.

You can create a report in which of the three following methods?

• Create a report as a new page in an application

• Create a report from Object Browser

• Create a report when you create a new database application

• Create a report region on a page in an application

Which two statements are true about customizing an interactive report by an end user?

• Standard Oracle functions cannot be added to columns.

• A flashback query can be executed.

• Mathematical computations can be added to columns.

• From the Actions menu, multiple charts can be created.