APEX CERT 2023

You require a page computation to execute before the page is rendered. Which two computation points (Execution Point) will do this?

• Before Header
• After Submit
• After Header
• After Page Processing

You must create a single master detail page where users can select a row in the master grid to update the detail grids. Users must also interact with the master or the detail without leaving the page. Which type of master detail implementation should you use?

• Side by Side
• Drill Down
• Stacked

Which two statements are true about REST Data Source Synchronization?

• To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema.
• If the local table is not in sync with the Data Profile, Data Synchronization continues to work for columns present in both the table and the Data Profile.
• If the local table is not in sync with the Data Profile, Data Synchronization doesn't work.
• You cannot trigger Data Synchronization on a regular schedule using a scheduler job.
• The local table can only be used for Data Synchronization but you cannot add indexes or change physical properties

You created a custom theme for an application. Examine these requirements: 1. The theme must be utilized by another application in the same workspace. 2. The master theme may still require changes. Which solution guarantees that any changes to the master theme are reflected in the copied theme?

• Refreshing the templates
• Verifying the theme subscription
• Subscribing the copied theme to the master theme and refreshing the theme
• Copying the changes made in the master theme to the copied theme

Which two statements are true about the usage of a Remote Server in the context of REST Data Sources?

• The remote server determines the base URL of the REST Data Source.
• The remote server should mandatorily be an APEX instance.
• Multiple REST Data Sources can reference a single remote server.
• A single REST Data Source can use multiple remote servers.

Which statement is true about Theme Styles in Oracle APEX?

• Theme Styles in Oracle APEX determine the layout and structure of a webpage.
• When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment.
• You can only enable the Is Current attribute when the Theme Style has the Read Only attribute disabled.

You have defined a REST Data Source with ORDS as the REST Data Source Type. This REST Data Source is based on an AutoREST-enabled EMP table on a remote Oracle Database. This REST Data Source is being used as source for an editable interactive grid. When a user updates an employee record in this interactive grid, which operation (HTTP Method) defined in the REST Data Source is utilized to update a record in the EMP table on the remote Oracle Database?

• GET
• POST
• PUT

In your existing Employee Benefits application, you want yo determine the most active users, the most used pages, and the performance of pages to better understand how your application is being utilized and areas for improvement. How can this be achieved?

• On the Application Home page, click Create Page. In the Page Wizard, select the Activity Reporting feature type.
• On the Application Home page, click Create Page. In the Page Wizard, select the Email Reporting feature type.
• On the Application Home page, from the task list, click the Add Feature Page button. Then select the feedback feature type.
• On the Application Home page, click Create Page. In the Page Wizard, select the Master Detail type.

Which statement is true about creating and using a faceted search page?

• If you create a faceted search page on a view or a SQL query, the facets are auto-discovered.
• If you create a faceted search page based on a table, the facets are not auto-discovered.
• The Search Results region can be displayed as a Classic Report or Cards.
• The Search Results region can be displayed as an interactive report.

Which two statements are true about creating and using an interactive report?

• You can specify an Authorization Scheme at the column level.
• You cannot include Form Page when creating an interactive report page using the Create Page Wizard.
• You cannot customize the Search Button Label.
• You cannot restrict users from saving private reports by using the Authorization Schema