Q52. Which authentication scheme type supports authentication with social networks and enterprise identity providers that support OpenID Connect or OAuth2 standards?

Q53. An Employees App includes a form to enter and update employee details.
Examine this Exhibit.
Now you must extend the functionality of this form so that:
* If you select ‘SALESMAN’ from the select list for Job page item (P2_JOB), both the ‘Hire date’ (P2_HIREDATE) and ‘Commission’ (P2_COMM) page items and their associated labels are displayed
* If you select any other value from the select list for Job page item (P2_JOB), both the ‘Hire date’ (P2_HIREDATE) and ‘Commission’ (P2_COMM) page items and their associated labels are hidden Which two steps must be performed?

Q54. Using Data Workshop, you can perform which three tasks:

Q55. Plug-ins can be used declaratively in which of the following components in APEX?

Q56. You must reference certain data from a dragged event under the Drag and Drop PL/SQL Code attribute of the Calendar component.
Examine this list:
1. The ID
2. The NEW_START_DATE
3. The NEW END DATE
How can these be referenced?

Q57. What are the three features of a calendar in APEX?

Q58. Which statement is true about using the App Gallery?

Q59. The Movies faceted search report is filtered only when the Apply button for a selected facet is clicked. What must be done in the Page Designer so that report filtering is automatically executed when any facet value changes?

Q60. Which two statements are true about a Progressive Web Application (PWA)?

Q61. Choose the three different ways in which you can add a checkbox to a page.

Q62. Choose the two options provided in a Column Heading menu of an Interactive Report.

Q63. Examine this code used in Quick SQL:
students
name
roll no num
Quick SQL is using default settings.
Which table creation script or other output is produced?

Q64. Which three are the main components of APEX workspace homepage?

Q65. Which statement is true about Theme Styles in Oracle APEX?

Q66. 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 beingused 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?

Q67. Which two are prerequisites to use the REST-enabled SQL feature in Oracle APEX?

Q68. Consider a page in an APEX app where the Departments names with location is displayed on the left. Selecting a Department on the left will render details of the employees corresponding to that department on the right. Which kind of report/form is this?

Q69. There is a page with an interactive grid region based on this statement: SELECT EMPNO, ENAME, COMM from EMP; In the Interactive Grid attributes, under the Edit group, the Enabled switch is turned Off. Which are two of the actions that you must perform to make an employee’s commission editable in the grid?

Q70. Examine this code entered in Quick SQL:
emp_salary
name vc255
salary num
commission yn/check TRUE, FALSE
Which statement is true about the commission yn column?

Q71. When a table or a SQL query returns many rows, an Interactive Grid is best displayed to the user with pagination. The two types of pagination available are:

Q72. Which two statements are true about Maps in Oracle APEX?

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

Q74. What are Task definitions that exist on the application level inthe Shared Components section made up of?