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

Question 1

In your APEX application, you want to have an orderly grid layout of information tiles. Which page type should you choose in the Create Page Wizard?

A. Unified Task List

B. Cards

C. Master Detail

D. Interactive Grid

Correct Answer: B

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

Question 2

Choose from the following the different kinds of page components you can create in APEX.

A. All of them

B. Smart Filters

C. Interactive Grid

D. Faceted Search

E. Search Page

Correct Answer: A

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

Question 3

Which two are true about Oracle APEX?

A. Performs the data processing in a middle-tier server

B. Requires no additional client software. A web browser is the app development IDE.

C. Is declarative. It requires no code generation.

D. Requires developers to be proficient in Java, Python and other programming languages.

Correct Answer: B,C

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

Question 4

Choose the two statements that are TRUE about an Interactive Report. As a developer:

A. You can customize the pagination

B. You can modify the data in the report after running the app

C. You cannot modify the report source query

D. You can customize the Actions menu to include or exclude certain options.

Correct Answer: A,B

Question 5

Consider a page in an APEX app where the Departments names with location is displayed on the left. Selecting a Department on the left will render details of the employees corresponding to that department on the right. Which kind of report/form is this?

A. Cards

B. Stacked Master Detail

C. Side by Side Master Detail

D. Interactive Report

Correct Answer: B

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

Question 6

Developers can use Template Options in which of the following ways?

A. All of them

B. Applying different spacing and padding

C. Displaying form fields with different alignments

D. Applying different colors or accents

E. Rendering buttons in different styles, with and without icons

Correct Answer: A

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

Question 7

Choose the statement that is TRUE about Universal Theme.

A. All of them

B. Uses a 12-column grid layout system for arranging components on a page.Ships with a variety of pre-built theme styles

C. Universal theme is the default theme that is shipped with Oracle APEX

D. Features a responsive design and enables developers to create web applications without extensive knowledge of HTML, CSS, or JavaScript

Correct Answer: A

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

Question 8

An application includes a report and form on the PRODUCTS table.
The form page includes page items P21 PRODUCT NAME and P21_UNIT_PRICE.
P21_UNIT_PRICE is currently displayed below P21_PRODUCT_NAME.
Now, you need to reposition the items and display P21 UNIT_PRICE next to P21_PRODUCT_NAME.
Which two statements are true?

A. In Page Designer, select P21_UNIT_PRICE and then in the Property Editor, under Layout set Start New Row to Yes.

B. In Page Designer, right-click P21_UNIT_PRICE and select Start New Row.

C. In Page Designer, use the Middle Pane, click P21 UNIT PRICE and drag the item until it is directly next to P21 PRODUCT_NAME.

D. In Page Designer, select P21_PRODUCT_NAME and then in the Property Editor, under Layout set Start New Row to Yes.

Correct Answer: A,C

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

Question 9

Which two statements are true about REST Data Source Synchronization?

A. You cannot trigger Data Synchronization on a regular schedule using a scheduler job.

B. The local table can only be used for Data Synchronization but you cannot add indexes or change physical properties

C. To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema.

D. If the local table is not in sync with the Data Profile, Data Synchronization continues to work for columns present in both the table and the Data Profile.

E. If the local table is not in sync with the Data Profile, Data Synchronization doesn't work.

Correct Answer: C,D

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

Question 10

Which statement is true about creating and using a faceted search page?

A. The Search Results region can be displayed as a Classic Report or Cards.

B. If you create a faceted search page based on a table, the facets are not auto-discovered.

C. The Search Results region can be displayed as an interactive report.

D. If you create a faceted search page on a view or a SQL query, the facets are auto-discovered.

Correct Answer: A

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

Welcome to TestSimulate

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