[2023] Practice with these 1Z0-770 dumps Certification Sample Questions
Get Instant Access of 100% REAL 1Z0-770 DUMP Pass Your Exam Easily
Oracle 1Z0-770 (Oracle APEX Developer Professional) Certification Exam is a valuable certification for developers working with Oracle Application Express. 1Z0-770 exam tests the candidate's knowledge of APEX development and validates their skills in designing and developing APEX applications. Earning the certification can lead to career advancement opportunities and demonstrate a commitment to professional development.
Oracle 1Z0-770 certification exam is an excellent way for experienced APEX developers to enhance their skills and demonstrate their expertise. It is a highly valued certification in the industry and can lead to better job opportunities and higher salaries. To prepare for the exam, candidates must have a deep understanding of APEX architecture, SQL and PL/SQL, and experience developing applications using APEX.
NEW QUESTION # 65
Which statement is true about creating and using a report with form?
- A. The Create Page Wizard doesn't support the creation of a classic report and formcombination
- B. In the Create Application Wizard, you can select a data source (that is, Local Database, REST Enabled SQL Service, or REST Data Source).
- C. Both the Create Application Wizard and Create Page Wizard support the creation of an interactive report or classic report and form combination.
- D. The Create Application Wizard doesn't support the creation of an interactive report and form combination.
Answer: C
Explanation:
Explanation
You can create a report with form in Oracle APEX by using either the Create Application Wizard or the Create Page Wizard. The report can be either an interactive report or a classic report, and the form can be either a single row form or a multi row form. The report with form combination enables you to view and edit data from a table or a query in a single page. You can also customize the report and form attributes, such as the columns, regions, buttons, validations, processes, and so on. Verified References: [Creating a Report Using the Create Page Wizard - Oracle], [Creating a Report with Form on Table - Oracle]
NEW QUESTION # 66
Choose the three correct options in the given friendly URL syntax:
https://example.com:5500/ords/r/mycompany/hr-app/updateemployees?
- A. update-employees is the PL/SQL procedure to update the employee details.
- B. 13766599855150 is the session ID. A new ID is generated for each session.
- C. session=13766599855150 Ahr-app is the application alias.
- D. mycompany is the path-prefix which is by default the workspace name
Answer: B,C,D
Explanation:
Explanation
The friendly URL syntax
https://example.com:5500/ords/r/mycompany/hr-app/updateemployees?session=13766599855150 has the following components:
session=13766599855150 is the session ID. A new ID is generated for each session. This parameter identifies which session is associated with the request.
hr-app is the application alias. This parameter identifies which application is being requested. An application alias is a user-friendly name that can be used instead of an application ID.
mycompany is the path-prefix which is by default the workspace name. This parameter identifies which workspace is being requested. A path-prefix is a URL segment that can be used instead of a workspace ID.
updateemployees is the page alias. This parameter identifies which page is being requested. A page alias is a user-friendly name that can be used instead of a page number.
The other option is incorrect because:
update-employees is not the PL/SQL procedure to update the employee details. It is the page alias that identifies which page is being requested.
Verified References: [About Friendly URLs] [Understanding URL Syntax]
NEW QUESTION # 67
Which statement is true about importing an APEX application?
- A. You cannot change the application ID during the import process.
- B. You cannot import an APEX application exported from a latest APEX version to an old APEX version.
- C. The import process does not import the supporting objects defined during the export.
Answer: B
Explanation:
Explanation
As a general rule, you cannot import an application created in a newer release of APEX into an earlier version.
This is because the newer release may have features or attributes that are not supported or recognized by the older version. For example, you cannot import an application created in APEX 21.2 into APEX 19.2.
However, you can import an application created in an older release into a newer one, as long as the application is compatible with the newer release. For example, you can import an application created in APEX 18.2 into APEX 21.2, but you may need to upgrade or modify some components to use the latest features.
NEW QUESTION # 68
The Page Designer Toolbar allows you to perform which two of the following actions?
- A. Create a new page
- B. Navigate to Shared Components
- C. Export the application
- D. Delete the application
Answer: A,B
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 # 69
In APEX, you can choose which three of the following Authentication methods?
- A. Custom Authentication Scheme
- B. No Authentication
- C. Authorization Scheme
- D. Built-in Authentication Scheme
Answer: A,B,D
Explanation:
Explanation
In Oracle APEX, you can choose from different authentication methods to establish a user's identity and control access to your application. Authentication may require a user to provide some type of credentials, such as a user name and password, or could involve the use of digital certificates or a secure key. Three of the authentication methods that you can choose in Oracle APEX are:
Custom Authentication Scheme: This method allows you to create your own authentication logic using PL/SQL code or an external web service. You can also customize the login page and session management for your application.
No Authentication (using DAD): This method adopts the current database user as the authenticated user.
This approach can be used in combination with a mod_plsql Database Access Descriptor (DAD) configuration that uses basic authentication to set the database session user.
Built-in Authentication Scheme: This method allows you to use one of the preconfigured authentication schemes that ship with Oracle APEX, such as Open Door Credentials, LDAP Directory, Social Sign-In, and so on.
NEW QUESTION # 70
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 Refresh
- B. Page Rendering
- C. Page Validation
- D. Page Processing
Answer: C,D
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 # 71
Which two are true about Oracle APEX?
- A. Requires no additional client software. A web browser is the app development IDE.
- B. Performs the data processing in a middle-tier server
- C. Requires developers to be proficient in Java, Python and other programming languages.
- D. Is declarative. It requires no code generation.
Answer: A,D
Explanation:
Explanation
Oracle APEX is a low-code development platform that enables you to build database-centric web applications using only a web browser. Oracle APEX has the following features:
Requires no additional client software. A web browser is the app development IDE: You can use any modern web browser to access the Oracle APEX development environment and build your applications.
You do not need to install or configure any additional software or tools on your client machine.
Is declarative. It requires no code generation: You can use declarative tools, visual editors, drag-and-drop components, and pre-built templates to define your application logic, user interface, security, and integration features. You do not need to write or generate any code for your applications.
The other options are incorrect because:
Performs the data processing in a middle-tier server: Oracle APEX performs the data processing in the database server. It uses SQL and PL/SQL to access and manipulate the data stored in the database. It does not rely on any middle-tier server or framework for data processing.
Requires developers to be proficient in Java, Python and other programming languages: Oracle APEX does not require developers to be proficient in Java, Python or other programming languages. It uses SQL and PL/SQL as the primarylanguages for data processing. It also supports HTML, CSS, JavaScript, and jQuery for user interface development.
Verified References: [About Oracle APEX] [Oracle APEX Architecture]
NEW QUESTION # 72
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. Rearrange the columns in the report
- D. Sort the columns of the report
Answer: B,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 # 73
Which three of the following options are TRUE about a page in an APEX application?
- A. A page can be viewed and edited in the Page Designer.
- B. A page can contain buttons, page items and regions.
- C. An APEX application can have only one page.
- D. To view the rendered version of the page, you run or submit it to the Oracle APEX engine.
Answer: A,B,D
NEW QUESTION # 74
Which two statements are TRUE about Dynamic Actions?
- A. It is not possible to debug Dynamic Actions from the Developer Toolbar
- B. Dynamic Actions require complex client side Javascript code
- C. Dynamic actions provide a way to define complex client-sidebehaviordeclaratively without the need for JavaScript.
- D. More dynamic actions you add to a page, the greater your overall page size.
Answer: C,D
Explanation:
Explanation
Dynamic 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.
NEW QUESTION # 75
What three are the result of the following QuickSQL shorthand notation do?
departments /insert 4
name /nn
location
country
- A. Inserts 4 rows of random data into the departments table
- B. Create the departments table with 3 columns
- C. Creates an id column as a primary key
- D. Create the departments table with 4 columns
Answer: A,C,D
Explanation:
Explanation
The QuickSQL shorthand notation departments /insert 4 name /nn location country will do the following:
Create the departments table with 4 columns: The first word in the notation is the table name, followed by a slash and the number of rows to insert. The subsequent words are the column names, separated by spaces. QuickSQL will generate a SQL script to create the table with the specified columns and data types.
Creates an id column as a primary key: QuickSQL will automatically add an id column as a primary key to the table, unless the /no_pk modifier is used. The idcolumn will be of type NUMBER and will use an identity constraint to generate unique values.
Inserts 4 rows of random data into the departments table: QuickSQL will use the /insert modifier to insert random data into the table, based on the column names and data types. The number after the modifier indicates how many rows to insert.
The other option is incorrect because:
Create the departments table with 3 columns: This is not what the notation will do. The notation will create the table with 4 columns, not 3.
Verified References: [Using Quick SQL] [About Quick SQL Shorthand Syntax]
NEW QUESTION # 76
When you create an Access Control Page, which three of the following Access Roles get created?
- A. Administrator
- B. Reader
- C. Contributor
- 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 # 77
When a button is pressed, an overlay window is positioned within the viewport. What kind ofpage mode is it?
- A. Modal Dialog
- B. Non-Modal Dialog
- C. Normal Page
- D. Help Page
Answer: A
Explanation:
Explanation
A 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.
NEW QUESTION # 78
You added Access Control feature pages to your application. Which two actions can you perform as an Administrator using the Administration page?
- A. Add Users
- B. Create Authorization schemes
- C. Assign roles to users
- D. Create new application roles
Answer: A,C
Explanation:
Explanation
The Access Control feature pages are a set of pages that allow developers to implement role-based access control for an application. The Access Control feature pages consist of four pages: Administration, Users, Roles, and Role Assignments. The Administration page allows administrators to perform various tasks related to managing users and roles, such as:
Add Users: Administrators can add new users to the application by entering their username, email address, password, status, etc.
Assign roles to users: Administrators can assign one or more roles to users by selecting them from a list of available roles.
Edit Users: Administrators can edit user details such as username, email address, password, status, etc.
Delete Users: Administrators can delete users from the application by selecting them from a list of existing users.
Lock/Unlock Users: Administrators can lock or unlock users by changing their status from active to locked or vice versa. You cannot create authorization schemes or create new application roles using the Administration page. You can create authorization schemes by using Shared Components > Security > Authorization Schemes. You can create new application roles by using Shared Components > Security > Access Control > Roles. Verified References: [Using Access Control - Oracle Help Center], [Creating an Administration Page - Oracle Help Center]
NEW QUESTION # 79
To create a Dynamic Action, you need to specify which three of the following options?
- A. When the action occurs
- B. What elements are affected by the action
- C. Why the action is performed
- D. What action or actions are performed
Answer: A,B,D
Explanation:
Explanation
To create a dynamic action, you need to specify at least three options: what action or actions are performed, when the action occurs, and what elements are affected by the action1. The action is the behavior that you want to happen when the event is triggered. You can choose from a list of predefined actions or create your own custom action using JavaScript code1. The event is the user interaction or condition that causes the dynamic action to fire. You can select an event from a list of available events based on the type of element you select1. The affected elements are the items, buttons, or regions that are affected by the action. You can select one or more elements by using jQuery selectors1. You do not need to specify why the action is performed, as this is not a required option for creating a dynamic action.
NEW QUESTION # 80
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. Restore dropped database objects.
- D. Create and run SQL scripts.
- E. Create a lookup table based on a column in the current table.
Answer: B,E
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 # 81
Which two statements are true about a Progressive Web Application (PWA)?
- A. To use the PWA feature, the Friendly URLS attribute in the Application Definition, Properties section must be turned Off.
- B. Enabling the PWA functionality in your APEX app adds a new navigation bar entry named Install App to your app.
- C. Enabling the PWA functionality optimizes page loading speed on a mobile device.
- D. You can create a PWA only when creating a new application with the Create Application Wizard.
- E. PWA features will be rendered even if the application is served in an unsecured environment.
Answer: B,C
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 # 82
Which two feature pages can you create using the Create Page Wizard?
- A. Feedback
- B. Access Control
- C. Unified Task List
- D. Search Page
Answer: A,B
Explanation:
Explanation
The feature pages that can be created using the Create Page Wizard are About Page, Access Control, Activity Reporting, Configuration Options, Email Reporting, Feedback, Login Page, and Theme Style Selection. These pages provide application-level functionality that can be added to an existing application. Search Page and Unified Task List are not feature pages that can be created using the Create Page Wizard. Verified References: Managing Feature PagesFeature Page Types
NEW QUESTION # 83
From SQL Workshop, you can perform which two of the following actions?
- A. Run SQL commands and scripts
- B. Create and view database objects
- C. Delete database
- D. Create an APEX user
Answer: A,B
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 # 84
Which two statements are true about Oracle APEX?
- A. You can build interactive reporting apps based on data from disparate systems
- B. Processing and data manipulation is not executed in the database.
- C. Running an APEX app needs client software.
- D. Application definition is not stored in the database.
- E. APEX eliminates middle-tier application logic.
Answer: A,E
Explanation:
Explanation
Oracle APEX is a low-code application development platform that enables developers to build scalable, secure, and data-driven web and mobile apps. Some of the statements that are true about Oracle APEX are:
APEX eliminates middle-tier application logic. APEX runs entirely within Oracle Database and does not require any additional middleware or application server to function. This simplifies the architecture and reduces the complexity, cost, and security risks of deploying applications.
You can build interactive reporting apps based on data from disparate systems. APEX supports various data sources, such as local database, REST Enabled SQL Service, REST Data Source, Web Source Module, etc. You can use these data sources to create interactive reports that allow end users to filter, sort, search, aggregate, and visualize data from different sources.
The other statements are false because:
Application definition is stored in the database. APEX stores the metadata of the application components, such as pages, regions, items, buttons, etc., in the database tables.
Processing and data manipulation is executed in the database. APEX leverages the power and performance of Oracle Database to process and manipulate data using SQL and PL/SQL.
Running an APEX app does not need client software. APEX apps are web-based and can be accessed from any browser on any device without installing any client software. Verified References: [Oracle Application Express (APEX) - Oracle Help Center], [Platform - Oracle APEX]
NEW QUESTION # 85
Which two statements are true about Maps in Oracle APEX?
- A. Maps support REST Enabled SQL
- B. Background maps do not require any API keys.
- C. Maps don't support REST Data Sources
- D. Heat Map and Polygons are not supported Spatial geometry objects
Answer: A,B
Explanation:
Explanation
A map is a type of component that enables you to view and manage data based on geographic locations. A map consists of a background map and spatial geometry objects that are sourced from data in a table or from a REST Data Source. Spatial geometry objects are shapes that represent real-world features on a map, such as points, lines, polygons, or heat maps. Two of the statements that are true about maps in Oracle APEX are:
Background maps do not require any API keys. This statement is true because Oracle APEX provides several background map options that do not require any API keys or registration to use. These options include OpenStreetMap, Stamen Maps, CartoDB Maps, and Esri Maps.
Maps support REST Enabled SQL. This statement is true because Oracle APEX allows you to use REST Enabled SQL as a data source for your map regions. REST Enabled SQL is a feature of Oracle REST Data Services (ORDS) that enables you to execute SQL statements and PL/SQL blocks over HTTPS using REST endpoints.
NEW QUESTION # 86
Which three statements are TRUE about Search Configuration?
- A. Only one Search Configuration can be used in a Search Page.
- B. Searches can be based on Local data, APEX Lists, REST Enabled SQL Service, or REST Data Sources.
- C. Search Configuration is a shared component defines the data source to be searched and the way results should be displayed.
- D. One or more Search Configurations can be configured in a Search Page.
Answer: B,C,D
Explanation:
Explanation
Search configuration is a shared component that defines the data source to be searched and the way results should be displayed. You can create a search configuration based on a local data source (table or SQL query), an APEX list, a REST enabled SQL service, or a REST data source2. You can use one or more search configurations in a search page, depending on the search type you select. For example, you can use multiple search configurations for a standard search, but only one search configuration for an Oracle TEXT or a list search2.
NEW QUESTION # 87
......
Passing the Oracle APEX Developer Professional certification exam can offer various benefits to professionals. It allows them to demonstrate their expertise in using Oracle APEX to build and manage web applications. Professionals who hold this certification can increase their chances of employment opportunities, contract work, or promotions in their current workplace. Additionally, professionals can broaden their knowledge and learn new skills that can improve their career growth and earning potential.
Free Exam Files Downloaded Instantly: https://www.examcollectionpass.com/Oracle/1Z0-770-practice-exam-dumps.html
1Z0-770 Free Exam Questions with Quality Guaranteed: https://drive.google.com/open?id=14O2pJ7oYvBHXVBzCKODsoDqHgr5YGkOX