Oracle APEX Developer Professional (1z1-770) Free Practice Test

Question 1

To highlight certain rows in the interactive report based on a condition, you must:

A. Choose a condition in Format > Highlight

B. Provide a conditional SQL query

C. Rows cannot be highlighted in an Interactive report

D. Edit the rows in the report and select a color

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

You use the Create Page Wizard to create a faceted search page on the EMP table. What is the default report type generated for this page?

A. Column Toggle Report

B. Classic Report

C. Interactive Grid

D. Interactive Report

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

Choose the two options provided in a Column Heading menu of an Interactive Report.

A. Hide

B. Group By

C. Control Break

D. Delete

Correct Answer: A,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

What are the three types of List of Values(LOV) you can create on a page?

A. Popup LOV

B. Static LOV

C. Cascading LOV

D. Dynamic LOV

Correct Answer: B,C,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

In your application, you want to include a master aetall containing two pages based on two related tables or views. The first page contains an interactive report for the master table. The second page features a standard form for the master and interactive grids for the detail. Which master detail form will you create?

A. Editable Interactive Grid

B. Drill down Master Detail

C. Stacked Master Detail

D. Side by Side Master Detail

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

Choose from the below options the actions that can be performed when a button is clicked.

A. All of them

B. Redirect to a URL

C. Redirect to a page in a different application

D. Submit Page

E. Redirect to a page in the same application

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

Which two feature pages can you create using the Create Page Wizard?

A. Unified Task List

B. Access Control

C. Feedback

D. Search Page

Correct Answer: B,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Oracle APEX Developer Professional (1z1-770) Free Practice Test