Dec-2024 Latest ActualTestsIT 1Z0-770 Exam Dumps with PDF and Exam Engine Free Updated Today!
Following are some new 1Z0-770 Real Exam Questions!
NEW QUESTION # 53
When a table or a SQL query returns many rows, an Interactive Grid is best displayed to the user with pagination. The two types of pagination available are:
- A. No Pagination
- B. Page
- C. Scroll
- D. Page and Scroll
Answer: D
Explanation:
Explanation
When a table or a SQL query returns many rows, an interactive grid is best displayed to the user with pagination. Pagination enables users to navigate through large data sets by displaying a subset of data at a time3. The two types of pagination available for interactive grids are Page and Scroll3. Page pagination displays a fixed number of rows per page and provides controls to navigate between pages. Scroll pagination displays rows as the user scrolls down the grid and fetches more data as needed
NEW QUESTION # 54
From SQL Workshop, you can perform which two of the following actions?
- A. Create an APEX user
- B. Run SQL commands and scripts
- C. Create and view database objects
- D. Delete database
Answer: B,C
Explanation:
Explanation
From SQL Workshop, you can perform the following actions:
Run SQL commands and scripts: You can use SQL Commands or SQL Scripts components to run individual SQL statements or PL/SQL blocks interactively or in batch mode. You can also view the results, errors, or explain plans of your commands or scripts.
Create and view database objects: You can use Object Browser component to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can also use this component to create new objects, modify existing objects, drop objects, or run object reports.
The other options are incorrect because:
Create an APEX user: You cannot use SQL Workshop to create an APEX user. You can use Workspace Administration component to create and manage users in your workspace.
Delete database: You cannot use SQL Workshop to delete database. You can only delete database objects such as tables or views from your schema.
Verified References: [About SQL Workshop] [Using SQL Commands] [Using SQL Scripts] [Using Object Browser] [Managing Workspace Users]
NEW QUESTION # 55
Which two types of pages behave similarly in functionality?
- A. Map
- B. Cards
- C. Smart Filter
- D. Faceted Search
Answer: C,D
Explanation:
Explanation
A Faceted Search and a Smart Filter are two types of pages that behave similarly in functionality. They both allow users to filter data based on multiple criteria and see the results in real time. They differ in the following aspects:
A Faceted Search uses facets to filter data. A facet is a set of filters based on a column or expression. A facet can be displayed as a list, a range slider, a star rating, or a chart.
A Smart Filter uses conditions to filter data. A condition is a logical expression that evaluates to true or false. A condition can be based on a column, an item, or a function.
The other options are incorrect because:
A Map is a type of region that displays spatial data on an interactive map. It allows users to zoom, pan, and select features on the map.
A Cards is a type of region that displays data in a grid of cards. Each card represents one row of data and can contain text, images, icons, or buttons.
Verified References: [About Faceted Search] [About Smart Filter] [About Maps] [About Cards]
NEW QUESTION # 56
Which three of the following are use cases of Automations?
- A. Deleting a database record based on an end user's request
- B. Approving specific requests
- C. Sending email alerts at a particular time of the week
- D. Monitoring log tables and raising an alert when there is an issue
Answer: B,C,D
Explanation:
Explanation
Automations are a sequential set of PL/SQL actions that are triggered by query results. They are used to monitor data and then perform the appropriate action2. Some use cases of automations are:
Monitoring log tables and raising an alert when there is an issue. For example, an automation can query a log table for any errors and send an email notification to the administrator if any errors are found2.
Approving specific requests. For example, an automation can query a table for any pending requests and approve them automatically based on some criteria2.
Sending email alerts at a particular time of the week. For example, an automation can query a table for any overdue tasks and send a reminder email to the assignees every Monday2.
Deleting a database record based on an end user's request is not a use case of automations, as it does not involve querying data and triggering actions based on the query results. This can be achieved by using a PL/SQL process or a dynamic action on the page where the user requests the deletion34.
NEW QUESTION # 57
To highlight certain rows in the interactive report based on a condition, you must:
- A. Provide a conditional SQL query
- B. Edit the rows in the report and select a color
- C. Choose a condition in Format > Highlight
- D. Rows cannot be highlighted in an Interactive report
Answer: C
Explanation:
Explanation
To highlight certain rows in the interactive report based on a condition, you must choose a condition in Format
> Highlight. This option allows you to apply a conditional formatting rule to the report, which changes the appearance of the rows that match the condition. You can specify the condition type, expression, column, operator, and value. You can also choose the highlighting style, such as background color, text color, or icon.
The other options are incorrect because:
Provide a conditional SQL query: This option will not highlight certain rows in the interactive report based on a condition. It will filter the data in the report by applying a WHERE clause to the SQL query that defines the report source.
Edit the rows in the report and select a color: This option will not highlight certain rows in the interactive report based on a condition. It will modify the data in the report by using inline editing or modal dialog editing. You cannot select a color for the rows in this option.
Rows cannot be highlighted in an Interactive report: This option is false. Rows can be highlighted in an Interactive Report by using the Format > Highlight option.
Verified References: [Customizing Interactive Reports] [Highlighting Rows Based on Conditions]
NEW QUESTION # 58
Using the App Builder component, you can perform which three tasks?
- A. Install a sample App
- B. Edit pages in the page designer
- C. Create a new App
- D. Run SQL scripts and commands
Answer: A,B,C
Explanation:
Explanation
Using the App Builder component, you can perform the following tasks:
Edit pages in the page designer: You can use the Page Designer tool to modify the pages in your application using drag-and-drop operations, property editors, and code editors. You can also preview how your pages will look on different devices.
Install a sample app: You can use the Gallery option to install a sample app from a list of pre-built applications that demonstrate various features and best practices of Oracle APEX. You can also use the Packaged Apps option to install a packaged app from a list of ready-to-use applications that provide common functionality and solutions.
Create a new app: You can use the Create App option to create a new app from scratch or from an existing data source using the Create Application Wizard. You can also use the From a File option to create a new app from a file that contains data or metadata.
The other option is incorrect because:
Run SQL scripts and commands: You cannot use the App Builder component to run SQL scripts and commands. You can use the SQL Workshop component to run SQL scripts and commands using the SQL Commands or SQL Scripts tools.
Verified References: [About App Builder] [Using Page Designer] [Installing Sample Apps] [Installing Packaged Apps] [Creating Applications]
NEW QUESTION # 59
Which two tasks can you perform using App Builder?
- A. Create and manage apps.
- B. Import previously exported apps.
- C. Generate data definition language (DDL) statements from the Oracle data dictionary.
- D. Create join queries using drag and drop.
- E. Create and manage database objects.
Answer: A,B
Explanation:
Explanation
App Builder is the main interface of Oracle APEX that allows developers to create and manage web applications. App Builder provides various features and tools to design, develop, test, debug, deploy, and maintain applications. Some of the tasks that you can perform using App Builder are importing previously exported apps, creating new apps from scratch or from predefined templates or blueprints, editing app properties and attributes, adding pages and regions, creating shared components, running and debugging apps, exporting apps to files or workspaces, etc. You cannot create join queries using drag and drop or generate DDL statements from the Oracle data dictionary using App Builder. Verified References: [Using App Builder
- Oracle Help Center], [App Builder Concepts - Oracle Help Center]
NEW QUESTION # 60
In your application, you want to include a master aetall containing two pages based on two related tables or views. The first page contains an interactive report for the master table. The second page features a standard form for the master and interactive grids for the detail. Which master detail form will you create?
- A. Side by Side Master Detail
- B. Editable Interactive Grid
- C. Stacked Master Detail
- D. Drill down Master Detail
Answer: D
Explanation:
Explanation
A drill down master detail form allows you to create a master detail form that contains two pages based on two related tables or views. The first page contains an interactive report for the master table. The second page features a standard form for the master and interactive grids for the detail. You can use the Create Page wizard to create a drill down master detail form. References: Creating Master Detail Forms and [Creating a Drill Down Master Detail Form]
NEW QUESTION # 61
Which statement is true about creating and using a faceted search page?
- A. If you create a faceted search page on a view or a SQL query, the facets are auto-discovered.
- B. The Search Results region can be displayed as a Classic Report or Cards.
- C. If you create a faceted search page based on a table, the facets are not auto-discovered.
- D. The Search Results region can be displayed as an interactive report.
Answer: B
Explanation:
Explanation
A faceted search page is a type of page that allows end users to filter data by applying one or more facets. A facet is a set of filters based on a column or expression. You can create a faceted search page by using the Create Page Wizard or by adding a faceted search region to an existing page. If you create a faceted search page based on a table, view, or SQL query, the facets are auto-discovered by analyzing the data source. The Search Results region can be displayed as a Classic Report or Cards, but not as an interactive report. You can also customize the appearance and behavior of the facets and the search results by using various attributes.
Verified References: [Creating Faceted Search Pages - Oracle Help Center], [Faceted Search Attributes - Oracle Help Center]
NEW QUESTION # 62
Which is a valid method of logging messages to the execution log in APEX automation?
- A. apex_automation.log_info('SAL for || :ENAME || increased by 18.');
- B. apex error.add error ( p_message => 'SAL for || :ENAME || increased by 1%.', p_display_location => apex_error.c_inline_in_notification );
- C. apex_debug.info ('SAL for ' || :ENAME || ' increased by 1%.');
Answer: C
Explanation:
Explanation
APEX automation is a feature that allows you to automate tasks such as data loading, data synchronization, application export and import, and REST API calls by using declarative actions or PL/SQL code blocks. You can create automation tasks by using the Database Actions interface or by using the APEX_AUTOMATION package. To log messages to the execution log in APEX automation, you can use the APEX_DEBUG package with any of its logging levels (info, warning, error, etc.). The other options are not valid methods of logging messages in APEX automation. Verified References: [Using APEX Automation - Oracle Help Center],
[APEX_DEBUG - Oracle Help Center]
NEW QUESTION # 63
Which two statements are true about the APEX MAIL API?
- A. You can add files as attachments to your emails using the APEX_MAIL package.
- B. You can receive emails using the APEX_MAIL package in an Oracle APEX application
- C. The APEX_MAIL package supports sending emails only to Oracle database users.
- D. You can send emails using the APEX MAIL package from an Oracle APEX application.
Answer: A,D
Explanation:
Explanation
The APEX_MAIL package is an API for the APEX mail system that enables developers to send emails from PL/SQL code. Some of the statements that are true about the APEX_MAIL package are:
You can add files as attachments to your emails using the APEX_MAIL package. You can use the APEX_MAIL.ADD_ATTACHMENT procedure to add one or more files as attachments to your emails.
The files can be in various formats, such as PDF, DOCX, XLSX, etc.
You can send emails using the APEX_MAIL package from an Oracle APEX application. You can use the APEX_MAIL.SEND procedure or function to send an outbound email message from your application. You can also specify various parameters for your email, such as sender, recipients, subject, body, priority, etc. The APEX_MAIL package does not support sending emails only to Oracle database users or receiving emails in an Oracle APEX application. You can send emails to any valid email address or use other tools or services to receive emails. Verified References: [APEX_MAIL - Oracle Help Center], [APEX_MAIL : Send Emails from PL/SQL - ORACLE-BASE]
NEW QUESTION # 64
You have an interactive grid component and you are enabling the Save Public Report attribute. As what can end users save the report type?
- A. As Private and public only
- B. As Public only
- C. As Private only
- D. As Primary only
Answer: A
Explanation:
Explanation
When you enable the Save Public Report attribute for an interactive grid, end users can save their report preferences as either private or public reports. Private reports are only visible to the user who created them, while public reports are visible to all users who have access to the interactive grid. You can also specify an authorization scheme to control who can save public reports. Verified References: Managing Interactive Grids
- Oracle Help Center, [Interactive Grid Attributes - Oracle Help Center]
NEW QUESTION # 65
Which three of the following statements are TRUE about Faceted Search?
- A. The facets are displayed on the left and upper part of the screen
- B. You can create only 5 facets per page
- C. After the end user changes a facet, the results, dependent facets, and occurrence counts refresh immediately.
- D. The right side of the page features a Search Results region, which can display as a classic report or a cards report.
Answer: A,C,D
Explanation:
Explanation
A faceted search is a type of component that enables users to filter information easily and intuitively by selecting the options in each facet. A faceted search consists of a faceted search region and a search results region. The faceted search region displays on the left and upper part of the screen and shows possible values and occurrence counts for each facet. The search results region displays on the right side of the screen and shows the data that matches the selected facet values. The search results region can display as either a classic report or a cards report. Three of the statements that are true about faceted search are:
After the end user changes a facet, the results, dependent facets, and occurrence counts refresh immediately. This feature provides instant feedback to the user and allows them to refine their search criteria without reloading the page.
The right side of the page features a Search Results region, which can display as a classic report or a cards report. A classic report displays data in a tabular format with columns and rows. A cards report displays data in a grid of cards with images and text.
The facets are displayed on the left and upper part of the screen. This layout provides a clear separation between the facets and the results and allows users to see and access all the facets without scrolling.
NEW QUESTION # 66
There is a page with an interactive grid region based on this statement: SELECT EMPNO, ENAME, COMM from EMP; In the Interactive Grid attributes, under the Edit group, the Enabled switch is turned Off. Which are two of the actions that you must perform to make an employee's commission editable in the grid?
- A. Set EMPNO, ENAME to "Display Only".
- B. In the Interactive Grid attributes, select COMM for "Allowed Row Operations Column".
- C. Ensure that the "Primary Key" switch is turned "On" for the EMPNO column.
- D. In the Interactive Grid attributes, turn "On" the Enabled switch, under the Edit group.
Answer: C,D
Explanation:
Explanation
An interactive grid is a customizable report that allows end users to modify the data and layout of the report.
To make an employee's commission editable in the grid, you need to perform two actions:
In the Interactive Grid attributes, turn "On" the Enabled switch, under the Edit group. This enables editing for the entire interactive grid region and allows you to specify which columns are editable and which are not.
Ensure that the "Primary Key" switch is turned "On" for the EMPNO column. This identifies the EMPNO column as the primary key for the EMP table and allows APEX to perform DML operations on the table when end users edit the data in the grid. You do not need to set EMPNO or ENAME to
"Display Only" or select COMM for "Allowed Row Operations Column" to make an employee's commission editable in the grid. Verified References: [Managing Interactive Grids - Oracle Help Center], [Interactive Grid Attributes - Oracle Help Center]
NEW QUESTION # 67
Which two statements are true about the generated SQL?
- A. Inserts 10 rows of random sample data into the DEPARTMENTS table
- B. Creates EMPLOYEES table with 4 columns
- C. Creates DEPARTMENTS table with 2 columns
- D. Both DEPARTMENTS and EMPLOYEES tables will have a primary key in each and a foreign key relationship linking EMPLOYEES to DEPARTMENTS.
Answer: B,C
Explanation:
Explanation
The generated SQL script creates two tables: DEPARTMENTS and EMPLOYEES, with the specified columns and data types. It does not insert any data into the tables, nor does it create any primary or foreign keys. The script only creates the tables and their columns. References: Creating a Desktop Database Application and Using SQL Workshop
NEW QUESTION # 68
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. 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 )
; - B. An Invalid column definition error message will be displayed.
- 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 )
;
Answer: A
Explanation:
Explanation
The table creation script produced by Quick SQL is:
create table emp_salary ( id number generated by default on null as identity constraint emp_salary_id_pk primary key, name varchar2 (255 char) not null, salary number, commission_yn varchar2 (1 char) check (commission_yn in ('Y','N')) default 'N' not null ); The commission_yn column will default to 'N' because of the default clause in the column definition. It will also restrict acceptable values to 'Y' or 'N' because of the check constraint. The other options are incorrect because they do not match the output of Quick SQL. Verified References: Using Quick SQLAbout Quick SQL Shorthand Syntax
NEW QUESTION # 69
Choose the three correct statements about Charts in APEX.
- A. Each Oracle JET visualization supports animation, accessibility, responsive layout,internationalization, test automation, and a range of inter activity features.
- B. You can visualize data as bar, line, area, range, combination, scatter, bubble, polar, radar, pie, donut, funnel and more
- C. You can create charts without using Oracle JET
- D. Oracle APEX supports charts based on the Oracle JavaScript Extension Toolkit (Oracle JET) Data Visualizations.
Answer: A,B,D
Explanation:
Explanation
A chart is a type of component that enables users to visualize data in different ways and perform data analysis.
A chart can display data in various formats, such as bars, lines, areas, ranges, combinations, scatters, bubbles, polars, radars, pies, donuts, funnels, and more. Oracle APEX supports charts based on the Oracle JavaScript Extension Toolkit (Oracle JET) Data Visualizations. Oracle JET is a modular open source toolkit based on modern JavaScript, CSS3, and HTML5 design and development principles. Three of the correct statements about charts in Oracle APEX are:
You can visualize data as bar, line, area, range, combination, scatter, bubble, polar, radar, pie, donut, funnel and more. This statement is true because Oracle APEX provides a rich set of chart types that can be used to display data in different ways and support different analysis scenarios. You can choose from over 20 chart types when creating a chart in Oracle APEX.
Oracle APEX supports charts based on the Oracle JavaScript Extension Toolkit (Oracle JET) Data Visualizations. This statement is true because Oracle APEX uses Oracle JET as the underlying technology for rendering charts in the browser. Oracle JET provides high-performance and interactive data visualizations that are compatible with various devices and browsers.
Each Oracle JET visualization supports animation, accessibility, responsive layout, internationalization, test automation, and a range of inter activity features. This statement is true because Oracle JET offers many features and capabilities that enhance the user experience and functionality of the charts. For example:
Animation: Charts can have smooth transitions and effects when loading or updating data.
Accessibility: Charts can support keyboard navigation, screen reader compatibility, and high contrast mode for users with disabilities.
Responsive layout: Charts can adapt to different screen sizes and orientations by resizing or repositioning elements.
Internationalization: Charts can support different languages, date formats, number formats, and text directions for users from different regions.
Test automation: Charts can support automated testing tools and frameworks by providing unique identifiers for elements.
Interactivity: Charts can support user actions such as zooming, panning, filtering, selecting, drilling down, or popping up tooltips.
NEW QUESTION # 70
In a Classic Report, an end user can perform which two of the following actions?
- A. Create Control Breaks in the report
- B. Filter values of a column in the report
- C. Sort the columns of the report
- D. Rearrange the columns in the report
Answer: B,C
Explanation:
Explanation
In a Classic Report, an end user can perform the following actions:
Filter values of a column in the report by using the Search Bar. This bar allows the user to enter a search string and apply it to one or more columns in the report.
Sort the columns of the report by clicking on the column headers. This action toggles the sort order between ascending and descending for the selected column.
The other options are incorrect because:
Create Control Breaks in the report is not an action that an end user can perform in a Classic Report.
This action is only available in an Interactive Report by using the Control Break option in the Actions menu.
Rearrange the columns in the report is not an action that an end user can perform in a Classic Report.
This action is only available in an Interactive Grid by using the Reorder option in the Actions menu.
Verified References: [About Classic Reports] [Searching Classic Reports] [Sorting Classic Reports]
NEW QUESTION # 71
Which two are prerequisites to use the REST-enabled SQL feature in Oracle APEX?
- A. Install Oracle APEX in the remote Oracle Database.
- B. On the remote Oracle Database, install ORDS 19.x or later.
- C. Create a database link to the remote Oracle Database in the local APEX Schema.
- D. REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA.
Answer: B,D
Explanation:
Explanation
The REST-enabled SQL feature in Oracle APEX allows developers to execute SQL statements and PL/SQL blocks on a remote Oracle Database by using REST services. The prerequisites to use this feature are:
On the remote Oracle Database, install ORDS 19.x or later.
REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA.
Create a REST Data Source with REST Enabled SQL as the REST Data Source Type in Oracle APEX.
Create an Authorization Scheme based on the REST Data Source in Oracle APEX. You do not need to create a database link to the remote Oracle Database or install Oracle APEX in the remote Oracle Database to use this feature. Verified References: [Using REST Enabled SQL - Oracle Help Center],
[REST Enabled SQL Service - Oracle Help Center]
NEW QUESTION # 72
Which two statements are true about the Create Application Wizard?
- A. It allows application pages to be added or deleted.
- B. It allows the application authorization to be changed
- C. It allows application pages to be reordered.
- D. It allows the uploading of JavaScript or CSS files required for an application.
Answer: A,C
Explanation:
Explanation
The Create Application Wizard is a tool that allows developers to create a new application by following a series of steps. Some of the actions that you can perform using the Create Application Wizard are:
Reorder application pages. You can use the Reorder Pages option in the Pages step to change the order of the pages in your application by dragging and dropping them.
Add or delete application pages. You can use the Add Page or Delete Page options in the Pages step to add new pages or delete existing pages from your application. You can also use the Create Page Wizard to create additional pages after creating the application. You cannot upload JavaScript or CSS files required for an application or change the application authorization using the Create Application Wizard.
You can use other features in App Builder to perform these actions, such as Shared Components > User Interface > Files and Shared Components > Security > Authentication Schemes. Verified References:
[Creating an Application Using the Create Application Wizard - Oracle Help Center], [Create Application Wizard - Oracle APEX]
NEW QUESTION # 73
Choose the three Form types that you can create using the Create Page wizard.
- A. Form
- B. Master Detail
- C. Interactive Report
- D. Interactive Grid
Answer: A,B,D
Explanation:
Explanation
The Create Page wizard supports three form types that you can create: Interactive Grid, Form, and Master Detail4. An interactive grid is a report that allows users to view and edit data in a tabular format. A form is a page that enables users to update a single row in a database table or view. A master detail is a page that reflects a one-to-many relationship between two tables or views4. An interactive report is not a form type, but a report type that allows users to customize the report layout and filter data interactively5.
NEW QUESTION # 74
Choose the two statements that are TRUE about an Interactive Report. As a developer:
- A. You can customize the Actions menu to include or exclude certain options.
- B. You cannot modify the report source query
- C. You can modify the data in the report after running the app
- D. You can customize the pagination
Answer: C,D
NEW QUESTION # 75
......
Resources From:
- 2024 Latest ActualTestsIT 1Z0-770 Exam Dumps (PDF & Exam Engine) Free Share: https://2cram.actualtestsit.com/Oracle/1Z0-770-exam-prep-dumps.html
Free Resources from ActualTestsIT, We Devoted to Helping You 100% Pass All Exams!