Oracle 1Z0-770 Test Engine Dumps Training With 144 Questions
1Z0-770 Questions Pass on Your First Attempt Dumps for Oracle Database Certified
Upon successful completion of the Oracle 1Z0-770 Exam, candidates will receive the Oracle APEX Developer Professional certification. Oracle APEX Developer Professional certification is valid for three years and requires candidates to recertify before the expiration date. Recertification can be achieved by passing a current version of the Oracle APEX Developer Professional exam or by earning a higher-level certification in the Oracle certification program.
Oracle 1Z0-770 certification exam, also known as the Oracle APEX Developer Professional exam, is designed for professionals who specialize in developing and deploying applications using Oracle Application Express (APEX). 1Z0-770 exam measures the candidate's knowledge and skills in various areas related to APEX development, including data modeling, SQL and PL/SQL, application design and development, security, and performance tuning.
NEW QUESTION # 59
Which two of the following capabilities are TRUE for both Interactive Report and Interactive Grid?
- A. End user can customize how and what data is displayed.
- B. End user can rearrange the report interactively using the mouse.
- C. End user can add, modify, and refresh data directly on the report.
- D. End user can save the report
Answer: A,C
Explanation:
Explanation
An Interactive Report and an Interactive Grid are two types of regions that allow end users to customize how and what data is displayed. They have some common capabilities such as:
End users can add, modify, and refresh data directly on the report by using the Edit option. This option enables inline editing or modal dialog editing depending on the region settings.
End users can customize how and what data is displayed by using the Actions menu. This menu provides various options such as Filter, Highlight, Aggregate, Chart, Group By, Pivot, etc.
The other options are incorrect because:
End users cannot rearrange the report interactively using the mouse in an Interactive Report. This capability is only available in an Interactive Grid by using the Reorder option in the Actions menu.
End users cannot save the report in an Interactive Grid. This capability is only available in an Interactive Report by using the Save Report option in the Actions menu.
Verified References: [About Interactive Reports] [About Interactive Grids]
NEW QUESTION # 60
Which two statements are true about creating and managing an APEX Workspace?
- A. A workspace can be associated with only one schema.
- B. A workspace enables multiple users to work within the same Oracle APEX installation.
- C. New schemas cannot be created during workspace creation.
- D. You can create only two workspaces in an APEX Service(APEX Application Development)instance.
- E. During workspace creation, you can associate the workspace with an existing databaseschema.
Answer: B,E
Explanation:
Explanation
A workspace is a logical work area that enables multiple users to work within the same Oracle APEX installation while keeping their objects, data, and applications private. Creating and managing an APEX workspace involves the following statements:
During workspace creation, you can associate the workspace with an existing database schema or create a new schema for the workspace. A schema is a collection of database objects such as tables, views, indexes, etc. that belong to a user.
A workspace enables multiple users to work within the same Oracle APEX installation. Each user can have a different role and privilege in the workspace, such as workspace administrator, developer, or end user.
A workspace can be associated with one or more schemas. You can add or remove schemas from a workspace after it is created.
You can create as many workspaces as you need in an APEX Service (APEX Application Development) instance. There is no limit on the number of workspaces per instance.
Verified References: Managing WorkspacesAbout Workspaces
NEW QUESTION # 61
What are the three key features of Universal Theme?
- A. Responsive Design
- B. Versatile UI Components
- C. Easy Customization
- D. Support for single theme
Answer: A,B,C
Explanation:
Explanation
Universal Theme has many features that make it an ideal user interface for Oracle APEX applications. Three of the key features of Universal Theme are:
Versatile UI Components: Universal Theme provides a rich set of UI components that can be used to create interactive and engaging applications. Some of the UI components include cards, lists, charts, calendars, maps, timelines, accordions, tabs, modals, alerts, and more.
Responsive Design: Universal Theme adapts to different screen sizes and devices using CSS media queries and grid layout. It ensures that the applications look good and work well on any device, from desktops to tablets to smartphones.
Easy Customization: Universal Theme allows developers to customize the appearance and behavior of their applications using template options and theme styles. Template options enable developers to apply different styles to components on a page without writing custom code. Theme styles enable developers to change the overall look and feel of the application by choosing from a variety of pre-built styles or creating their own.
NEW QUESTION # 62
Which two statements are TRUE about Dynamic Actions?
- A. Dynamic Actions require complex client side Javascript code
- B. More dynamic actions you add to a page, the greater your overall page size.
- C. Dynamic actions provide a way to define complex client-sidebehaviordeclaratively without the need for JavaScript.
- D. It is not possible to debug Dynamic Actions from the Developer Toolbar
Answer: B,C
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 # 63
Which is NOT a valid Geometry Column Data Type available for maps region?
- A. SDO_GEOMETRY
- B. Latitude/Longitude
- C. JSON_OBJECT
- D. GeoJSON
Answer: C
Explanation:
Explanation
The valid Geometry Column Data Types for maps region are Latitude/Longitude, GeoJSON, and SDO_GEOMETRY. These types represent different ways of storing spatial data in Oracle Database.
Latitude/Longitude uses two numeric columns for longitude and latitude values. GeoJSON uses a VARCHAR2 or CLOB column that contains geometry information in GeoJSON format. SDO_GEOMETRY uses an object type that stores spatial data using Oracle Spatial features. JSON_OBJECT is not a valid Geometry Column Data Type for maps region. Verified References: About Supported MapsEditing Maps
NEW QUESTION # 64
Which three of the following statements are TRUE about Data Synchronization?
- A. Helps in Providing efficient reporting on large data sets coming from a REST service
- B. APEX can create the local table based on the visible columns in the REST Data Source Data Profile.
- C. You must trigger Data Synchronization manually
- D. Data Synchronization enables developers to automatically sync the contents of a local table with the data from a REST service.
Answer: A,B,D
Explanation:
Explanation
Data Synchronization enables developers to automatically sync the contents of a local table with the data from a REST service. APEX invokes the REST service defined in the REST Data Source, downloads all data and synchronizes it to a local table6. Data Synchronization has several benefits, such as:
APEX can create the local table based on the visible columns in the REST Data Source Data Profile. Since the table is physically available in the database schema, developers can add indexes, change physical properties, or even add more columns6.
Data Synchronization helps in providing efficient reporting on large data sets coming from a REST service. Some REST services can return large amounts of result data that include pagination. If a reporting requirement needs larger data sets, this would lead to multiple HTTP requests and poorer response times. Also, no indexes or other database features can be used to speed up reporting queries. In this case, synchronizing the remote data to a local table and having the reports working on local tables can improve performance and user experience6.
Data Synchronization can also collect data from REST services for consumption by PL/SQL packages or other logic. If data from the REST service is replicated to local tables, developers will be able to perform all sorts of processing and also generate different types of reports6.
You do not have to trigger Data Synchronization manually, as you can also schedule it to run periodically using a DBMS_SCHEDULER expression6.
NEW QUESTION # 65
What are the required fields while creating a Chart in APEX?
- A. Data Source
- B. All of them
- C. Label Column
- D. Value Column
- E. Name
Answer: B
Explanation:
Explanation
To create a chart in Oracle APEX, you need to provide some required fields that define the data source and appearance of the chart. You can use either the Create Page Wizard or Page Designer to create a chart. The required fields for creating a chart are:
Data Source: This field specifies the SQL query that returns the data for the chart. The query must include at least one column for the label and one column for the value of each data point. You can also include additional columns for grouping, color, or tooltip information.
Value Column: This field specifies the column from the data source query that contains the numeric values for the chart. The values are used to plot the data points on the chart and determine the size of each data point or segment.
Name: This field specifies the name of the chart region. The name is used to identify the region in Page Designer and other components, such as dynamic actions or processes.
Label Column: This field specifies the column from the data source query that contains the labels for the chart. The labels are used to display the name of each data point or segment on the chart or in the legend.
NEW QUESTION # 66
From SQL Workshop, you can perform which two of the following actions?
- A. Create an APEX user
- B. Run SQL commands and scripts
- C. Delete database
- D. Create and view database objects
Answer: B,D
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 # 67
Plug-ins can be used declaratively in which of the following components in APEX?
- A. All of them
- B. Regions
- C. Items
- D. Process Type
- E. Dynamic Actions
Answer: A
Explanation:
Explanation
Plug-ins can be used declaratively in all of the following components in APEX: Dynamic Actions, Regions, Items, Process Type, and Authentication and Authorization Schemes. Plug-ins are shared components that enable developers to extend the native functionality of APEX with custom components1. Plug-ins can be created or imported from the Shared Components page or the App Gallery1.
NEW QUESTION # 68
Examine this code used in Quick SQL:
students
name
roll no num
Quick SQL is using default settings.
Which table creation script or other output is produced?
- A. create table students (
id number generated by default on null as identity constraint students_id_pk primary key, name varchar2 (255 char), roll_no number )
; - B. 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. An Invalid column definition error message will be displayed.
Answer: A
Explanation:
Explanation
The table creation script produced by Quick SQL is:
create table emp_salary ( id number generated by default on null as identity constraint emp_salary_id_pk primary key, name varchar2 (255 char) not null, salary number, commission_yn varchar2 (1 char) check (commission_yn in ('Y','N')) default 'N' not null ); The commission_yn column will default to 'N' because of the default clause in the column definition. It will also restrict acceptable values to 'Y' or 'N' because of the check constraint. The other options are incorrect because they do not match the output of Quick SQL. Verified References: Using Quick SQLAbout Quick SQL Shorthand Syntax
NEW QUESTION # 69
Which two feature pages can you create using the Create Page Wizard?
- A. Feedback
- B. Unified Task List
- C. Access Control
- D. Search Page
Answer: A,C
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 # 70
In a faceted search page, facets can be displayed as different UI types. Which two facet item types are supported in the faceted search region?
- A. Popup LOV
- B. Range
- C. Date Picker
- D. Checkbox Group
Answer: B,D
Explanation:
Explanation
In a faceted search page, facets can be displayed as different UI types depending on the data type and cardinality of the facet column or expression. The facet item types are the UI components that are used to render the facets in the faceted search region. The supported facet item types are Range, Checkbox Group, Radio Group, List, Star Rating, and Switch. Date Picker and Popup LOV are not valid facet item types.
Verified References: [Faceted Search Attributes - Oracle Help Center], [Facet Item Types - Oracle APEX]
NEW QUESTION # 71
Choose the two statements that are TRUE about an Interactive Report. As a developer:
- A. You cannot modify the report source query
- B. You can customize the Actions menu to include or exclude certain options.
- C. You can modify the data in the report after running the app
- D. You can customize the pagination
Answer: C,D
NEW QUESTION # 72
Which two among the following are TRUE about Low Code Apps?
- A. Not Mobile Friendly
- B. Scalable
- C. Expensive
- D. Provide Rich Functionality with Less Code
Answer: B,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 # 73
Which statement is true about using the App Gallery?
- A. Sample Apps and Starter Apps are only available if your instance administrator has enabled them.
- B. Custom Apps are only available if your instance administrator has enabled them.
- C. You can download Sample Apps and Starter Apps from Team Development to import into your workspace.
- D. You cannot install Sample Apps and Starter Apps directly from the Gallery.
Answer: B
Explanation:
Explanation
Custom Apps are specific to your workspace and are only available if your instance administrator has enabled them. You can install Sample Apps and Starter Apps directly from the Gallery or download them from GitHub. Sample Apps and Starter Apps are available with every Oracle APEX workspace. References: Using the App Gallery and Configuring the Application Gallery
NEW QUESTION # 74
Choose the three types of aggregations you can apply on a column.
- A. Average
- B. Sum
- C. Standard Deviation
- D. Count
Answer: A,B,D
NEW QUESTION # 75
Select the three types of Card Layout you can create in APEX.
- A. Vertical(Column)
- B. Horizontal(Row)
- C. Grid
- D. Float
Answer: B,C,D
Explanation:
Explanation
You can create two types of card layout in APEX: Float and Grid. Float layout displays cards in a single row that wraps to the next row when the available space is filled. Grid layout displays cards in a fixed number of columns that can be responsive to the screen size1. Vertical and Horizontal are not valid card layout types in APEX.
NEW QUESTION # 76
Select the two advantages of using One-click Remote Deployment.
- A. You need to access your production environment to import the app directly.
- B. Simplify the process of deploying an application
- C. Deploy the app, and explicitly install the supporting objects in one-click.
- D. Directly deploy your app definition along with the objects from the source system to the target system
Answer: C,D
Explanation:
Explanation
One-click remote application deployment is a feature in Oracle APEX that simplifies the process of deploying an application from one APEX instance to another using REST Enabled SQL references. REST Enabled SQL references are shared components that work with an Oracle REST Data Services (ORDS) REST Enabled SQL Service. One-click remote application deployment can authenticate through first party authentication (Basic Authentication), Schema Authentication (database username and password), or OAuth 2 Client Credentials.
Two of the advantages of using one-click remote application deployment are:
Deploy the app, and explicitly install the supporting objects in one-click. This advantage allows you to package the app definition along with the database objects, images, and seed data necessary for your application to run correctly using the Supporting Objects functionality in APEX. You can then export and deploy this app and install the supporting objects in one-click without having to manually create or copy the database objects in the target system.
Directly deploy your app definition along with the objects from the source system to the target system.
This advantage allows you to avoid the intermediate step of exporting the app and its objects from the source system into files and then importing them into the target system. You can directly deploy your app and its objects from within your development environment to the remote production environment without having to access your production environment.
NEW QUESTION # 77
Which three are the main components of APEX workspace homepage?
- A. Gallery
- B. RESTful Services
- C. SQL Workshop
- D. App Builder
Answer: A,C,D
Explanation:
Explanation
The 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]
NEW QUESTION # 78
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 # 79
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. Processing
- B. Dynamic Actions
- C. Conditional SQL
- 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 # 80
Which three of the following are use cases of Automations?
- A. Approving specific requests
- B. Monitoring log tables and raising an alert when there is an issue
- C. Sending email alerts at a particular time of the week
- D. Deleting a database record based on an end user's request
Answer: A,B,C
Explanation:
Explanation
Automations are a sequential set of PL/SQL actions that are triggered by query results. They are used to monitor data and then perform the appropriate action2. Some use cases of automations are:
Monitoring log tables and raising an alert when there is an issue. For example, an automation can query a log table for any errors and send an email notification to the administrator if any errors are found2.
Approving specific requests. For example, an automation can query a table for any pending requests and approve them automatically based on some criteria2.
Sending email alerts at a particular time of the week. For example, an automation can query a table for any overdue tasks and send a reminder email to the assignees every Monday2.
Deleting a database record based on an end user's request is not a use case of automations, as it does not involve querying data and triggering actions based on the query results. This can be achieved by using a PL/SQL process or a dynamic action on the page where the user requests the deletion34.
NEW QUESTION # 81
Which two tasks can you perform using App Builder?
- A. Create join queries using drag and drop.
- B. Create and manage apps.
- C. Generate data definition language (DDL) statements from the Oracle data dictionary.
- D. Create and manage database objects.
- E. Import previously exported apps.
Answer: B,E
Explanation:
Explanation
App Builder is the main interface of Oracle APEX that allows developers to create and manage web applications. App Builder provides various features and tools to design, develop, test, debug, deploy, and maintain applications. Some of the tasks that you can perform using App Builder are importing previously exported apps, creating new apps from scratch or from predefined templates or blueprints, editing app properties and attributes, adding pages and regions, creating shared components, running and debugging apps, exporting apps to files or workspaces, etc. You cannot create join queries using drag and drop or generate DDL statements from the Oracle data dictionary using App Builder. Verified References: [Using App Builder
- Oracle Help Center], [App Builder Concepts - Oracle Help Center]
NEW QUESTION # 82
......
1Z0-770 Practice Test Pdf Exam Material: https://www.dumpsvalid.com/1Z0-770-still-valid-exam.html
1Z0-770 Answers 1Z0-770 Free Demo Are Based On The Real Exam: https://drive.google.com/open?id=1BllD7g3dOqunucMu20ROnr_lD6s_Q_un