Oracle 1Z0-770 Practice Exam - 144 Unique Questions [Q86-Q102]

Oracle 1Z0-770 Practice Exam - 144 Unique Questions

Latest Questions 1Z0-770 Guide to Prepare Free Practice Tests

NEW QUESTION # 86
Which two layout options are available for Page Designer under Utilities?

• A. Two Pane Mode
• B. Four Pane Mode
• C. Single Pane Mode
• D. Three Pane Mode

Answer: A,C

Explanation:
Explanation
Page Designer is a tool that allows developers to create and edit pages in Oracle APEX using a graphical user interface. Page Designer has three main panes: Rendering, Processing, and Property Editor. You can change the layout of Page Designer under Utilities by selecting one of the following options:
Single Pane Mode - This option displays only one pane at a time. You can switch between the Rendering, Processing, and Property Editor panes by using the buttons on the toolbar or the keyboard shortcuts.
Two Pane Mode - This option displays two panes side by side. You can choose which panes to display by using the buttons on the toolbar or the keyboard shortcuts. You can also resize the panes by dragging the splitter bar between them. There is no Three Pane Mode or Four Pane Mode option for Page Designer layout. Verified References: [Managing Pages in Page Designer - Oracle Help Center], [Page Designer Layout Options - Oracle Help Center]

NEW QUESTION # 87
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 restrict acceptable values to Y or N.
• C. It will default to FALSE.
• 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 # 88
Which statement is true about the Approvals component?

• A. APEX_APPROVAL is Page processes that create andact on task instances in yourpages.
• B. You can set up task approvers and administrators at design time or determine themdynamically at runtime based on data related to the task.
• C. Unified Task List is a shared component used to configure task parameters,participants, actions, and due dates.
• D. Task Definition is a page that shows details for a specific task, which can include metadata, history, comments, and actions.

Answer: B

Explanation:
Explanation
The Approvals Component is a feature in Oracle APEX that enables you to create and manage tasks for user approval. The Approvals Component deals with all aspects of human approval in Oracle APEX, allowing you to put approval functionality into your applications. The Approvals Component creates one or more tasks for items that require approval based on a pre-configured template, known as the Task Definition. The Task Definition specifies the data source, display attributes, potential owners, business administrators, and available actions for the tasks. You can set up task approvers and administrators at design time or determine them dynamically at runtime based on data related to the task. For example, you can use a SQL query or a PL/SQL function to return the list of potential owners or business administrators for each task based on some criteria, such as department, role, or location.

NEW QUESTION # 89
What are the three features of a calendar in APEX?

• A. Next - Navigates to the next month.
• B. Previous - Navigates to the previous month.
• C. Reminders - Displays the reminders set by the users
• D. Month, Week, Day - Displays a monthly, weekly and daily view.

Answer: A,B,D

Explanation:
Explanation
A calendar is a type of component that enables users to view and manage data based on dates. A calendar can display data in different views, such as monthly, weekly, daily, or list. Users can also interact with the calendar by creating, editing, or deleting events, or by using drag and drop functionality. Three of the features of a calendar in Oracle APEX are:
Next - Navigates to the next month. This feature allows users to move forward in time and see the events for the following month.
Previous - Navigates to the previous month. This feature allows users to move backward in time and see the events for the previous month.
Month, Week, Day - Displays a monthly, weekly and daily view. These features allow users to switch between different views of the calendar and see the events for a specific month, week, or day.

NEW QUESTION # 90
Which two statements are true about Faceted Search pages?

• A. Facets map to specific database columns.
• B. A facet's chart can be seen only in a nonmodal dialog.
• C. Multiple charts are not visible in the same region.
• D. Faceted Search supports the ability to filter columns storing multiple values as one string.

Answer: A,D

Explanation:
Explanation
Faceted Search is a feature that allows end users to filter data by applying one or more facets. A facet is a set of filters based on a column or expression. Faceted Search supports the ability to filter columns storing multiple values as one string, such as comma-separated values or JSON arrays, by using the Split Values attribute. Facets map to specific database columns or expressions that are defined in the Data Source attribute of the faceted search region. The other statements are false because Faceted Search supports displaying multiple charts in the same region by using the Chart View attribute, and a facet's chart can be seen either in a nonmodal dialog or inline by using the Chart Display Mode attribute. Verified References: [Creating Faceted Search Pages - Oracle Help Center], [Facet Attributes - Oracle APEX]

NEW QUESTION # 91
Which two actions can you perform using the Object Browser?

• A. Create and run SQL scripts.
• B. Export and import SQL scripts.
• C. Restore dropped database objects.
• D. Create a lookup table based on a column in the current table.
• E. Browse database objects of the current schema.

Answer: D,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 # 92
Which two statements are true about creating and managing an APEX Workspace?

• A. New schemas cannot be created during workspace creation.
• B. A workspace enables multiple users to work within the same Oracle APEX installation.
• C. A workspace can be associated with only one schema.
• D. During workspace creation, you can associate the workspace with an existing databaseschema.
• E. You can create only two workspaces in an APEX Service(APEX Application Development)instance.

Answer: B,D

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 # 93
Which client credentials are utilized for authentication during the One-Click Remote ApplicationDeployment process?

• A. PEX Developer credentials
• B. Database schema credentials
• C. APEX Workspace Admin credentials

Answer: C

