Online Access Free 1Z0-770 Practice Test

Which two statements are true about creating and customizing Smart Filters pages?

• A.The search results report can be displayed as an interactive grid
• B.The search results report can be displayed as an interactive report.
• C.If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache.
• D.The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types.

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_JOB, P2_HIREDATE, and P2_COMM.
• B.Create a dynamic action on P2_HIREDATE and P2_COMM.
• C.Create a dynamic action on P2_JOB.
• D.......... and enter SALESMAN for Value.
• E.Create a dynamic action on form load.

Which two are true when the Edit option is NOT enabled for an Interactive Grid?

• A.The end user cannot edit the underlying data in the database
• B.The end user can customize the report
• C.The end user cannot create charts
• D.The end user can edit the underlying data in the database

Which two Query Source types can be used to create a dynamic Navigation Bar List?

• A.Select List
• B.Function Returning SQL Query
• C.Procedure
• D.SQL Query

Select the three types of Facets you can create in APEX.

• A.Range
• B.Text Area
• C.Input Field
• D.Checkbox Group