1z0-770 Exam Dumps - Oracle APEX Cloud Developer Professional

A facet is a type of component that provides a set of display values and return values for a faceted search region or a smart filters region. A facet can be based on either static values or dynamic values from a list of values (LOV). A facet can also have different display styles depending on its type and settings. Three of the types of facets that you can create in APEX are:

• Range: A range facet displays numeric values in either buckets or sliders that users can select or adjust to filter the search results. A range facet can have either static values or dynamic values based on an LOV or SQL query.
• Checkbox Group: A checkbox group facet displays multiple options that users can select or deselect to filter the search results. A checkbox group facet can have either static values or dynamic values based on an LOV or SQL query.
• Input Field: An input field facet displays a text field that users can enter text to filter the search results. An input field facet does not have any values but uses an operator to compare the user input with the data.

Query Builder is a component in SQL Workshop that allows you to build queries graphically without manual SQL coding. You can use Query Builder to select tables and views from your schema, join them using drag-and-drop operations, add filters andgroupings, and view the results in a grid or chart format. You can also switch to the SQL mode to view or edit the generated SQL statement.

The other options are incorrect because:

• Quick SQL is a component in SQL Workshop that allows you to generate SQL scripts for creating tables and other database objects using shorthand syntax. You cannot use Quick SQL to build queries graphically.
• SQL Commands is a component in SQL Workshop that allows you to run individual SQL statements or PL/SQL blocks interactively. You cannot use SQL Commands to build queries graphically.
• Data Workshop is a component in SQL Workshop that allows you to load or unload data from the database using various file formats. You cannot use Data Workshop to build queries graphically.

Verified References: [About Query Builder] [Using Query Builder]

Using Data Workshop, you can perform the following tasks:

• Load vast amount of data into the database: You can use the Data Load option to load data from various file formats such as XLSX, CSV, XML, and JSON into a table or a collection in your database. You can also use the Data Load Wizard to guide you through the steps of loading data.
• Export vast amount of data from the database into a file: You can use the Data Unload option to export data from a table or a collection in your database into a file in CSV or JSON format. You can also use the Data Unload Wizard to guide you through the steps of exporting data.
• Load data using various file formats such as XLSX, CSV, XML, and JSON: You can use the Data Load option to load data from different file formats into your database. You can choose the file format from a list of supported formats or let Oracle APEX detect it automatically.

The other option is incorrect because:

• Delete data from the database: You cannot use Data Workshop to delete data from the database. You can use SQL Commands or SQL Scripts in SQL Workshop to run DELETE statements to delete data from the database.

Verified References: [About Data Workshop] [Loading Data] [Unloading Data]

You can create a chart in an interactive grid by selecting Chart in the Actions menu. You can only create one chart at a time in an interactive grid. To create a second chart, you have to reconfigure or delete the existing chart1. To remove a chart, you can click the Remove Chart icon (X) adjacent to the chart filter12. Once a chart is created, you can switch the view between Grid and Chart by clicking the toggle that appears at the top of the interactive grid