oracle 1z0-750 practice test
Oracle Application Express 18: Developing Web Applications Exam
Question 1
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.
Answer:
C
Explanation:
Reference:
https://docs.oracle.com/database/121/AEAPI/apex_debug.htm
Question 2
Bob has created an interactive report on the EMP table. Oracle B1 Publisher has been configured as
the report server in his environment. He has been asked to output a high-fidelity PDF report, which
lists all employees.
How can Bob define the report?
- A. Create a model page with a classic report on EMP by using the Printer-Friendly template. Add a button to the page to call the new model page.
- B. Define a report query and report Layout based on the EMP table. Add a button to the page to output the report.
- C. Update the Interactive Report attributes and set Download > PDF to Checked.’
- D. Update the Interactive Report attributes and set Download > High Fidelity to Checked.’’
Answer:
D
Question 3
Which is Hue about interactive reports?
- A. Interactive reports can be either read-only or editable.
- B. All columns defined In the report query must be shown.
- C. You can define only one Interactive report on a page.
- D. An Interactive report can be based on a PL/SQL function body returning a SQL query.
Answer:
D
Explanation:
Reference:
https://docs.oracle.com/database/apex-5.1/HTMDB/about-making-grids-
editable.htm#HTMDB-GUID-0A317D17-5B12-4F4A-B5C8-68807DB5A4C1
Question 4
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?
- A. Set Value Protected to "No."
- B. Set Session State Protection to "Unrestricted."
- C. Change the Item type to "Display Only."
- D. Set Store value encrypted In session state to "Yes."
Answer:
D
Explanation:
Reference:
http://oracledba.bigresource.com/Application-Express-Session-state-protection-violation-error-0RGXXq8b6.html
Question 5
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 equerry the P1_CITY based on the selected STATE.
- B. Add P1_STAFF 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_CM to select the correct cities based on P1__STATE
Answer:
A
Question 6
Mary is using an APEX Interactive Grid report that has many columns and wants to see the most
important Information while minimizing horizontal scrolling.
Which three actions will help her to best accomplish this goal?
- A. Define a filter.
- B. Freeze the first few columns.
- C. Reset report settings.
- D. Hide the columns that are not Important to see.
- E. Reduce the width of columns.
- F. Order the columns so that the most important columns are first.
- G. Collapse the report settings area.
Answer:
BFG
Question 7
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."
Answer:
B
Explanation:
Reference:
https://apex.oracle.com/pls/apex/apex_pm/r/ut/lists
Question 8
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”
Answer:
D
Question 9
Francisco has been tasked with creating a Frequently Asked Questions (FAQ) page. The page security
requirements are defined as:
Anyone who can access the application. In any capacity, shall also be able to view the new FAQ page.
Which page level Authorization Scheme and Authentication options should Francisco choose?
- A. Authorization Scheme: Reader Rights; Authentication: Page Requires Authentication
- B. Authorization Scheme: Null; Authentication: Page is Public
- C. Authorization Scheme: {Not Reader Rights}; Authentication: Page Is Public
- D. Authorization Scheme: Must Not Be Public User; Authentication: Page Requires Authentication
Answer:
B
Question 10
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?
- 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).'
Answer:
E