Which Is a predefined authentication scheme in Oracle Application Express?

• A.HTTP Header Variable
• B.SAML 2.0 Sign-On
• C.Client Certificate Authentication
• D.OpenID Connect Sign-On
• E.Universal Authentication Framework (UAF)

Comment: *

Name: *

Email: *

Verification: *

Sam is updating an application with a report (page 10) and form (page 11), where the form page has Page Mode "Normal." She wants to update the form page to a modal dialog, so it can be called from multiple report pages.
Sam has already changed Page Mode to "Modal Dialog." removed the breadcrumb region, added a button region to the dialog footer, and moved the buttons to the new region.
Whenever she opens the form page from a different report page (page is), it keeps returning to the original report page (Page 10) when she cancels or submits the form page.
Which three steps must Sam perform to get the modal page to always return to the report page from which it was called?

• A.Create a hidden page item to hold the calling page and update the calls to the form page to populate the item.
• B.Create a Dynamic Action of type Cancel Dialog that fires when the CANCEL button is clicked.
• C.Create a Dynamic Action of type Close Dialog that fires whenever the DELETE, SAVE, or CREATE button is pressed.
• D.Change the action on the CANCEL button to "Defined by Dynamic Action."
• E.Add a branch that redirects to an item holding the calling page.
• F.Add a Close Dialog process.
• G.Update the branch to return to the correct calling page.

Comment: *

Name: *

Email: *

Verification: *

Kyle is developing a page with an interactive report, called Employees, using this query:
SELECT EMPNO, ENAME, JOB, DEPTNO FROM EMP WHERE DEPTNO = nvl(:P3_DEPTNO, DEPTNO) On the page, Kyle adds a select list, called P3_DEPTNO, using this query:
SELECT dname, deptno FROM dept;
He creates a dynamic action on change of P3_DEPTNO, with a true action of "Refresh" against the Employees region.
Kyle then runs the page and selects ACCOUNTING in the P3_DEPTNO item. However, the report still shows employees from all departments.
What must Kyle do to correctly display only employees from the department selected?

• A.Set a column on the DEPTNO column.
• B.Add an additional true action of Set Value by using Static Assignment in Dynamic Action.
• C.Add a computation set to p3_ DEPTNO
• D.Set "Page Items to Submit" to p3_deptho in the report.

Comment: *

Name: *

Email: *

Verification: *

Robin develops many apps In her workspace that use various APEX plug ins. Some apps use the same plug-In as other apps. When a newt* version of a plug-in is available, Robin has to update the plug-in in multiple apps.
How can Robin upgrade a plug-In once and have all other apps that use the same plug-in get updated at the same time?

• A.Create a "Plug-ins Master" app where she stores all plug-ins and then subscribes the plug-Ins in all of her other apps to the plug-Ins In the "Plug-has Master" app.
• B.Write a PL/SQL package that she can reuse to update the plug-In definitions in each application.
• C.Update one of the plug-ins, and then click Push Update to update the other apps.
• D.Run a SQL command to update the plug-In definition in each application.

Comment: *

Name: *

Email: *

Verification: *

What is the least error-prone way to split a long list into two lists?

• A.Create an empty second list, copy selected list items from the first list to the second list, and then remove the copied list items from the first list.
• B.Create two new lists, copy list items from the initial list to the first list, copy the remaining list items from the initial list to the second list, and then delete the initial list.
• C.Create an empty second list, manually re-create the needed list entries, and then remove the matching list entries from the first list.
• D.Copy the entire list, grid edit the copied list and remove entries that are not needed, and then grid edit the first list and remove the entries that are now in the second list.

Comment: *

Name: *

Email: *

Verification: *