Oracle 1Z0-770 Exam Questions (Updated 2024) 100% Real Question Answers [Q13-Q37]

Oracle 1Z0-770 Exam Questions (Updated 2024) 100% Real Question Answers

Pass Oracle 1Z0-770 Exam Quickly With BraindumpQuiz

NEW QUESTION # 13
Which two statements are true about the Create Application Wizard?

• A. It allows application pages to be reordered.
• B. It allows the uploading of JavaScript or CSS files required for an application.
• C. It allows application pages to be added or deleted.
• D. It allows the application authorization to be changed

Answer: A,C

Explanation:
Explanation
The Create Application Wizard is a tool that allows developers to create a new application by following a series of steps. Some of the actions that you can perform using the Create Application Wizard are:
Reorder application pages. You can use the Reorder Pages option in the Pages step to change the order of the pages in your application by dragging and dropping them.
Add or delete application pages. You can use the Add Page or Delete Page options in the Pages step to add new pages or delete existing pages from your application. You can also use the Create Page Wizard to create additional pages after creating the application. You cannot upload JavaScript or CSS files required for an application or change the application authorization using the Create Application Wizard.
You can use other features in App Builder to perform these actions, such as Shared Components > User Interface > Files and Shared Components > Security > Authentication Schemes. Verified References:
[Creating an Application Using the Create Application Wizard - Oracle Help Center], [Create Application Wizard - Oracle APEX]

NEW QUESTION # 14
Which statement is true about the Data Workshop utility?

• A. The wizards load and unload table data only.
• B. You can load or unload multiple tables at a time.
• C. You cannot load data from an XLSX file with multiple worksheets.
• D. The wizards load and unload all types of schema objects.

Answer: A

Explanation:
Explanation
Data Workshop is a utility in SQL Workshop that enables developers to load and unload data to and from the database. The wizards load and unload table data only. They do not load or unload other kinds of schema objects. You can load data from an XLSX file with multiple worksheets by selecting the worksheet name in the Load Data Wizard. You can load or unload only a single table at a time using the wizards. Verified References: [Using Data Workshop - Oracle Help Center], [Loading Data - Oracle Help Center]

NEW QUESTION # 15
Which two statements are true about creating and customizing Smart Filters pages?

• A. If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache.
• B. The search results report can be displayed as an interactive report.
• C. The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types.
• D. The search results report can be displayed as an interactive grid

Answer: A,C

Explanation:
Explanation
Smart Filters is a component that allows end users to filter data by typing keywords in a single search field.
Some of the statements that are true about creating and customizing Smart Filters pages are:
If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache. You can also manually add or remove filters as needed.
The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types. For other filter types, such as Input or Range, the count is not displayed. The search results report cannot be displayed as an interactive report or an interactive grid. The supported report types are Classic Report, Cards, Map, or Calendar. Verified References: [Managing Smart Filters - Oracle Help Center],
[Creating Smart Filters Using the Create Page Wizard - Oracle Help Center]

NEW QUESTION # 16
Which two tasks can you perform using App Builder?

• A. Create and manage database objects.
• B. Generate data definition language (DDL) statements from the Oracle data dictionary.
• C. Create and manage apps.
• D. Create join queries using drag and drop.
• E. Import previously exported apps.

Answer: C,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 # 17
Which of the following options in the Developer Toolbar enables you to customize the look and feel of the application?

• A. Quick Edit
• B. Customize
• C. Debug
• D. Session

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 # 18
Plug-ins can be used declaratively in which of the following components in APEX?

• A. All of them
• B. Process Type
• C. Dynamic Actions
• D. Regions
• E. Items

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 # 19
In your application, you want to include a master aetall containing two pages based on two related tables or views. The first page contains an interactive report for the master table. The second page features a standard form for the master and interactive grids for the detail. Which master detail form will you create?

• A. Side by Side Master Detail
• B. Stacked Master Detail
• C. Editable Interactive Grid
• D. Drill down Master Detail

Answer: D

Explanation:
Explanation
A drill down master detail form allows you to create a master detail form that contains two pages based on two related tables or views. The first page contains an interactive report for the master table. The second page features a standard form for the master and interactive grids for the detail. You can use the Create Page wizard to create a drill down master detail form. References: Creating Master Detail Forms and [Creating a Drill Down Master Detail Form]

NEW QUESTION # 20
Which statement is true about Theme Styles in Oracle APEX?

• A. Theme Styles in Oracle APEX determine the layout and structure of a webpage.
• B. You can only enable the Is Current attribute when the Theme Style has the Read Only attribute disabled.
• C. When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment.

Answer: C

