This page was exported from Free Exams Dumps Materials [ http://exams.dumpsmaterials.com ] Export date:Thu Nov 21 9:52:10 2024 / +0000 GMT ___________________________________________________ Title: Oracle 1Z0-770 Exam Prep Guide Prep guide for the 1Z0-770 Exam [Q35-Q53] --------------------------------------------------- Oracle 1Z0-770 Exam Prep Guide: Prep guide for the 1Z0-770 Exam 2024 New Preparation Guide of Oracle 1Z0-770 Exam Q35. Examine this code entered in Quick SQL:emp_salaryname vc255salary numcommission yn/check TRUE, FALSEWhich statement is true about the commission yn column?  It will default to FALSE.  It will restrict acceptable values to TRUE or FALSE.  It will default to TRUE.  It will restrict acceptable values to Y or N. ExplanationThe commission yn column will restrict acceptable values to TRUE or FALSE because of the /check modifier in the column name. This modifier adds a check constraint to the column based on the values specified after it.The yn suffix indicates that the column is of type VARCHAR2(1). The other options are incorrect because they do not reflect the effect of the /check modifier or the yn suffix. Verified References: Using Quick SQLAbout Quick SQL Shorthand SyntaxQ36. Which two actions enable “hide and show” behavior of a data series in a bar chart when its corresponding legend item is clicked?  Setting the on Data Change attribute value to slide to Left  Setting the Hide and Show Behavior attribute value to Rescale  Setting the Hide and Show Behavior attribute value to None  Setting the Hide and Show Behavior attribute value to No Rescaling ExplanationA bar chart is a type of chart that displays data as horizontal or vertical bars with lengths proportional to the values they represent. A bar chart can have one or more data series, which are groups of data points that share the same color and legend item. To enable “hide and show” behavior of a data series in a bar chart when its corresponding legend item is clicked, you need to set the Hide and Show Behavior attribute value to either Rescale or No Rescaling. The Hide and Show Behavior attribute determines how the chart behaves when a data series is hidden or shown by clicking on its legend item. The possible values are:None: The chart does not support hiding or showing data series by clicking on legend items.Rescale: The chart supports hiding or showing data series by clicking on legend items, and rescales the axes accordingly.No Rescaling: The chart supports hiding or showing data series by clicking on legend items, but does not rescale the axes. Setting the on Data Change attribute value to slide to Left will not affect the “hide and show” behavior of a data series in a bar chart. This attribute determines how the chart behaves when new data is loaded, such as when using dynamic actions or refresh actions. The possible values are:None: The chart does not animate when new data is loaded.Slide to Left: The chart slides to the left when new data is loaded.Slide to Right: The chart slides to the right when new data is loaded. Verified References: [Creating Bar Charts – Oracle Help Center], [Bar Chart Attributes – Oracle Help Center]Q37. Which three of the following statements are TRUE about saved Public Interactive Grids?  Public reports are available to all users  To enable an end user to save a public interactive grid, the user must have the required permission  Any user may save public interactive grids  Only the user who creates a public interactive grid can save, rename, or delete it ExplanationPublic reports are available to all users who can access the interactive grid1. However, to enable an end user to save a public interactive grid report, the user must have the required permission. By default, only developers can save public reports1. Any user may save private interactive grid reports, but only the user who creates a private report can view, save, rename, or delete it12. Verified References: 12Q38. Which two statements are true about the usage of a Remote Server in the context of REST Data Sources?  The remote server determines the base URL of the REST Data Source.  The remote server should mandatorily be an APEX instance.  Multiple REST Data Sources can reference a single remote server.  A single REST Data Source can use multiple remote servers. ExplanationA remote server in the context of REST Data Sources is a configuration that defines how to connect to an external server that hosts one or more REST services. The remote server determines the base URL of the REST Data Source, which is used to construct the full URL of each REST operation. Multiple REST Data Sources can reference a single remote server, which simplifies the maintenance and security of accessing external REST services. Verified References: Managing Remote Servers – Oracle Help Center, Creating REST Data Sources – Oracle Help CenterQ39. Choose the three different ways in which you can add a checkbox to a page.  Drag and drop the checkbox item into the Layout pane  Right click Body in the Rendering Tree and add a New Page Item as Checkbox Type.  Use the context sensitive menu in the Gallery pane.  Add a checkbox from the Property Editor ExplanationThere are three different ways in which you can add a checkbox to a page in APEX:Drag and drop the checkbox item into the Layout pane: In Page Designer, you can drag and drop items from the Gallery pane into the Layout pane to create them on your page. To create a checkbox item, expand the Items node in the Gallery pane and drag and drop Checkbox into the Layout pane.Right click Body in the Rendering Tree and add a New Page Item as Checkbox Type: In Page Designer, you can right click any node in the Rendering tree andselect Create to create a new component under that node. To create a checkbox item under the Body node, right click Body and select Create > New Page Item > Checkbox.Use the context sensitive menu in the Gallery pane: In Page Designer, you can use the context sensitive menu in the Gallery pane to create items on your page. To create a checkbox item using this method, expand the Items node in the Gallery pane and right click Checkbox. Then select Create Checkbox.Q40. Which three are the main components of APEX workspace homepage?  Gallery  RESTful Services  SQL Workshop  App Builder ExplanationThe main components of an APEX workspace homepage are:Gallery: This component displays various sample applications, blueprints, plug-ins, themes, and learning resources that you can use to get started with Oracle APEX.SQL Workshop: This component allows you to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can also use this component to run SQL queries or scripts, load or unload data from the database, generate DDL statements, view object reports, and restore dropped objects.App Builder: This component allows you to create and edit your applications using the Create Application Wizard or the Page Designer. You can also use this component to import or export applications from files or URLs, run or debug applications, manage application settings, and access various utilities.The other option is incorrect because:RESTful Services: This component is not part of the APEX workspace homepage. It is part of the SQL Workshop component. It allows you to create and manage RESTful web services based on your database objects or SQL queries.Verified References: [About the Workspace Home Page] [About SQL Workshop] [About App Builder]Q41. Which three of the following options are TRUE about a page in an APEX application?  A page can contain buttons, page items and regions.  An APEX application can have only one page.  To view the rendered version of the page, you run or submit it to the Oracle APEX engine.  A page can be viewed and edited in the Page Designer. Q42. Which statement is true about session state management in Oracle APEX?  A user cannot run multiple instances of an application simultaneously in different browser programs.  APEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests.  Multiple number of sessions cannot exist in the database at the same time ExplanationSession state management is a feature that enables developers to store and retrieve values for a user as the user navigates between different application pages. A session is a logical construct that establishes persistence (or stateful behavior) across page views. Each session is assigned a unique identifier (or session ID). The statement that is true about session state management in Oracle APEX is:APEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests. APEX Sessions are stored in memory within an Application Express engine process while Oracle database sessions are stored in memory within an Oracle database process. The other statements are false because:A user can run multiple instances of an application simultaneously in different browser programs by using different session IDs.Multiple number of sessions can exist in the database at the same time for different users or applications.Verified References: [Understanding Session State Management – Oracle Help Center], [What Is a Session? – Oracle Help Center]Q43. Which two statements are TRUE about Dynamic Actions?  More dynamic actions you add to a page, the greater your overall page size.  It is not possible to debug Dynamic Actions from the Developer Toolbar  Dynamic actions provide a way to define complex client-sidebehaviordeclaratively without the need for JavaScript.  Dynamic Actions require complex client side Javascript code ExplanationDynamic actions provide a way to define complex client-side behavior declaratively without the need for JavaScript. You can create dynamic actions on items, buttons, or regions of a page by specifying an event, a condition, an action, and other properties1. However, more dynamic actions you add to a page, the greater your overall page size. This can affect the performance and user experience of your application2. It is possible to debug dynamic actions from the Developer Toolbar by using the Debug option3. Dynamic actions do not require complex client-side JavaScript code, but they can optionally include custom JavaScript code as an action or a condition1.Q44. In your APEX application, you want to have an orderly grid layout of information tiles. Which page type should you choose in the Create Page Wizard?  Master Detail  Cards  Interactive Grid  Unified Task List ExplanationCards are a page type that display information in a grid layout of tiles. Each card can contain an image, a title, a subtitle, and an optional link. Cards are suitable for presenting summary or overview information in an attractive and compact way1 Verified References: 1: Understanding Page Types, Features, and Settings – Oracle Help CenterQ45. Which statement is true about the Data Workshop utility?  The wizards load and unload table data only.  You cannot load data from an XLSX file with multiple worksheets.  The wizards load and unload all types of schema objects.  You can load or unload multiple tables at a time. ExplanationData Workshop is a utility in SQL Workshop that enables developers to load and unload data to and from the database. The wizards load and unload table data only. They do not load or unload other kinds of schema objects. You can load data from an XLSX file with multiple worksheets by selecting the worksheet name in the Load Data Wizard. You can load or unload only a single table at a time using the wizards. Verified References: [Using Data Workshop – Oracle Help Center], [Loading Data – Oracle Help Center]Q46. 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?  Create a dynamic action on form load.  Create a dynamic action on P2_JOB, P2_HIREDATE, and P2_COMM.  Create a dynamic action on P2_JOB.  Create a dynamic action on P2_HIREDATE and P2_COMM.  ……… and enter SALESMAN for Value. ExplanationTo extend the functionality of the form as required, you need to create a dynamic action on P2_JOB that shows or hides P2_HIREDATE and P2_COMM based on its value. The steps are as follows:Create a dynamic action on P2_JOB by right-clicking it in Page Designer and selecting Create Dynamic Action.Set Name to Show/Hide Hire Date and Commission.Set Event to Change.Set Selection Type to Item(s).Set Item(s) to P2_JOB.Set Condition Type to Equal To.Set Value to SALESMAN.Add two true actions by clicking the Add True Action button twice.For the first true action, set Action to Show.Set Affected Elements > Selection Type to Item(s).Set Affected Elements > Item(s) to P2_HIREDATE,P2_COMM.For the second true action, set Action to Show.Set Fire On Initialization to Yes.Set Affected Elements > Selection Type to jQuery Selector.Set Affected Elements > jQuery Selector to label[for=”P2_HIREDATE”],label[for=”P2_COMM”].Add two false actions by clicking the Add False Action button twice.For the first false action, set Action to Hide.Set Affected Elements > Selection Type to Item(s).Set Affected Elements > Item(s) to P2_HIREDATE,P2_COMM.For the second false action, set Action to Hide.Set Fire On Initialization to Yes.Set Affected Elements > Selection Type to jQuery Selector.Set Affected Elements > jQuery Selector to label[for=”P2_HIREDATE”],label[for=”P2_COMM”].This dynamic action will show or hide both the page items and their labels depending on whether P2_JOB is equal to SALESMAN or not. Verified References: [Creating a Dynamic Action in Oracle Apex – OrclQA.Com], [Managing Dynamic Actions – Oracle Help Center]Q47. Which two statements are true about the APEX MAIL API?  You can add files as attachments to your emails using the APEX_MAIL package.  You can send emails using the APEX MAIL package from an Oracle APEX application.  The APEX_MAIL package supports sending emails only to Oracle database users.  You can receive emails using the APEX_MAIL package in an Oracle APEX application ExplanationThe 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]Q48. Which statement is true about creating and using a faceted search page?  If you create a faceted search page on a view or a SQL query, the facets are auto-discovered.  If you create a faceted search page based on a table, the facets are not auto-discovered.  The Search Results region can be displayed as a Classic Report or Cards.  The Search Results region can be displayed as an interactive report. ExplanationA 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]Q49. Which two statements are true about a Progressive Web Application (PWA)?  To use the PWA feature, the Friendly URLS attribute in the Application Definition, Properties section must be turned Off.  Enabling the PWA functionality optimizes page loading speed on a mobile device.  Enabling the PWA functionality in your APEX app adds a new navigation bar entry named Install App to your app.  PWA features will be rendered even if the application is served in an unsecured environment.  You can create a PWA only when creating a new application with the Create Application Wizard. ExplanationA Progressive Web Application (PWA) is a web application that uses modern web technologies and best practices to provide a native app-like experience to users. Enabling the PWA functionality in your APEX app has the following benefits:It optimizes page loading speed on a mobile device by caching static resources and using service workers to handle network requests.It adds a new navigation bar entry named Install App to your app, which allows users to install the app on their device’s home screen and access it offline.It enhances the app’s appearance and behavior by using a manifest file to specify the app’s name, icon, theme color, orientation, and display mode.The other options are incorrect because:To use the PWA feature, the Friendly URLS attribute in the Application Definition, Properties section must be turned On. This attribute enables user-friendly URLs that are required for PWA functionality.PWA features will not be rendered if the application is served in an unsecured environment. The application must use HTTPS protocol to enable PWA functionality.You can create a PWA from an existing application or a new application with the Create Application Wizard. You just need to enable the PWA functionality in the User Interface section of the Application Definition.Verified References: Progressive Web ApplicationsEnabling Progressive Web Application FunctionalityQ50. When a button is pressed, an overlay window is positioned within the viewport. What kind ofpage mode is it?  Help Page  Modal Dialog  Normal Page  Non-Modal Dialog ExplanationA modal dialog is a type of page mode that displays an overlay window within the viewport when a button is pressed. A modal dialog is a stand-alone page that does not interact with the base page where it was launched.A modal dialog blocks access to the base page until it is closed by the user. A modal dialog can be used for various purposes, such as displaying additional information, confirming an action, or collecting user input.Q51. When you run an application, the APEX engine relies on which two processes?  Show Page  Run Page  Validate Page  Accept page ExplanationWhen you run an application, the APEX engine relies on two processes: Show Page and Accept Page. Show Page is responsible for rendering the page and sending it to the browser. Accept Page is responsible for processing the page when it is submitted by the browser. Run Page is not a process, but a command that can be used to run an application or a page from SQLWorkshop or Application Builder. Validate Page is not a process, but a step that occurs during page processing to check for any validations defined on the pageQ52. When you create an Access Control Page, which three of the following Access Roles get created?  Developer  Reader  Administrator  Contributor ExplanationWhen 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.Q53. Which two statements are true about creating and customizing Smart Filters pages?  If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache.  The search results report can be displayed as an interactive report.  The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types.  The search results report can be displayed as an interactive grid ExplanationSmart Filters is a component that allows end users to filter data by typing keywords in a single search field.Some of the statements that are true about creating and customizing Smart Filters pages are:If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache. You can also manually add or remove filters as needed.The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types. For other filter types, such as Input or Range, the count is not displayed. The search results report cannot be displayed as an interactive report or an interactive grid. The supported report types are Classic Report, Cards, Map, or Calendar. Verified References: [Managing Smart Filters – Oracle Help Center],[Creating Smart Filters Using the Create Page Wizard – Oracle Help Center] Loading … Latest Questions 1Z0-770 Guide to Prepare Free Practice Tests: https://www.dumpsmaterials.com/1Z0-770-real-torrent.html --------------------------------------------------- Images: https://exams.dumpsmaterials.com/wp-content/plugins/watu/loading.gif https://exams.dumpsmaterials.com/wp-content/plugins/watu/loading.gif --------------------------------------------------- --------------------------------------------------- Post date: 2024-03-16 11:08:09 Post date GMT: 2024-03-16 11:08:09 Post modified date: 2024-03-16 11:08:09 Post modified date GMT: 2024-03-16 11:08:09