Online Access Free 1z1-770 Practice Test

Choose the two statements that are TRUE about the Universal Theme in APEX.

• A.Not designed to work on tablets
• B.Easy customization
• C.The developers must have extensive knowledge about Javascript, CSS and HTML in order to use the Universal Theme.
• D.Responsive UI

Using Data Workshop, you can perform which three tasks:

• A.Load vast amount of data into the database
• B.Load data using various file formats such as XLSX, CSV, XML, and JSON
• C.Delete data from the database
• D.Export vast amount of data from the database into a file

Which two statements are true about a Progressive Web Application (PWA)?

• A.PWA features will be rendered even if the application is served in an unsecured environment.
• B.To use the PWA feature, the Friendly URLS attribute in the Application Definition, Properties section must be turned Off.
• C.Enabling the PWA functionality optimizes page loading speed on a mobile device.
• D.Enabling the PWA functionality in your APEX app adds a new navigation bar entry named Install App to your app.
• E.You can create a PWA only when creating a new application with the Create Application Wizard.

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

• A.An Invalid column definition error message will be displayed.
• B.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 )
  ;
• C.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 )
  ;

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 displayed
* If 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?

• A.Create a dynamic action on P2_HIREDATE and P2_COMM.
• B.Create a dynamic action on P2_JOB, P2_HIREDATE, and P2_COMM.
• C.Create a dynamic action on P2_JOB.
• D.Create a dynamic action on form load.
• E.......... and enter SALESMAN for Value.