Explanation:
Explanation
Theme Styles in Oracle APEX are CSS style sheets that are added to the base CSS of a theme to alter the look and feel of an application. A theme can have multiple theme styles with one style set as current. When the Is Public attribute is enabled for a theme style, end users can choose the theme style from the runtime environment by using the Theme Style Switcher component. This allows end users to customize the appearance of the application according to their preferences. Verified References: Using Themes and Theme Styles - Oracle Help Center, Theme Styles - Oracle APEX

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

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

Answer: A,B

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

• A. A facet's chart can be seen only in a nonmodal dialog.
• B. Facets map to specific database columns.
• 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: B,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 # 23
When you click a Customer Name in the Customers report, the Customer Details form dialog page is displayed. What are the events that occur in this scenario?

• A. Page Rendering
• B. Page Processing
• C. Page rendering and processing
• D. Page compilation

Answer: C

Explanation:
Explanation
When you click a Customer Name in the Customers report, the Customer Details form dialog page is displayed. This involves two events: page rendering and page processing. Page rendering is the event that occurs when APEX generates and sends the page to the browser. Page processing is the event that occurs when APEX receives and processes the page from the browser. In this scenario, both events happen because the Customer Details form dialog page is a modal dialog that uses AJAX to communicate with the server without reloading the entire page. Page compilation is not an event, but an action that occurs when APEX compiles an application or a page before running it.

NEW QUESTION # 24
Which statement is true about the Link Column attribute of an interactive report?

• A. If you select Link Column, it is always displayed as the last column in the report.
• B. A Link Column cannot be sorted, hidden, or moved by an end user.
• C. It is not possible to include a custom target in Link Column
• D. It is not possible to exclude Link Column.

Answer: B

Explanation:
Explanation
A Link Column is a special column type that you can define for an interactive report to create a link to another page, URL, or custom target. A Link Column is always displayed as the first column in the report, regardless of the order of the columns in the query. A Link Column cannot be sorted, hidden, or moved by an end user using the Actions menu or the column header. However, a developer can change the position and visibility of a Link Column by editing the report attributes in Page Designer.

NEW QUESTION # 25
Choose the three different ways in which you can add a checkbox to a page.

• A. Add a checkbox from the Property Editor
• B. Use the context sensitive menu in the Gallery pane.
• C. Right click Body in the Rendering Tree and add a New Page Item as Checkbox Type.
• D. Drag and drop the checkbox item into the Layout pane

Answer: B,C,D

Explanation:
Explanation
There are three different ways in which you can add a checkbox to a page in APEX:
Drag and drop the checkbox item into the Layout pane: In Page Designer, you can drag and drop items from the Gallery pane into the Layout pane to create them on your page. To create a checkbox item, expand the Items node in the Gallery pane and drag and drop Checkbox into the Layout pane.
Right click Body in the Rendering Tree and add a New Page Item as Checkbox Type: In Page Designer, you can right click any node in the Rendering tree andselect Create to create a new component under that node. To create a checkbox item under the Body node, right click Body and select Create > New Page Item > Checkbox.
Use the context sensitive menu in the Gallery pane: In Page Designer, you can use the context sensitive menu in the Gallery pane to create items on your page. To create a checkbox item using this method, expand the Items node in the Gallery pane and right click Checkbox. Then select Create Checkbox.

NEW QUESTION # 26
Which three statements are TRUE about Search Configuration?

• A. One or more Search Configurations can be configured in a Search Page.
• B. Search Configuration is a shared component defines the data source to be searched and the way results should be displayed.
• C. Searches can be based on Local data, APEX Lists, REST Enabled SQL Service, or REST Data Sources.
• D. Only one Search Configuration can be used in a Search Page.

Answer: A,B,C

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 # 27
Which statement is true about creating and using a faceted search page?

• A. If you create a faceted search page on a view or a SQL query, the facets are auto-discovered.
• B. The Search Results region can be displayed as a Classic Report or Cards.
• C. If you create a faceted search page based on a table, the facets are not auto-discovered.
• D. The Search Results region can be displayed as an interactive report.

Answer: B

Explanation:
Explanation
A faceted search page is a type of page that allows end users to filter data by applying one or more facets. A facet is a set of filters based on a column or expression. You can create a faceted search page by using the Create Page Wizard or by adding a faceted search region to an existing page. If you create a faceted search page based on a table, view, or SQL query, the facets are auto-discovered by analyzing the data source. The Search Results region can be displayed as a Classic Report or Cards, but not as an interactive report. You can also customize the appearance and behavior of the facets and the search results by using various attributes.
Verified References: [Creating Faceted Search Pages - Oracle Help Center], [Faceted Search Attributes - Oracle Help Center]

NEW QUESTION # 28
You must use a Static Content region type to display messages about the employees of the month. Employee names are stored in the P1 ENAME page item. Which text, when placed in Source, will display the message correctly?

• A. Join me in congratulating v('P1_ENAME') as the new employee of the month!
• B. Join me in congratulating &P1 ENAME, as the new employee of the month!
• C. Join me in congratulating :P1 ENAME as the new employee of the month!

