1Z0-750 Online Practice Questions and Answers

Brian created a page with multiple regions. He now wants to include a list of links to selectively display each region.

How can Brian achieve this?

A. Create a region of type Region Display Selector, and ensure that each region has Region Display Selector set to "Yes".

B. Create a parent region called REGIONS. For each region, update the Parent Region attribute to REGIONS.

C. Create a list in Shared Components containing each region. Create a region of type List and associated the list created.

D. Define static IDs for each region. Create a region called REGIONS of type Static Content with named anchors to other regions.

You want to use the session state value of a page item in the SELECT statement for a report on another page.

What is the correct way to reference the value of a page item in a SQL statement?

A. andPAGE_ITEM

B. v(`PAGE_ITEM')

C. APEX_UTIL.GET_SESSION_STATE(p_item => `PAGE_ITEM)

D. :PAGE_ITEM

Martin has a text field on a page that he wants to protect with Session State Protection.

Select the four valid protection levels available to Martin. (Choose four.)

A. Checksum Required: User Level

B. Hidden Item

C. Checksum Required: Workspace Level

D. Unrestricted

E. Checksum Not Required

F. Checksum Required: Session Level

G. Restricted: May not be set from browser

H. Checksum Required: Application Level

Which three are true about using REST Enabled SQL to access a remote database? (Choose three.)

A. Authentication must be done using the OAuth2 Client Credentials flow.

B. REST Enabled SQL must be enabled in the remote databases' ORDS configuration.

C. A wallet must be defined and configured on the remote database.

D. A REST Enabled SQL Reference must be created in Shared Components.

E. Authentication can be done using the remote database username and password.

F. The application parsing schema must be REST enabled.

Bill has created a Maintain Customer form as shown in Exhibit 1.

Now he wants the Last Name item to be next to the First Name item as shown in Exhibit 2.

How can Bill achieve this?

A. Set Start New Row to "Yes" and New Column to "Yes" for the Last Name item.

B. Set Start New Row to "No" for the Last Name item.

C. Set Column to "2" for the last Name item.

D. Set Column Span to "2" for the First Name item.

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

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".

Which processing point is enabled for computations during page processing?

A. Processing

B. After Submit

C. After Processing

D. Validating

David has created Page 10 as a form page using an Automatic Row Fetch process. A column named LOCATION has been added to the underlying table, and the form needs to include this new column.

You decide to copy an existing page item :P10_DEPTNO and use that to represent the LOCATION column.

Which is the minimum action required on the copied item to get the form working correctly?

A. Update the item label.

B. Set value required to No.

C. Update the item name.

D. Change the source type to NULL.

E. Set the source database column to LOCATION.

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.

Mark has created a modal form page to enter new calendar events. Mark now wants to call the form when an end user clicks an empty calendar spot.

How can Mark update the calendar region to call the form?

A. Define a dynamic action of type Click in the calendar region.

B. Use the create link attribute and the andAPEX$NEW_START_DATE. placeholder.

C. In the rendering tree, right-click the calendar region and select the Link Form to Calendar option.

D. Use the create link attribute and use the :APEX$NEW_START_DATE bind variable.

E. Use the view/edit link attribute to display the selected calendar entry.

Jason has developed an app for maintaining customers. He has a navigation menu for customers that he needs to associate with multiple pages.

How can Jason associate one list entry with multiple pages?

A. Set List Entry Current for Pages Type to "Comma Delimited Page List."

B. Update the list entry User Defined Attribute 01 to "MULTIPLE", and User Defined Attribute 02 to the list of pages.

C. Update each page and set Current Navigation Menu Entry to "Customers".

D. Add additional list entries labeled Customers.

E. Update list entry Condition Type to "Current Page Is Contained Within Expression 1 (comma delimited list of pages)."

Trillian wants to pass an item value, which includes a comma, such as the value Donuts, Coffee, in the URL when calling another page.

How can Trillian escape the item value so that the comma is interpreted correctly?

A. /Donuts,Coffee/

B. \Donuts,Coffee\

C. Donuts\,Coffee

D. "Donuts,Coffee"

Nancy has an application that is performing unexpectedly. She has turned on debug for the page and reviewed the debug messages and still can't determine the cause of the inconsistent behavior. She believes it may be an APEX bug.

What action should Nancy take to identify the issue?

A. Review the browser console output.

B. Review the application error log.

C. Set Debug Level to 9 and review the debug messages.

D. View the page source.