Online Access Free 1Z0-770 Practice Test

What three are the result of the following QuickSQL shorthand notation do?
departments /insert 4
name /nn
location
country

• A.Create the departments table with 3 columns
• B.Inserts 4 rows of random data into the departments table
• C.Creates an id column as a primary key
• D.Create the departments table with 4 columns

Which statement is true about creating and using a report with form?

• A.Both the Create Application Wizard and Create Page Wizard support the creation of an interactive report or classic report and form combination.
• B.The Create Page Wizard doesn't support the creation of a classic report and formcombination
• C.In the Create Application Wizard, you can select a data source (that is, Local Database, REST Enabled SQL Service, or REST Data Source).
• D.The Create Application Wizard doesn't support the creation of an interactive report and form combination.

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

• A.Parameters
• B.Task Settings
• C.Actions
• D.Particpants
• E.All of them

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

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

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