Explanation:
Explanation
The One-Click Remote Application Deployment feature in Oracle APEX enables developers to deploy an application along with supporting object definitions to another workspace or to remote Oracle APEX instances. To use this feature, you need to provide the client credentials for authentication during the deployment process. The client credentials are utilized for authentication during the One-Click Remote Application Deployment process are the APEX Workspace Admin credentials. You can either specify an existing credential or create a new credential when you create a REST Enabled SQL reference in Shared Components. Optionally, you can create the credentials as empty credentials to prompt for client ID and client secret each time the REST Enabled SQL reference is used. Verified References: [Understanding One-Click Remote Application Deployment - Oracle Help Center], [Remote Deployment of your APEX App is just One Click Away! - Oracle Blogs]

NEW QUESTION # 94
Which two of the following types can an end user save the customized Interactive report as?

• A. A Public report
• B. Default report
• C. Cannot save the report
• D. A private report

Answer: A,D

NEW QUESTION # 95
Which two feature pages can you create using the Create Page Wizard?

• A. Access Control
• B. Feedback
• 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 # 96
Which two statements are true about Maps in Oracle APEX?

• A. Heat Map and Polygons are not supported Spatial geometry objects
• B. Maps don't support REST Data Sources
• C. Maps support REST Enabled SQL
• D. Background maps do not require any API keys.

Answer: C,D

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 # 97
Which two statements are true about REST Data Source Synchronization?

• A. To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema.
• B. The local table can only be used for Data Synchronization but you cannot add indexes or change physical properties
• C. If the local table is not in sync with the Data Profile, Data Synchronization doesn't work.
• D. If the local table is not in sync with the Data Profile, Data Synchronization continues to work for columns present in both the table and the Data Profile.
• E. You cannot trigger Data Synchronization on a regular schedule using a scheduler job.

Answer: A,D

Explanation:
Explanation
REST Data Source Synchronization is a feature that enables developers to automatically sync the contents of a local table with the data from an external REST service. To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema, which allows APEX to create a DBMS_SCHEDULER job for each scheduled synchronization task. If the local table is not in sync with the Data Profile, which defines the columns and data types of the REST service response, Data Synchronization continues to work for columns present in both the table and the Data Profile (other columns are ignored). However, APEX generates SQL DDL statements to sync table columns back to the Data Profile, which can be added to the application as supporting objects. Verified References: Managing Data Synchronization - Oracle Help Center, Synchronize Data from REST Services to Local Table - Oracle Blogs

NEW QUESTION # 98
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 # 99
You must reference certain data from a dragged event under the Drag and Drop PL/SQL Code attribute of the Calendar component.
Examine this list:
1. The ID
2. The NEW_START_DATE
3. The NEW END DATE
How can these be referenced?

• A. :APEX$PK_VALUE, APEX$NEW START DATE and APEXSNEW_END_DATE
• B. #APEX.PK_VALUE#, #APEX.NEW START_DATE# and #APEX.NEW_END_DATE#
• C. #APEXSPK VALUE#, #APEX$NEW START DATE# and #APEXSNEW END DATE#
• D. :APEX.PK_VALUE, :APEX.NEW START DATE and :APEX.NEW END DATE

Answer: D

Explanation:
Explanation
d event under the Drag and Drop PL/SQL Code attribute of the Calendar component. This attribute allows you to write PL/SQL code to update the event row in the database after the user drags and drops an event on the calendar. To reference the ID, the new start date, and the new end date of the dragged event, you can use these bind variables: :APEX.PK_VALUE, :APEX.NEW_START_DATE and :APEX.NEW_END_DATE. These variables are automatically populated by APEX when the user performs a drag and drop action on the calendar. For example, you can write something like this:
UPDATE events
SET start_date = :APEX.NEW_START_DATE,
end_date = :APEX.NEW_END_DATE
WHERE id = :APEX.PK_VALUE;

NEW QUESTION # 100
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?

• A. Master Detail
• B. Interactive Grid
• C. Unified Task List
• D. Cards

Answer: D

Explanation:
Explanation
Cards 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 Center

NEW QUESTION # 101
Choose the three requirements for creating a REST Enabled SQL Reference.

• A. Install Oracle REST Data Services (ORDS) 19.x or later.
• B. Configure and enable the REST Enabled SQL service feature
• C. Set up any remote database
• D. Activate REST Enabled SQL for the target schema on the remote database

Answer: A,B,D

Explanation:
Explanation
To create a REST Enabled SQL Reference, you need to meet the following requirements:
Install Oracle REST Data Services (ORDS) 19.x or later. ORDS is a Java application that enables developers to create, publish, and manage RESTful web services for Oracle databases1.
Activate REST Enabled SQL for the target schema on the remote database. REST Enabled SQL is a feature of ORDS that allows you to execute any SQL or PL/SQL through a REST endpoint. You need to enable this feature for the schema that contains the data you want to access2.
Configure and enable the REST Enabled SQL service feature. This is a workspace-level setting that allows you to use REST Enabled SQL references in your APEX applications. You need to specify a path prefix and a secret for the REST Enabled SQL service3.
You do not need to set up any remote database, as long as it meets the ORDS and REST Enabled SQL requirements. You can use any Oracle database or MySQL database as a remote data source2.

NEW QUESTION # 102
......

Correct and Up-to-date Oracle 1Z0-770 BrainDumps: https://examsboost.realexamfree.com/1Z0-770-real-exam-dumps.html