[Nov 09, 2024] 1Z0-770 Dumps Full Questions - Exam Study Guide
Oracle Database Free Certification Exam Material from PassExamDumps with 144 Questions
Oracle APEX Developer Professional certification exam is an important credential for professionals who use Oracle APEX to build and manage web applications. By taking 1Z0-770 exam, professionals can validate their skills and knowledge in using Oracle APEX and demonstrate their competency to employers and clients. 1Z0-770 exam covers a wide range of topics related to Oracle APEX, making it a comprehensive certification that creates experts in Oracle APEX development.
NEW QUESTION # 62
Choose the three types of page items that can be placed on a page.
- A. Global variable
- B. Select List
- C. Date Picker
- D. Checkbox
Answer: B,C,D
Explanation:
Explanation
A page item is a component that is part of an HTML form and can accept user input or display output. There are many types of page items that can be placed on a page in APEX, such as text fields, text areas, radio groups, checkboxes, date pickers, select lists, popup LOVs, shuttles, and so on. Each type of page item has different properties and attributes that affect its appearance and functionality. Three of the types of page items that can be placed on a page are:
Checkbox: A checkbox is a page item that displays one or more options that can be selected or deselected by the user. A checkbox can have either static values or dynamic values based on a list of values (LOV). A checkbox can also have different display styles, such as pill button or switch.
Date Picker: A date picker is a page item that displays a text field with an icon that opens a calendar popup when clicked. A date picker allows users to enter or select a date value in a specific format. A date picker can also have different attributes, such as minimum or maximum date, display format, or time picker.
Select List: A select list is a page item that displays a drop-down list of options that can be selected by the user. A select list can have either static values or dynamic values based on a list of values (LOV). A select list can also have different attributes, such as multiple selection, null value display text, or cascading LOV.
NEW QUESTION # 63
Which two among the following are TRUE about Low Code Apps?
- A. Expensive
- B. Not Mobile Friendly
- C. Provide Rich Functionality with Less Code
- D. Scalable
Answer: C,D
Explanation:
Explanation
Low Code Apps are applications that are developed using a low-code development platform such as Oracle APEX. Low Code Apps have the following characteristics:
Scalable: Low Code Apps can handle large volumes of data and users without compromising performance or reliability. They can also leverage the scalability features of the underlying database or cloud platform.
Provide Rich Functionality with Less Code: Low Code Apps can provide complex business logic, user interface, security, and integration features with minimal or no coding. They use declarative tools, visual editors, drag-and-drop components, and pre-built templates to speed up the development process.
The other options are incorrect because:
Not Mobile Friendly: Low Code Apps are mobile friendly by default. They use responsive design techniques to adapt to different screen sizes and orientations. They also support touch gestures, device features, and offline capabilities.
Expensive: Low Code Apps are not expensive to develop or maintain. They reduce the cost of development by requiring less time, resources, and skills. They also reduce the cost of maintenance by simplifying the deployment, testing, and debugging processes.
Verified References: [What is Low Code?] [Why Choose Oracle APEX?]
NEW QUESTION # 64
Which two of the following types can an end user save the customized Interactive report as?
- A. Default report
- B. A Public report
- C. Cannot save the report
- D. A private report
Answer: B,D
NEW QUESTION # 65
Which statement is true about creating and using a faceted search page?
- A. The Search Results region can be displayed as an interactive report.
- B. If you create a faceted search page on a view or a SQL query, the facets are auto-discovered.
- 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 a Classic Report or Cards.
Answer: D
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 # 66
Let's say that there are two select lists on a page. Making a selection in the DEPARTMENT select list, determines which individuals display in the Employees select list. This type of LOV is called:
- A. Cascading LOV
- B. Popup LOV
- C. Dynamic LOV
- D. Static LOV
Answer: A
Explanation:
Explanation
A cascading LOV is a type of list of values (LOV) that depends on another parent LOV to determine its values. For example, if there are two select lists on a page, one for DEPARTMENT and one for EMPLOYEES, you can create a cascading LOV for EMPLOYEES that only shows the employees who belong to the selected department in the DEPARTMENT select list. To create a cascading LOV, you need to specify the parent item name and use bind variables in the SQL query for the child item.
NEW QUESTION # 67
What three are the uses of Collections in APEX?
- A. You insert, update, and delete collection information using PL/SQL APIAPEX_COLLECTION.
- B. Collections enable you to store rows and columns in the current session into database tables
- C. Collections can be accessed, manipulated, or processed during a user's specific session.
- D. Use collections to temporarily capture one or more nonscalar Values.
Answer: A,C,D
Explanation:
Explanation
Collections are temporary tables that store session-specific data in memory. They can be used for various purposes in APEX applications. Some uses of collections are:
You insert, update, and delete collection information using PL/SQL API APEX_COLLECTION. This API provides several procedures and functions to manipulate collections and their members.
Use collections to temporarily capture one or more nonscalar values. For example, you can use collections to store the results of a query, the values of page items, or the selections of a report.
Collections can be accessed, manipulated, or processed during a user's specific session. For example, you can use collections to pass data between pages, perform calculations on collection members, or create reports based on collections.
Collections do not enable you to store rows and columns in the current session into database tables.
Collections are stored in memory and are not persistent across sessions.
NEW QUESTION # 68
Which of the following options in the Developer Toolbar enables you to customize the look and feel of the application?
- A. Customize
- B. Session
- C. Quick Edit
- D. Debug
Answer: A
Explanation:
Explanation
The Developer Toolbar is a component that appears at the bottom of every page in an Oracle APEX application when running in development mode. The Developer Toolbar provides quick access to various features and tools for developing and debugging an application. One of the options in the Developer Toolbar that enables developers to customize the look and feel of the application is Customize.
Customize: This option opens the Theme Roller tool that allows developers to modify the theme style of the application by changing colors, fonts, sizes, borders, shadows, and more. Developers can also create new theme styles or switch between existing ones using this option.
NEW QUESTION # 69
Which two statements are true about Faceted Search pages?
- A. Facets map to specific database columns.
- B. A facet's chart can be seen only in a nonmodal dialog.
- C. Multiple charts are not visible in the same region.
- D. Faceted Search supports the ability to filter columns storing multiple values as one string.
Answer: A,D
Explanation:
Explanation
Faceted Search is a feature 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. Faceted Search supports the ability to filter columns storing multiple values as one string, such as comma-separated values or JSON arrays, by using the Split Values attribute. Facets map to specific database columns or expressions that are defined in the Data Source attribute of the faceted search region. The other statements are false because Faceted Search supports displaying multiple charts in the same region by using the Chart View attribute, and a facet's chart can be seen either in a nonmodal dialog or inline by using the Chart Display Mode attribute. Verified References: [Creating Faceted Search Pages - Oracle Help Center], [Facet Attributes - Oracle APEX]
NEW QUESTION # 70
Which three statements are TRUE about Shared Components?
- A. Shared components are common elements that can be displayed or applied on any page within an application
- B. Breadcrumbs, Lists, and Navigation Bar entries are examples of shared components
- C. Once you create a Shared Component, you can add them to any page within an APEX application in any workspace.
- D. Once you create a Shared Component, you can add them to any page within your APEX application
Answer: A,B,D
Explanation:
Explanation
Shared components are common elements that can be displayed or applied on any page within an application.
Once you create a shared component, you can add them to any page within your APEX application. However, shared components are specific to each application and workspace, so you cannot add them to any page in any workspace4. Breadcrumbs, lists, and navigation bar entries are examples of shared components that can be used for navigation purposes4.
NEW QUESTION # 71
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. Drill down Master Detail
- B. Stacked Master Detail
- C. Editable Interactive Grid
- D. Side by Side Master Detail
Answer: A
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 # 72
In an Employee form, the 'Commission' and 'Hire Date' fields are enabled only if the Job is
'Salesman'. This can be achieved by which feature of APEX?
- A. Conditional SQL
- B. Dynamic Actions
- C. Processing
- D. PL/SQL procedure
Answer: B
Explanation:
Explanation
In an Employee form, the 'Commission' and 'Hire Date' fields are enabled only if the Job is 'Salesman'. This can be achieved by using Dynamic Actions in APEX. Dynamic Actions are declarative components that define client-side behavior without writing JavaScript code. You can create Dynamic Actions on items, buttons, or regions of a page by specifying an event, a condition, an action, and other properties. In this scenario, you can create a Dynamic Action on Job item with Change as event, Execute JavaScript Code as action, and use jQuery to enable or disable Commission and Hire Date fields based on Job value. Processing, Conditional SQL, and PL/SQL procedure are not features of APEX that can achieve this requirement without writing JavaScript code.
NEW QUESTION # 73
Which statement is true about using SQL Commands?
- A. You can unload data from the database.
- B. You can design and prototype data models using a markdown-like shorthand syntax.
- C. In SQL Commands, you can view queries saved in Query Builder.
- D. You can search and filter database objects.
Answer: A
Explanation:
Explanation
Commands allow you to execute SQL statements or PL/SQL blocks to create, edit, view, run, and delete database objects. One of the features of SQL Commands is the ability to unload data from the database to a CSV file. You can do this by clicking the Download button after running a query that returns data. Verified References: 34
NEW QUESTION # 74
Which statement is true about creating and using an interactive grid?
- A. End users cannot rearrange columns by dragging and dropping.
- B. An interactive grid supports Pivot View and Group By View features.
- C. For both editable and noneditable interactive grids, end users can change the report layout and create private reports.
Answer: C
Explanation:
Explanation
An interactive grid is a customizable report that allows end users to modify the data and layout of the report.
End users can change the report layout by using the Actions menu or by dragging and dropping columns. They can also create private reports that save their personal preferences for the report. These features are available for both editable and noneditable interactive grids. Verified References: Using an Interactive Grid - Oracle Help Center, Example Interactive Grid - Oracle Help Center
NEW QUESTION # 75
Which two are true when the Edit option is NOT enabled for an Interactive Grid?
- A. The end user can edit the underlying data in the database
- B. The end user cannot edit the underlying data in the database
- C. The end user can customize the report
- D. The end user cannot create charts
Answer: B,C
Explanation:
Explanation
An interactive grid is a component that displays data in a tabular format and allows users to perform various actions on the data, such as sorting, filtering, grouping, highlighting, and editing. However, the editing feature is optional and can be enabled or disabled by the developer. When the Edit option is not enabled for an interactive grid, the following statements are true:
The end user cannot edit the underlying data in the database. The interactive grid becomes read-only and does not allow users to add, modify, or delete rows. The Add Row and Save buttons are hidden from the toolbar and the cells are not editable.
The end user can customize the report. The interactive grid still allows users to change the appearance and behavior of the report using the Actions menu. Users can perform actions such as changing column order, resizing column width, hiding or showing columns, applying filters or highlights, creating control breaks or charts, and saving reports.
NEW QUESTION # 76
Which is a valid method of logging messages to the execution log in APEX automation?
- A. apex_debug.info ('SAL for ' || :ENAME || ' increased by 1%.');
- B. apex error.add error ( p_message => 'SAL for || :ENAME || increased by 1%.', p_display_location => apex_error.c_inline_in_notification );
- C. apex_automation.log_info('SAL for || :ENAME || increased by 18.');
Answer: A
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 # 77
Select two features of a Smart Filters Page.
- A. Consists of a single search field with filters at the top of the page and a report at the bottom
- B. Consists of filters at the left side and report on the right side of the page
- C. Each filter represents the text entered by the end user in the search field
- D. Each filter displays as a suggestion chip with a single count of how often the specific suggestion value occurs.
Answer: A,D
Explanation:
Explanation
A smart filters page is a type of component that features a single search field at the top of the page and a search results report (classic report, cards, map, or calendar) at the bottom. A smart filters page behaves similarly to faceted search, but it features a more space efficient layout. Two of the features of a smart filters page are:
Consists of a single search field with filters at the top of the page and a report at the bottom. This feature provides a simple and compact user interface that allows users to enter text in the search field and see suggested filters based on their input. Users can also see and modify applied filters at any time.
Each filter displays as a suggestion chip with a single count of how often the specific suggestion value occurs. This feature provides useful information to users about how many records match each filter value. Users can also choose between different types of suggestions, such as dynamic, static, or SQL query.
NEW QUESTION # 78
The Page Designer Toolbar allows you to perform which two of the following actions?
- A. Create a new page
- B. Delete the application
- C. Export the application
- D. Navigate to Shared Components
Answer: A,D
Explanation:
Explanation
The Page Designer Toolbar allows you to perform various actions related to the development of an APEX page. Two of the actions that you can perform are:
Navigate to Shared Components: This option lets you access the shared components of your application, such as lists, breadcrumbs, navigation menus, and so on. You can edit, create, or delete shared components from this option. To access this option, click the icon that resembles a puzzle piece on the Page Designer Toolbar.
Create a new page: This option lets you create a new page for your application using the Create Page Wizard. You can choose from different page types, such as blank page, form, report, chart, calendar, and so on. To access this option, click the icon that resembles a plus sign (+) on the Page Designer Toolbar.
NEW QUESTION # 79
In a Classic Report, an end user can perform which two of the following actions?
- A. Rearrange the columns in the report
- B. Create Control Breaks in the report
- C. Sort the columns of the report
- D. Filter values of a column in the report
Answer: C,D
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 # 80
Which client credentials are utilized for authentication during the One-Click Remote ApplicationDeployment process?
- A. PEX Developer credentials
- B. Database schema credentials
- C. APEX Workspace Admin credentials
Answer: C
Explanation:
Explanation
The One-Click Remote Application Deployment feature in Oracle APEX enables developers to deploy an application along with supporting object definitions to another workspace or to remote Oracle APEX instances. To use this feature, you need to provide the client credentials for authentication during the deployment process. The client credentials are utilized for authentication during the One-Click Remote Application Deployment process are the APEX Workspace Admin credentials. You can either specify an existing credential or create a new credential when you create a REST Enabled SQL reference in Shared Components. Optionally, you can create the credentials as empty credentials to prompt for client ID and client secret each time the REST Enabled SQL reference is used. Verified References: [Understanding One-Click Remote Application Deployment - Oracle Help Center], [Remote Deployment of your APEX App is just One Click Away! - Oracle Blogs]
NEW QUESTION # 81
You can create a report in which of the three following methods?
- A. Create a report from Object Browser
- B. Create a report when you create a new database application
- C. Create a report region on a page in an application
- D. Create a report as a new page in an application
Answer: B,C,D
Explanation:
Explanation
You can create a report in any of these three methods:
Create a report as a new page in an application by using the Create Page Wizard. This wizard guides you through the steps of selecting a page type, defining attributes, selecting a source (such as SQL query or table), and adding items or buttons.
Create a report when you create a new database application by using the Create Application Wizard.
This wizard allows you to generate one or more reports based on existing tables or views in your schema. You can also create a report and form on the same table or view.
Create a report region on a page in an application by using the Page Designer. This tool allows you to drag and drop a region type (such as Classic Report, Interactive Report, or Interactive Grid) onto the page and define its attributes and source.
The other option is incorrect because:
You cannot create a report from Object Browser. Object Browser is a tool that allows you to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can only run SQL queries or scripts from this tool, not create reports.
Verified References: [Creating Database Applications] [Creating Pages] [Creating Regions] [Using Object Browser]
NEW QUESTION # 82
Which two statements that are TRUE about charts in Interactive grid?
- A. Once a chart is created, you can switch the view between Grid and Chart view.
- B. To remove a chart, click the Remove Chart icon (X) adjacent to the chart filter
- C. Once the chart is created, it cannot be reconfigured.
- D. You can create multiple charts at a time in an interactive grid
Answer: A,B
Explanation:
Explanation
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
NEW QUESTION # 83
Choose from the below options the actions that can be performed when a button is clicked.
- A. Redirect to a page in a different application
- B. All of them
- C. Redirect to a URL
- D. Redirect to a page in the same application
- E. Submit Page
Answer: B
Explanation:
Explanation
A button is a component that performs an action when clicked by the user. A button can have different types, styles, icons, and labels. A button can also have different behaviors, such as submitting the page, redirecting to another page or URL, or doing nothing. A button can perform any of the following actions when clicked:
Redirect to a page in the same application: This action redirects the user to another page within the same APEX application. You can specify the target page number and optionally set some attributes, such as clear cache, request, and item values.
Redirect to a page in a different application: This action redirects the user to another page in a different APEX application. You can specify the target application ID and page number and optionally set some attributes, such as clear cache, request, and item values.
Redirect
to a URL: This action redirects the user to a custom URL that you specify. You can use any valid URL format, such as http://, https://, mailto:, or javascript:.
Submit Page: This action submits the current page to the server and performs any validations, computations, processes, or branches that are defined for the page. You can also specify a request value for the button that can be used to conditionally execute some components.
Defined by Dynamic Action: This action does not submit the page or redirect to another page. Instead, the button's behavior is defined by a dynamic action thatis associated with the button. A dynamic action is a declarative way of defining client-side behavior based on user actions or events.
NEW QUESTION # 84
When you click a Customer Name in the Customers report, the Customer Details form dialog page is displayed. What are the events that occur in this scenario?
- A. Page compilation
- B. Page Rendering
- C. Page Processing
- D. Page rendering and processing
Answer: D
Explanation:
Explanation
When you click a Customer Name in the Customers report, the Customer Details form dialog page is displayed. This involves two events: page rendering and page processing. Page rendering is the event that occurs when APEX generates and sends the page to the browser. Page processing is the event that occurs when APEX receives and processes the page from the browser. In this scenario, both events happen because the Customer Details form dialog page is a modal dialog that uses AJAX to communicate with the server without reloading the entire page. Page compilation is not an event, but an action that occurs when APEX compiles an application or a page before running it.
NEW QUESTION # 85
When you create an Access Control Page, which three of the following Access Roles get created?
- A. Contributor
- B. Administrator
- C. Reader
- D. Developer
Answer: A,B,C
Explanation:
Explanation
When you create an Access Control Page using the Create Page Wizard, three of the following Access Roles get created: Reader, Administrator, and Contributor. These roles are predefined by APEX and correspond to the authorization schemes that control the access to the application, pages, or page components1. Reader role grants read-only access to the application. Administrator role grants full access to the application, including administrative and edit privileges. Contributor role grants edit privileges to the application, but not administrative privileges2. Developer role is not a default Access Role created by the wizard, but you can create your own custom roles and assign them to users on the Application Access Control page.
NEW QUESTION # 86
......
Oracle 1Z0-770 certification exam is a professional-level examination designed for individuals who want to validate their expertise in Oracle Application Express (APEX) development. 1Z0-770 exam is an essential certification for professionals who want to stand out in the highly competitive field of Oracle database technology. By passing 1Z0-770 exam, professionals can easily demonstrate their proficiency in the latest technologies and programming methodologies used in Oracle APEX development.
Dumps Brief Outline Of The 1Z0-770 Exam: https://www.passexamdumps.com/1Z0-770-valid-exam-dumps.html
Use Real 1Z0-770 - 100% Cover Real Exam Questions: https://drive.google.com/open?id=1jpdYhhozx2omhjmKJb2_7iwmF-cyAsBo