Answer: B

Explanation:
Explanation
A Static Content region type is used to display static text or HTML content on a page. To display messages about the employees of the month, you can use a Static Content region type with substitution variables that reference page items. Substitution variables are enclosed in ampersands (&) and can be used to dynamically replace text with values from page items or application items. The correct text to display the message is "Join me in congratulating &P1_ENAME, as the new employee of the month!" The other options are incorrect because they use either colons (:) or v() function, which are not valid ways to reference page items in Static Content regions. Verified References: [Creating Static Content Regions - Oracle Help Center], [Understanding Substitution Strings - Oracle Help Center]

NEW QUESTION # 29
I want to hide a few columns in my interactive report. To do so, which option should I choose fromthe Actions menu?

• A. Filter
• B. Format
• C. Data
• D. columns

Answer: D

Explanation:
Explanation
To hide a few columns in your interactive report, you should choose Columns from the Actions menu. This option allows you to select which columns to show or hide in your report by using checkboxes. You can also reorder or resize the columns from this option.
The other options are incorrect because:
Filter allows you to filter the data in your report by applying one or more conditions on the columns.
Data allows you to add, modify, or delete data in your report by using inline editing or modal dialog editing.
Format allows you to change the appearance of your report by applying conditional formatting rules or highlighting colors.
Verified References: [Customizing Interactive Reports] [Actions Menu]

NEW QUESTION # 30
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. Unified Task List
• B. Cards
• C. Master Detail
• D. Interactive Grid

Answer: B

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 # 31
Which two statements are true about creating and using dynamic actions?

• A. If no client-side condition is defined, true actions will not fire.
• B. 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
• 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: B,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 # 32
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) not null, 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), roll_no number )
  ;
• C. An Invalid column definition error message will be displayed.

Answer: B

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 # 33
You use the Create Page Wizard to create a faceted search page on the EMP table. What is the default report type generated for this page?

• A. Classic Report
• B. Interactive Report
• C. Interactive Grid
• D. Column Toggle Report

Answer: A

Explanation:
Explanation
When you use the Create Page Wizard to create a faceted search page on any table or SQL query, such as EMP table, APEX generates a classic report region as default report type for this page. A classic report region displays data from a SQL query or PL/SQL function returning a SQL query in tabular format. A faceted search page also contains a region of Faceted Search type, which holds one or more facets that allow end users to filter data by applying one or more facets. Verified References: Creating Faceted Search Pages - Oracle Help Center, Creating Classic Reports - Oracle Help Center

NEW QUESTION # 34
Which statement is true about session state management in Oracle APEX?

• A. Multiple number of sessions cannot exist in the database at the same time
• B. APEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests.
• C. A user cannot run multiple instances of an application simultaneously in different browser programs.

Answer: B

Explanation:
Explanation
Session state management is a feature that enables developers to store and retrieve values for a user as the user navigates between different application pages. A session is a logical construct that establishes persistence (or stateful behavior) across page views. Each session is assigned a unique identifier (or session ID). The statement that is true about session state management in Oracle APEX is:
APEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests. APEX Sessions are stored in memory within an Application Express engine process while Oracle database sessions are stored in memory within an Oracle database process. The other statements are false because:
A user can run multiple instances of an application simultaneously in different browser programs by using different session IDs.
Multiple number of sessions can exist in the database at the same time for different users or applications.
Verified References: [Understanding Session State Management - Oracle Help Center], [What Is a Session? - Oracle Help Center]

NEW QUESTION # 35
What are Task definitions that exist on the application level inthe Shared Components section made up of?

• A. Actions
• B. All of them
• C. Particpants
• D. Parameters
• E. Task Settings

Answer: B

Explanation:
Explanation
Task definitions that exist on the application level in the Shared Components section are made up of all of the following: Participants, Task Settings, Parameters, and Actions. Task definitions are used to define approval workflows for data changes in interactive grids or forms5. Participants are the users or groups who can approve or reject tasks. Task Settings are the properties that control how tasks are created, assigned, and completed. Parameters are the variables that store information about tasks or data changes. Actions are the PL/SQL code blocks that execute when tasks are created, updated, or completed5.

NEW QUESTION # 36
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 FALSE.
• B. It will restrict acceptable values to TRUE or FALSE.
• C. It will restrict acceptable values to Y or N.
• D. It will default to TRUE.

Answer: B

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 # 37
......

Real Oracle 1Z0-770 Exam Questions [Updated 2024]: https://www.braindumpquiz.com/1Z0-770-exam-material.html

Prepare 1Z0-770 Question Answers - 1Z0-770 Exam Dumps: https://drive.google.com/open?id=1ZSehHWO3nTI4-KGaNCDs7R84gvB9x34T