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

Loading demo links...

Showing 7–9 of 10 questions

Question 7

You have defined a form page on the ORDERS table and changed page item :P5_ORDER_TOTAL to type

Hidden.

You also created a dynamic action to update the value of :P5_ORDER_TOTAL when any order items are added, updated, or deleted on the page.

However, when you submit the page, you get this error:

Session state protection violation: This may be caused by manual alteration of protected page item P5_ORDER_TOTAL. If you are unsure what caused this error, please contact the application administrator for assistance.

How should you update :P5_ORDER_TOTAL page item to prevent this error?

Select an option, then click Submit answer.

  • Set Value Protected to "No."

  • Set Session State Protection to "Unrestricted."

  • Change the Item type to "Display Only."

  • Set Store value encrypted In session state to "Yes."


Question 8

You' have created this chart:

However, you want to display this chart:

How should you update the chart?

How should you update the chart?

Select an option, then click Submit answer.

  • Update the value aggregation to ‘’Percentage.’’

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

  • Update the y-axis format to percent.’’

  • Update the show as percentage to ‘’yes.’’


Question 9

Which is Hue about interactive reports?

Select an option, then click Submit answer.

  • Interactive reports can be either read-only or editable.

  • All columns defined In the report query must be shown.

  • You can define only one Interactive report on a page.

  • An Interactive report can be based on a PL/SQL function body returning a SQL query.