1. In which two cases can you use classic reports?

•      to provide basic sort and search options
•      to provide the download option

2. Which three components can be created on Global pages?

•      Dynamic Actions / Regions / Buttons

3. Which two callback procedures or functions apply to APEX plug-ins?

•      AJAX, Render

4. In the Create Application wizard, you click the Add Page button to create a Form page and select the Include Report check box. Which report is generated by default?

•   Interactive Report

5. Which three are features of the Data Load utility in Data Workshop?

• Choose the character set in which the text file is encoded.
• Load XML, JSON, XLSX, or delimited-field text files
• Omit (skip) columns when loading.

8. Which statement is true about creating master detail forms?

• Wizard-generated master detail forms also automatically create validations for some columns.

9. You have created a master detail page on the PROJECTS table by using the Create Page wizard. Only application administrators are to be permitted to access the master detail page. What must you do to meet this requirement?

• Set the page authorization scheme of Administration Rights.

10. Which two statements are true about an end user customizing interactive reports?

• A flashback query can be executed.
• Mathematical computations can be added to columns.

11. Which two statements are true about applications for mobile devices?

• Mobile apps developed with APEX must have a connection to communicate with an Oracle Database.
• By default, Column Toggle Reports are created with all the columns set to the same priority.

12. You are required to have a Cards look and feel for a classic report. Which action does this?

• Under Attributes, select the Cards template.

13. You must facilitate PL/SQL server-side access to first-time rendered page item values after the page loads, without leaving the page. Which two options will independently satisfy this need?

• Page Render process 
• Dynamic Actions

14. You are required to 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 must you use?

• Stacked

15. Which statement is true about the Link Column attribute of an interactive report?

• The Authorization Scheme can be specified for Link Column. (*)

17. You are required to create and run a query using Query Builder. Which three attributes can you add on the Conditions tab?

• SORT TYPE / SORT ORDER / GROUP BY

18. Which two statements are 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 the dialog page type.
• Feature pages can be added only once per application.

19. You are required to create a table that permits all columns in every row to be unloaded to a structured text file using the Data Workshop utility. Which two data types must be avoided?

• blob/bfile

20. Which three statements are true about loading data from the Create Application From File wizard?

• A sample data set from the sample list can be uploaded.
• Column delimited data can be pasted and loaded.
• CSV, XLSX, XML, TXT, or JSON files can be uploaded.

21. An application was created by using the Create Application wizard, which enabled the Access Control feature. Which two components are created when the Access Control feature is enabled?

• the configuration page to the set access level of authenticated users
• the administrative page region with links to the Access Control feature