Oracle APEX Developer Professional - 1z1-770 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

When a table or a SQL query returns many rows, an Interactive Grid is best displayed to the user with pagination. The two types of pagination available are:

A. Page B. Scroll C. No Pagination D. Page and Scroll

Discussion 0

Correct Answer: D Vote an answer

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

Question 2

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. Drill down Master Detail B. Side by Side Master Detail C. Stacked Master Detail D. Editable Interactive Grid

Discussion 0

Correct Answer: A Vote an answer

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

Question 3

Which two of the following types can an end user save the customized Interactive report as?

A. A Public report B. Default report C. A private report D. Cannot save the report

Discussion 0

Correct Answer: A,C Vote an answer

Question 4

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, right-click P21_UNIT_PRICE and select Start New Row. B. In Page Designer, select P21_UNIT_PRICE and then in the Property Editor, under Layout set Start New Row to Yes. 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.

Discussion 0

Correct Answer: B,C Vote an answer

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

Question 5

Choose the three requirements for creating a REST Enabled SQL Reference.

A. Set up any remote database B. Install Oracle REST Data Services (ORDS) 19.x or later. C. Activate REST Enabled SQL for the target schema on the remote database D. Configure and enable the REST Enabled SQL service feature

Discussion 0

Correct Answer: B,C,D Vote an answer

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

Question 6

What three are the building blocks of Approvals Component?

A. Task Details Page B. Automations C. Unified Task List D. Task Definition

Discussion 0

Correct Answer: A,C,D Vote an answer

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

Question 7

Which of the following are preconfigured authentication schemes?

A. Open Door Credentials B. HTTP Header Variables C. All of them D. Social Sign In E. LDAP Directory

Discussion 0

Correct Answer: C Vote an answer

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

Question 8

Which component in SQL Workshop allows you to build queries graphically without manual SQLcoding?

A. Quick SQL B. SQL commands C. Data Workshop D. Query Builder

Discussion 0

Correct Answer: D Vote an answer

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

Question 9

You must create a single master detail page where users can select a row in the master grid to update the detail grids.
Users must also interact with the master or the detail without leaving the page.
Which type of master detail implementation should you use?

A. Drill Down B. Side by Side C. Stacked

Discussion 0

Correct Answer: C Vote an answer

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