1Z0-750 Online Practice Questions and Answers

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.

Robert has a form page, Page 5, on the EMP table. He has defined two validations.

1.

Validation 1 checks that P5_MGR is not null.

2.

Validation 2 checks that the employee selected in P5_MGR has a job of PRESIDENT or MANAGER.

How can Robert prevent the employee job validation (Validation 2) from firing when the P5_MGR is NOT NULL validation (Validation 1) has failed?

A. Set stop processing to Yes for the P5_MGR is NOT NULL validation (Validation 1)

B. Ensure Validation 1 is listed before Validation 2

C. Add a server-side condition of P5_MGR is NOT NULL to the employee job validation (Validation 2)

D. Set Always Execute to No for the P5_MGR employee job validation (Validation 2)

ABC Company developed an employee directly by using an interactive report.

The HR manager (an end user) has customized his or her report to show only employees in the HR

department, and wants to review the same report weekly.

How can the HR manager achieve this?

A. Add a control break on Department

B. Add a filter to the report

C. Save the report as a named report

D. Save the report as the primary report

E. Download the report to a CSV or HTML file

Jules is trying to implement Session State Protection to increase the security of Jules' application.

On which three components can Jules configure Session State Protection in Oracle Application Express? (Choose three.)

A. pages

B. page items

C. page regions

D. application items

E. buttons

F. page processes

Thomas has created an app and wants to add a help icon to the navigation bar. He has added the list entry with the Image/Class fa-question-circle-o and List Entry Label "Help". When he runs the app, the question mark is displayed together with the word Help.

How can Thomas display just the icon and not the word Help in the navigation bar?

A. Set List Attributes to style="display:none;"

B. Set List Entry Label to "Null"

C. Set User Defined Attribute 02 to icon-only

D. Set List Entry Template to "Icon"

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 Server-side Condition to "Never"

B. Set the Road Only condition to "Always"

C. Delete the region

D. Set the Read Only condition to "Never"

E. Set the Parent Region to "Null"

Jim has developed a form page. When running the page, the data displayed is not what he expected. Therefore, he wants to review the information in session state while debugging the form.

How can Jim accomplish this?

A. View page source information in the browser.

B. Click the Session button on the Developer toolbar.

C. Add a debug flag to the URL and rerun the page.

D. Click the View Debug button on the Developer toolbar.

E. Edit the page and update session state items to "Display Only".

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 is true about a workspace in Oracle APEX?

A. It can be associated only with one schema.

B. It can be associated with multiple schemas from different databases.

C. It can be associated with the multiple schemas in the same database.

D. It is not associated with any schemas.

You'have created this chart:

However, you want to display this chart:

How should you update the chart?

How should you update the chart?

A. Update the value aggregation to `'Percentage.''

B. Update the query to calculate the value divided by the total value.

C. Update the y-axis format to percent.''

D. Update the show as percentage to `'yes.''