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

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.

In Application Express, how do you enable a database schema assigned to the current workspace so that it can be used to serve ORDS-based RESTful Services?

A. Install the Sample REST Services packaged application.

B. Navigate to the Shared Components section and configure a REST Enabled SQL resource.

C. Navigate to the ORDS RESTful services section of SQL workshop, select the appropriate schema, and click the "Register Schema with ORDS" button.

D. Navigate to workspace administration and in the Set Workspace Preferences section, set Enable RESTful Services to "Yes".

John has a form page with an email item and a status item.

What must John do to ensure that the email item is populated before users can enter any value into the status item on the form page?

A. dynamic action on the email item

B. validation on the email item

C. plug-in for the status item

D. server-side condition on the status item

Rick has created an "editable" interactive grid on a table that includes 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 columns when a user inserts a row, and the UPDATED and UPDATED_BY columns when a user updates a row?

A. using "Enable" Dynamic Actions

B. using default values on the report columns

C. using After Header Computations

D. defining an After Submit process

Jane is creating a new application. Users of the application will use SSO to authenticate. SSO has been defined for the instance.

Which step should Jane perform in the Create Application Wizard?

A. Under Authentication, select Single Sign On (SSO).

B. Include a Sign-In page in the list of pages.

C. Include the Access Control feature.

D. Update Advanced Settings to specify authentication.

Which three actions can be performed in Object Browser? (Choose three.)

A. Enable and disable constraints.

B. Write a SQL statement to update data in a table.

C. Review the storage clause for a table or view.

D. Enable and disable indexes.

E. Truncate a table.

F. Download table data to XML.

G. Review the SQL statement for an existing table.

You created an application where the home page looks like:

You now want to change the page to look like:

What do you need to do to change the appearance of the page?

A. Update the region Type to "List View"

B. Update the list Template to "Media List"

C. Update the list Template Options > Style to "Basic"

D. Update the region Template Options > Icons to "No Icons"

A City Administration app has two select lists (LOVs). P1_STATE is based on "STATE" and P1_CITY is based on "CITY".

The CITIES table includes both the STATE and CITY columns. When a state is selected, the application should display only cities within the selected state, not all cities.

How can you limit the cities to display only those for the selected state?

A. Write a Set Value dynamic action against P1_STATE to require the P1_CITY based on the selected STATE.

B. Add P1_STATE to the "Page Items to Submit" property in P1_CITY.

C. In P1_CITY, set the "Cascading LOV Parent Item(s)" to P1_STATE.

D. Write an Execute PL/SQL Code dynamic action against P1_CITY to select the correct cities based on P1_STATE.

Jane" is creatinga new application, users of the application will use SSO to authenticate. SS0 has been defined forthe instance.Which step should Jane perform in the Create Application Wizard?

A. Under Authentication, select Single Sign On (SSO).

B. Include a Sign-in page in the list of pages.

C. Include the Access Control feature.

D. UpdateAdvanced Settings to specify authentication.