Select the two places from where you can access the Shared Components Page?

• A.Gallery
• B.Page Designer
• C.Application homepage
• D.SQL Workshop

Comment: *

Name: *

Email: *

Verification: *

The Movies faceted search report is filtered only when the Apply button for a selected facet is clicked. What must be done in the Page Designer so that report filtering is automatically executed when any facet value changes?

• A.Navigate to the faceted search region Attributes, and turn off the show Facet Name attribute. Then, navigate to each facet and in the Property Editor, turn on client-Side Filtering.
• B.Navigate to each facet and then in the Property Editor, turn on client-Side Filtering.
• C.Navigate to the faceted search region Attributes, and turn off the show Facet Name attribute.
• D.Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute

Comment: *

Name: *

Email: *

Verification: *

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) not null, 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), roll_no number )
  ;

Comment: *

Name: *

Email: *

Verification: *

There is a validation of type Item is numeric on the P1_SALARY item. When the page is submitted, this or message is displayed both in the notification and below the item: What will cause the validation error to appear only in the Notification area?

• A.Setting the value Required to Yes on P1_SALARY
• B.Removing P1_SALARY from the validation Associated Item
• C.Setting Display Location to Inline in Notification

Comment: *

Name: *

Email: *

Verification: *

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.Master Detail
• B.Cards
• C.Interactive Grid
• D.Unified Task List

Comment: *

Name: *

Email: *

Verification: *