Pass Your 1z1-770 Dumps as PDF Updated on 2023 With 144 Questions
Oracle 1z1-770 Real Exam Questions and Answers FREE
Oracle 1Z0-770 exam is a certification exam aimed at those who wish to become an Oracle APEX Developer Professional. As a professional in Oracle APEX development, you will be responsible for designing, developing, and deploying enterprise-level web applications using the Oracle Application Express (APEX) platform. 1z1-770 exam is an excellent way to demonstrate your skills and knowledge in this area, and it is highly regarded by employers who are seeking individuals who can effectively leverage the Oracle APEX platform.
Oracle APEX Developer Professional certification is a valuable credential in the IT industry. It is recognized globally and can help you stand out from other developers in the job market. It also demonstrates your commitment to continuous learning and professional development, which can be attractive to employers.
NEW QUESTION # 76
Consider a customers report. A customer name is clicked in the report to display the Customer Details form. When the items in the form dialog are updated and the user clicks Apply Changes, the page process is executed and the items from the page are used to update and commit the underlying table in the Oracle Database. What are the two types of events that occurred in this scenario?
- A. Page Validation
- B. Page Processing
- C. Page Refresh
- D. Page Rendering
Answer: A,B
Explanation:
Explanation
When the customer name is clicked in the report, the Customer Details form dialog page is displayed. This is a page rendering event, which means the page is generated and sent to the browser. When the items in the form dialog are updated and the user clicks Apply Changes, the page process is executed and the items from the page are used to update and commit the underlying table in the Oracle Database. This is a page processing event, which means the page is submitted to the server and processed by APEX. Page validation is also a part of page processing, but it is not a separate event. Page refresh is not an event, but an action that can be triggered by a dynamic action or a process
NEW QUESTION # 77
Using Data Workshop, you can perform which three tasks:
- A. Export vast amount of data from the database into a file
- B. Delete data from the database
- C. Load vast amount of data into the database
- D. Load data using various file formats such as XLSX, CSV, XML, and JSON
Answer: A,C,D
Explanation:
Explanation
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]
NEW QUESTION # 78
Which authentication scheme type supports authentication with social networks and enterprise identity providers that support OpenID Connect or OAuth2 standards?
- A. SAML Sign-In
- B. HTTP Header Variable
- C. Social Sign-In
- D. Open Door Credentials
Answer: C
Explanation:
Explanation
An authentication scheme is a rule that determines if a user is authorized to access a specific component or feature of an application, such as a page, region, button, item, etc. An authentication scheme type defines how users are authenticated when they access an application. The authentication scheme type that supports authentication with social networks and enterprise identity providers that support OpenID Connect or OAuth2 standards is Social Sign-In. Social Sign-In supports authentication with Google, Facebook, and other social networks that support these standards. The other authentication scheme types do not support authentication with social networks or enterprise identity providers. They are:
HTTP Header Variable: Authenticate users externally by storing the username in a HTTP Header variable set by the web server.
SAML Sign-In: Delegates authentication to the Security Assertion Markup Language (SAML) Sign In authentication scheme.
Open Door Credentials: Enable anyone to access your application using a built-in login page that captures a user name. Verified References: [Understanding Preconfigured Authentication Schemes - Oracle Help Center], [Social Sign-In - Oracle Help Center]
NEW QUESTION # 79
You created a custom theme for an application. Examine these requirements: 1. The theme must be utilized by another application in the same workspace. 2. The master theme may still require changes. Which solution guarantees that any changes to the master theme are reflected in the copied theme?
- A. Verifying the theme subscription
- B. Refreshing the templates
- C. Subscribing the copied theme to the master theme and refreshing the theme
- D. Copying the changes made in the master theme to the copied theme
Answer: C
Explanation:
Explanation
A theme is a collection of templates and stylesheets that define the layout and appearance of an application.
You can create a custom theme for an application by using the Create Theme Wizard or by copying an existing theme. If you want to use a custom theme for anotherapplication in the same workspace, you can copy the theme to that application by using the Copy Theme option in Shared Components. However, if the master theme (the original theme) may still require changes, you need to subscribe the copied theme to the master theme and refresh the theme whenever there are changes in the master theme. This solution guarantees that any changes to the master theme are reflected in the copied theme by using a synchronization process that updates templates and stylesheets based on their subscription status. Verified References: [Creating Themes - Oracle Help Center], [Managing Theme Subscriptions - Oracle Help Center]
NEW QUESTION # 80
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. An Invalid column definition error message will be displayed.
- B. 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 )
; - C. 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 )
;
Answer: C
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 # 81
Which two functions can be used by an end user when pivoting an interactive report?
- A. List aggregate
- B. Median
- C. Rank
- D. list aggregate
- E. Minimum
Answer: C,E
Explanation:
Explanation
When pivoting an interactive report, you can use different functions to aggregate or summarize the data in the pivot table. Some of the available functions are Minimum, Maximum, Average, Sum, Count, Median, and Rank. Minimum returns the smallest value in a set of values. Rank returns the rank of each value in a group of values. Verified References: 56
NEW QUESTION # 82
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 Primary only
- B. As Public only
- C. As Private only
- D. As Private and public only
Answer: D
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 # 83
Which two actions can you perform using the Object Browser?
- A. Export and import SQL scripts.
- B. Browse database objects of the current schema.
- C. Create and run SQL scripts.
- D. Create a lookup table based on a column in the current table.
- E. Restore dropped database objects.
Answer: B,D
Explanation:
Explanation
Object Browser is a utility in SQL Workshop that enables developers to browse, create, and edit objects in a database. Some of the actions that you can perform using Object Browser are:
Browse database objects of the current schema. You can view the details of an object by selecting it from the Object Tree and then clicking the different object detail tabs.
Create a lookup table based on a column in the current table. You can use the Create Lookup Table option in the Column Details tab to create a new table that stores the distinct values of the selected column and a foreign key constraint to reference it. You cannot restore dropped database objects, create and run SQL scripts, or export and import SQL scripts using Object Browser. You can use other utilities in SQL Workshop to perform these actions, such as Recycle Bin,SQL Commands, and SQL Scripts.
Verified References: [Managing Database Objects with Object Browser - Oracle Help Center], [Creating Lookup Tables - Oracle Help Center]
NEW QUESTION # 84
Which of the following options in the Developer Toolbar enables you to customize the look and feel of the application?
- A. Session
- B. Customize
- C. Quick Edit
- D. Debug
Answer: B
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 # 85
What are the three types of List of Values(LOV) you can create on a page?
- A. Static LOV
- B. Cascading LOV
- C. Popup LOV
- D. Dynamic LOV
Answer: A,B,D
Explanation:
Explanation
A list of values (LOV) is a definition that provides a set of display values and return values for a page item or a report column. A LOV can be created at the application level as a shared component or at the page level as a local component. There are three types of LOVs that you can create on a page:
Static LOV: A static LOV is based on a fixed list of display values and return values that you specify when you create the LOV. A static LOV does not change unless you edit it manually.
Cascading LOV: A cascading LOV is based on another parent LOV that determines the values of the child LOV. A cascading LOV changes dynamically depending on the selection made in the parent LOV.
Dynamic LOV: A dynamic LOV is based on a SQL query that returns display values and return values from the database. A dynamic LOV changes dynamically depending on the data in the database.
NEW QUESTION # 86
Which two statements are true about a Progressive Web Application (PWA)?
- A. Enabling the PWA functionality optimizes page loading speed on a mobile device.
- B. To use the PWA feature, the Friendly URLS attribute in the Application Definition, Properties section must be turned Off.
- C. PWA features will be rendered even if the application is served in an unsecured environment.
- D. You can create a PWA only when creating a new application with the Create Application Wizard.
- E. Enabling the PWA functionality in your APEX app adds a new navigation bar entry named Install App to your app.
Answer: A,E
Explanation:
Explanation
A 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 Functionality
NEW QUESTION # 87
Which two are true when the Edit option is NOT enabled for an Interactive Grid?
- A. The end user can customize the report
- B. The end user can edit the underlying data in the database
- C. The end user cannot create charts
- D. The end user cannot edit the underlying data in the database
Answer: A,D
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 # 88
Which two statements are true about creating and using dynamic actions?
- A. If a client-side condition is defined, the true action will fire when the condition is met, and the false action will fire when it is not
- B. If no client-side condition is defined, true actions will not fire.
- C. Once you create a dynamic action, you cannot add additional true actions.
- D. You can execute JavaScript code by creating a dynamic action.
Answer: A,D
Explanation:
Explanation
Dynamic actions are a declarative way to define client-side behavior without writing JavaScript code. You can create dynamic actions on an item, button, or region of a page by specifying the event, condition, affected elements, action, and other properties. Some of the statements that are true about creating and using dynamic actions are:
You can execute JavaScript code by creating a dynamic action. One of the supported action types is Execute JavaScript Code, which allows you to enter custom JavaScript code to run when the dynamic action fires.
If a client-side condition is defined, the true action will fire when the condition is met, and the false action will fire when it is not. You can define a client-side condition for a dynamic action to control when it should fire based on an expression or value. You can also define different actions for the true and false branches of the condition. You can add additional true actions to a dynamic action by clicking the Add True Action button in the Property Editor. If no client-side condition is defined, true actions will fire when the event occurs. Verified References: [Oracle Application Express 18: Creating Dynamic Actions], [Dynamic Action Enhancements in APEX 21.1 - Oracle Blogs]
NEW QUESTION # 89
You can create an APEX workspace and build APEX apps on which of the following platforms?
- A. Oracle Autonomous Cloud
- B. All of the above
- C. Microsoft Azure
- D. Oracle XE
- E. Amazon RDS
Answer: B
Explanation:
Explanation
You can create an APEX workspace and build APEX apps on any of the following platforms:
Oracle Autonomous Cloud: This is a cloud platform that provides various services such as Autonomous Database, Oracle Cloud Infrastructure, and Oracle APEX Application Development. You can create an APEX workspace and build APEX apps on an Autonomous Database instance or an APEX Service instance.
Oracle XE: This is a free edition of Oracle Database that supports up to 12 GB of user data. You can install Oracle XE on your local machine and use it to create an APEX workspace and build APEX apps.
Amazon RDS: This is a cloud service that provides managed relational databases. You can create an APEX workspace and build APEX apps on an Amazon RDS for Oracle instance that supports Oracle APEX.
Microsoft Azure: This is a cloud platform that provides various services such as virtual machines, storage, and networking. You can create an APEX workspace and build APEX apps on a Microsoft Azure VM that runs Oracle Database and Oracle APEX.
Verified References: Oracle Autonomous CloudOracle XEAmazon RDSMicrosoft Azure
NEW QUESTION # 90
Examine this code entered in Quick SQL:
emp_salary
name vc255
salary num
commission yn/check TRUE, FALSE
Which statement is true about the commission yn column?
- A. It will default to TRUE.
- B. It will default to FALSE.
- C. It will restrict acceptable values to Y or N.
- D. It will restrict acceptable values to TRUE or FALSE.
Answer: D
Explanation:
Explanation
The 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 Syntax
NEW QUESTION # 91
......
Pass Oracle 1z1-770 Exam Info and Free Practice Test: https://lead2pass.real4prep.com/1z1-770-exam.html