Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Certensure Logo
  1. Home
  2. Oracle
  3. Oracle Application Express 18
  4. 1z0-750 - Oracle Application Express 18: Developing Web Applications

Oracle 1z0-750 Oracle Application Express 18: Developing Web Applications Exam Practice Test

Demo: 11 questions
Total 75 questions
Get 1z0-750 Full Access Download 1z0-750 PDF

Oracle Application Express 18: Developing Web Applications Questions and Answers

Question 1

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

Options:

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

Question 2

George used the Create Page Wizard to create a calendar on the DEMP_ORDERS table based on the ORDER_TIMESTAMP column However, the calendar shows only the month and list views.

What does George need to do to show week and day views?

Options:

A.

Select the End Date Column.

B.

Set Show Time to "Yes."

C.

Set Maximum Events / Day to greater than 1.

D.

Select Week and Day under Calendar Views and Navigation.

Question 3

You' have created this chart:

However, you want to display this chart:

How should you update the chart?

How should you update the chart?

Options:

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

Question 4

KIM has defined a validation of ‘’ Item is NOT zero’’ on ps_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?

Options:

A.

Add javaScript to the item to display on error.

B.

Set Display Location to ‘’Inline with Field.’’

C.

Set value Requires to Yes on p5_SAL.

D.

Set validation Associated Item to p5 SAL.

Question 5

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

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

Options:

A.

Define a dynamic action of type click in the calendar region.

B.

Use the create link attribute and the APEXSNEW_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 :APEXSNEW_STANT_DATE bind variable.

E.

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

Question 6

Jason has developed an app lot 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?

Options:

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 page*.

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).'

Question 7

Which two actions can be done by a Page Process of type Automatic Row Processing (DML)?

Options:

A.

Perform automatic detection of lost updates.

B.

Perform CRUD operations on multiple tables.

C.

Log a user-defined message when an exception is raised.

D.

Apply a SQL where clause to append to all generated INSERT, UPDATE, and delete statements at fun time.

E.

Generate a primary key column value on a SQL INSERT statement.

F.

invoke PL/SQL code to perform the Inserts, updates, and deletes.

Question 8

Which is the true about a workspace in Oracle APEX?

Options:

A.

It can be associated only with one schema.

B.

It can be associated with multiple schema from different database.

C.

It can be associated with multiple schema in the same database.

D.

It is not associated with any schema.

Question 9

John is evaluating an old APEX application that has over 20 tabular forms. Ho wants to update the application and replace all of the tabular forms with interactive grids.

What is the fastest way for John to replace the old reports?

Options:

A.

Go to each page with a tabular form, copy the SQL Source from the Tabular Form region, and use it to create a new Interactive grid.

B.

Use the Create Page Wizard to create new pages with interactive grids, and then delete the old pages with tabular forms.

C.

Use the Upgrade Application utility and select the candidate objects listed for "Upgrade Tabular Form to Interactive Grid," select all, and then click Upgrade.

D.

Go to each report and change the type from Tabular Form to Interactive Grid.

Question 10

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?

Options:

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

Question 11

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

Options:

A.

Classic Report

B.

Interactive Report

C.

Chart

D.

Static Content

E.

List View

F.

Interactive Grid (non-editable)

G.

List

Load More 1z0-750 Questions
Demo: 11 questions
Total 75 questions
Get 1z0-750 Full Access Download 1z0-750 PDF