Free Oracle APEX Developer Professional Exam 1Z0-770 Exam Practice Test

What are the three key features of Universal Theme?

• Support for single theme
• Versatile UI Components
• Responsive Design
• Easy Customization

You can create an APEX workspace and build APEX apps on which of the following platforms?

• Oracle Autonomous Cloud
• Oracle XE
• Amazon RDS
• Microsoft Azure
• All of the above

When you create a Dynamic Action, you specify the event that causes the dynamic action to fire. Choose the categories these events are classified into.

• Custom Events
• Framework Events
• All of them
• Component Events
• Browser Events

Examine this code used in Quick SQL:students nameroll no numQuick SQL is using default settings.Which table creation script or other output is produced?

• An Invalid column definition error message will be displayed.
• create table students (id number generated by default on null as identity constraint students id pk primary key,name varchar2 (255 char) not null, roll no number);
• create table students (
• id number generated by default on null as identity constraint students_id_pk primary key,
• name varchar2 (255 char), roll_no number
• )
• ;

Which is a valid Page Process type?

• Execute JavaScript Code
• Set Value
• Send E-Mail

What are Task definitions that exist on the application level in the Shared Components section made up of?

• Particpants
• All of them
• Task Settings
• Parameters
• Actions

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?

• Master Detail
• Cards
• Interactive Grid
• Unified Task List

Let's say that there are two select lists on a page. Making a selection in the DEPARTMENT select list, determines which individuals display in the Employees select list. This type of LOV is called:

• Popup LOV
• Cascading LOV
• Static LOV
• Dynamic LOV

Which two statements are true about the Create Application Wizard?

• It allows application pages to be reordered.
• It allows application pages to be added or deleted.
• It allows the uploading of JavaScript or CSS files required for an application.
• It allows the application authorization to be changed

An Employees App includes a form to enter and update employee details. Examine this Exhibit.Now you must extend the functionality of this form so that:If you select 'SALESMAN' from the select list for Job page item (P2_JOB), both the 'Hire date' (P2_HIREDATE) and 'Commission' (P2_COMM) page items and their associated labels are displayedIf you select any other value from the select list for Job page item (P2_JOB), both the 'Hire date' (P2_HIREDATE) and 'Commission' (P2_COMM) page items and their associated labels are hidden Which two steps must be performed?Create a dynamic action on form load.Create a dynamic action on P2_JOB, P2_HIREDATE, and P2_COMM.Create a dynamic action on P2_JOB.Create a dynamic action on P2_HIREDATE and P2_COMM.E and enter SALESMAN for Value.

• Com], [Managing Dynamic Actions - Oracle Help Center]