Free Oracle 1Z1-750 Exam Dumps Questions & Answers

Kevin has been asked to create a percentage bar chart that shows what percentage of project were over budget and under budget. Initially his chart looks like.

However, he wants the chart to look like.

What chart attribute should Kevin change to fix this display issue?

• A.  Chart Type =Percent
• B.  Fill Gaps in Chart Data + Yes
• C.  Stack = Yes
• D.  Combine Series = Yes

Michael has developed an app for tracking product defects. His navigation menu lists each product. He has defined application items and computations to hold the number of defects for each product.
For example, for Hedgers, he has defined the application item HEDGER_DEFECT.
How can Michael add the number of open defects in the navigation menu entries?

• A.  Update the List Entry Label for Hedgers to Hedgers 'HEDGER_DEFECTS., and similarity for the products.
• B.  Update Template Options and set Display Count to True.
• C.  Update Navigation Menu template to be Include Count.
• D.  Add 'HEDGER_DEFECTS. To User Defined Attribute 01 in the navigation menu for Hedgers, and similarly for other product.

In Application Express, how do you enable a database schema assigned to the current workspace so that it can be used to serve ORDS based RESTful Services?

• A.  Navigate to workspace administration and in the Set Workspace Preferences section, set Enable RESTful Services to "Yes."
• B.  Navigate to the Shared Components section and configure a REST Enabled SQL resource
• C.  Navigate to the ORDS RESTful services section of SQL workshop, select the appropriate schema, and click the "Register schema with ORDS' button.
• D.  Install the Sample REST Services packaged application.

Kyle is developing a page with an interactive report, called Employees, using this query:
SELECT EMPNO, ENAME, JOB, DEPTNO FROM EMP WHERE DEPTNO = nvl(:P3_DEPTNO, DEPTNO) On the page, Kyle adds a select list, called P3_DEPTNO, using this query:
SELECT dname, deptno FROM dept;
He creates a dynamic action on change of P3_DEPTNO, with a true action of "Refresh" against the Employees region.
Kyle then runs the page and selects ACCOUNTING in the P3_DEPTNO item. However, the report still shows employees from all departments.
What must Kyle do to correctly display only employees from the department selected?

• A.  Add an additional true action of Set Value by using Static Assignment in Dynamic Action.
• B.  Set "Page Items to Submit" to p3_deptho in the report.
• C.  Add a computation set to p3_ DEPTNO
• D.  Set a column on the DEPTNO column.

Which best describes how Session State Protection works?

• A.  adds checksums to Page Access Protection attributes and Session State Protection Item attributes to prevent alteration of session state
• B.  encrypts the values supplied in the URL to prevent reading of the values
• C.  saves sensitive data in Oracle Application Express session state tables In encrypted form, stopping users from tampering with the data
• D.  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