Free Oracle 1Z0-750 Exam Actual Questions

The questions for 1Z0-750 were last updated On Nov 5, 2024

Question No. 1

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?

Show Answer Hide Answer
Correct Answer: B

Question No. 2

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?

Show Answer Hide Answer
Question No. 3

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?

Show Answer Hide Answer
Correct Answer: D

Question No. 4

Which three actions can be performed In Object Browser?

Show Answer Hide Answer
Question No. 5

Which three item types support defining a list of values?

Show Answer Hide Answer