1Z0-750 Online Practice Questions and Answers

Kim has defined a validation of "Item is NOT zero" on P5_SAL. When she runs the page, the error is displayed in the notification, but does not highlight the item or display the error below the item. Kim changes Display Location to "Inline with Field and Notification". However, the validation error still does not display under the item.

What must Kim do to ensure that the validation error appears correctly under the item and also in the notification?

A. Add JavaScript to the item to display on error

B. Set Display Location to "Inline with Field"

C. Set Value Required to Yes on P5_SAL

D. Set Validation Associated Item to P5_SAL

Susan created Page 10 as an interactive report, called Departments, on the DEPT table. She also created Page 11 as an interactive report on the EMP table, called Employees.

Susan would like to add a link in the Departments report (Page 10) that redirects to the Employees report (Page 11) and displays only employees for the selected department.

How would Susan set items in the link builder on Page 10 to correctly call the report on Page 11?

A. Set item name IR_DEPTNO and value to #DEPTNO#

B. Set item name to :P11_DEPTNO and value to :P10_DEPTNO

C. Set item name to :P11_DEPTNO and value to #DEPTNO#

D. Set item name to :P10_DEPTNO and value to #DEPTNO#

When testing the Data Load Wizard pages, you realize that you forgot to add a transformation rule. What should you do to add the transformation rule?

A. Update the existing generated pages.

B. Update Data Load Definition.

C. Delete Data Load Definition and re-create it manually.

D. Use the Create Page Wizard to re-create the pages.

Which best describes how Session State Protection works?

A. saves sensitive data in Oracle Application Express session state tables in encrypted form, stopping users from tampering with the data

B. adds checksums to Page Access Protection attributes and Session State Protection item attributes to prevent alteration of session state

C. saves data in Oracle Application Express session state tables in encrypted form and uses the Page Access Protection attributes and the Session State Protection item attributes with checksums to prevent alteration of session state

D. encrypts the values supplied in the URL to prevent reading of the values

Which three sources can be used for a classic report? (Choose three.)

A. RESTful Web Source module

B. CSV (comma separated values) file

C. PL/SQL function returning a SQL query

D. PL/SQL function returning a single value variable

E. SQL Query

F. PL/SQL stored procedure with the OUT parameter

G. Excel spreadsheet

Robin develops many apps in his workspace that use various APEX plug-ins. Some apps use the same plug-in as other apps. When a newer 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. Run a SQL command to update the plug-in definition in each application.

B. Write a PL/SQL package that he 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. Create a "Plug-ins Master" app where he stores all plug-ins and then subscribes the plug-ins in all of his other apps to the plug-ins in the "Plug-ins Master" app.

Which four Oracle APEX region types can be created on top of a Web Source module? (Choose four.)

A. Classic Report

B. Interactive Report

C. Chart

D. Static Content

E. List View

F. Interactive Grid (non-editable)

G. List

H. Interactive Grid

I. Tree

J. PL/SQL Dynamic Content

You can control when an authorization scheme is validated by using the Evaluation Point. Select three valid Evaluation Points. (Choose three.)

A. once per session

B. once per region

C. once per page view

D. once per day

E. always (no caching)

F. once per user