Online Access Free 1Z0-750 Exam Questions

Fred created a parent/child relationship between the Employees and Departments.

Fred wants to hide the Departments region.
What should Fred do to achieve this?

• A.Set the Parent Region to "Null."
• B.Delete the region.
• C.Set the Read Only condition to "Always."
• D.Set the Server-side Condition to "Never."
• E.Set the Read Only condition to "Never."

Jules is trying to implement Session State Protection to increase the security of rules' application. On which three components can Jules configure Session State Protection in Oracle Application Express?

• A.pages
• B.buttons
• C.page items
• D.application Items
• E.page regions
• F.page processes

RICK''has created an ''editable interactive grid on a table that include four audit columns: CREATED, CREATED_BY UPDATED, and UPDATED_By.
The four audit columns are included in the report with read-only type set to Always.
How can Rick update all four audit column when a user inserts a row, and the UPDATED_BY column when a user updates a row?

• A.using default values on the report columns
• B.using After Header Computations
• C.using "Enable" Dynamic Actions
• D.defining an After Submit process

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.Update one of the plug-ins, and then click Push Update to update the other apps.
• B.Run a SQL command to update the plug-In definition in each application.
• C.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.
• D.Write a PL/SQL package that she can reuse to update the plug-In definitions in each application.

Maurice wants to have a report on employees, which shows only employees tor the department selected in a select list Item.
He has created a report, called report_1, based on the EMP table. Above the region, he has defined a select list called p6_deptno.
Maurice has added the correct Where clause for report_1 and defined an "on change" dynamic action on p6_deptno to refresh the report_1 region.
When he runs the page, no data is displayed. Irrespective of the department selected.
What must Maurice do to get the page to work correctly?

• A.In the "on change" dynamic action, set page Items to submit to p6_DEPTNO.
• B.On the report_1 region, set page Items to submit to p6_deptno.
• C.In the "on change" dynamic action, set event scope to "dynamic."
• D.Add a set value action, before the refresh action, of type PL/SQL Expression with code of
  :P6_DEPTNO and items to submit to P6_DEPTNO.