Oracle 1Z0-450 Ebook 2021

NEW QUESTION 1
Before the application Installation can proceed, the Installer checks whether the user has required system privileges or not. Where would you specify the required system privileges?

• A. Supporting Objects > Build Options
• B. Supporting Objects > Validations
• C. Supporting Objects > Install
• D. Supporting Objects > Prerequisites
• E. Supporting Objects > System Requirements

Answer: D

NEW QUESTION 2
ABC Company manager wants his employees to create/load spreadsheets on every page using the web sheet application? How to do that using the APEX websheet application? (Choose two)

• A. Create a page navigation
• B. Create a data grid
• C. Create a data section based on data from a data grid
• D. Add a text section to a page
• E. Use a SQL queryF Create a section navigation

Answer: BC

NEW QUESTION 3
Which three actions can be performed by a Workspace Administrator?

• A. Monitor workspace activity
• B. Manage workspace to schema assignments
• C. Manage user accounts
• D. Approve workspace requests
• E. View usage reports of workspace

Answer: ACE

Explanation:

Developers can create and edit applications and view developer activity, session state, workspace activity(A), application, and schema reports. Workspace administrators additionally can create and edit user accounts (C), manage groups, and manage development services.

NEW QUESTION 4
Which four actions can be performed when you click the Reorder Region Items Icon under items on a page definition page?

• A. Reorder the Items within a region
• B. Change the label of an item
• C. Change the Display as for the Item
• D. Change the label alignment for an Item
• E. Control whether an item should appear on a new line or create a new field

Answer: ABCD

Explanation:

Using the Reorder Regions Icon
You can quickly change the order that regions display, edit a region title, or change a region template by clicking the Reorder Regions icon on the Page Definition. The Reorder Regions icon displays as light green down and up arrows and displays to the right of Display Point.
C: Report Default attribute Display As - Specifies how the column should be displayed in a report.
Note: Region templates control the appearance and placement of region attributes. Region templates frequently use HTML tables to arrange content.
Region templates apply style elements to regions. Region templates display substitution strings. The only required substitution string, #BODY#, identifies where the source of the region should be placed. All other substitution strings are optional.
You can use these substitution strings to indicate the existence and placement of a page control, such as a button, within the region.
Reference: Oracle Application Express, Application Builder User’s Guide, Release 3.2, Using the Reorder Regions Icon

NEW QUESTION 5
Which two actions are true about creating a form based on a table with a report?

• A. This wizard builds two pages, the first page for the report and the second page for the form.
• B. The first page provides users with the ability to update the selected table or view.
• C. This report and form combination is based on a single table or view.
• D. The second page enables users to specify the row to be updated.
• E. This report and form combination can be based on more than one table or vie

Answer: AC

Explanation:

A: Form Page Type: Form on a Table with Report
Descriptipon: Creates two pages. One page displays a report. Each row provides a link to the second page to enable users to update each record.
C (not E): Form on a Table with Report.
This option creates two pages, a report and form, based on a single table or view.

NEW QUESTION 6
An Order Processing form retrieves order details from the user on page 21. The order details should be displayed in a summarized format on page 22 for confirmation. View the Exhibit and identify the correct syntax to be used to retrieve the session state.

• A. :P21_ORDERDATE and: P21_ORDERTOTAL
• B. V (‘P21_ORDERDAT
• C. and V (P21_ORDERTOTAL)
• D. &P21_QRDERDAT
• E. And &P21_ORDERTOTAL.
• F. NV (‘P21_ORDERDATE’) and NV (‘P21_ORDERTOTAL’)

Answer: C

NEW QUESTION 7
What is page zero used for?

• A. To perform page processing
• B. To maintain session state values
• C. To translate application
• D. As a default login page
• E. To display a set of items or buttons on all pages in the application

Answer: E

Explanation:

Page type: Page Zero
Description: A page zero that functions as a master page. The Application Express engine renders all components you add to page zero
on every page within your application. You can further control whether the Application Express engine renders a component or runs a computation, validation, or process by defining conditions.
Reference: Oracle Application Express, Application Builder User’s Guide, Release 3.2

NEW QUESTION 8
You currently have all your users set up in a directory. Which authentication scheme would you select to check the username and password in the directory?

• A. Database Account credentials, from the pre-configured schemes.
• B. Database Access Descriptor (DA
• C. credentials verification, from the pre-configured schemes.
• D. Single Sign On authentication, from the pre-configured schemes.
• E. LDAP credentials verification, from the preconfigured schemes.
• F. Authentication scheme from scratch using the APP-USER function to check for the username and passwor

Answer: D

NEW QUESTION 9
ABC company wants to hide/fade certain columns of his budget. Which function keys should they use?

• A. Use the Dynamic action
• B. Use the plug in a dynamic action
• C. Use the plug in
• D. Create a set value dynamic action with SQL statement

Answer: A

NEW QUESTION 10
Which three actions are performed in the detail pane of the Object Browser?

• A. Enable and disable constraints
• B. View the model of a selected table along with all related tables
• C. Write an SQL statement to update data in a table
• D. Restore dropped database objects
• E. Create UI defaults

Answer: ABE

Explanation:

A: Constraints
Displays a list of constraints for the current table. Actions you can perform include Create, Drop, Enable, and Disable.
B: Model
Displays a graphical representation of the selected table along with all related tables. Related tables are those that reference the current table in a foreign key and those tables referenced by foreign keys within the current table.
E: UI Defaults
Displays user interface defaults for forms and reports. User interface defaults enable developers to assign default user interface properties to a table, column, or view within a specified schema.
Click Edit to edit defined user interface defaults. Click Create to initialize user interface defaults for tables that do not currently have user interface defaults defined.
See the screenshot below:

Note: The Object Browser page is divided into two sections:
* Object Selection pane displays on the left side of the Object Browser page and lists database objects of a selected type within the current schema. You can further narrow the results by filtering on the object name.
* Detail pane displays to the right of the page and displays detailed information about the selected object. To view object details, select an object in the Object Selection pane. Click the tabs at the top of the Detail pane to view additional details about the current object. To edit an object, click the appropriate button.
Reference: Oracle Application Express, SQL Workshop and Utilities Guide Release 3.1.2,About Object Browser

NEW QUESTION 11
You have a complex form that you want to break down into smaller sections with a horizontal line and a label in "bold". Which action achieves the stated objective?

• A. Include <br> <hr> <strong > </strong> tags In Region Source section of the region
• B. Place a Stop and start table item between form elements and set the label for each of these Stop and start table item using a label template
• C. Include multiple <br> tags between form elements
• D. Change the region template to "Form Region"

Answer: B

NEW QUESTION 12
XYZ Corporation wants to develop a new theme for all applications within a workspace. In order for a new theme to be applied to all applications, you must perform these steps.
1) Promote the theme to a workspace theme.
2) Change the theme identification number to a number higher than 100.
3) Modify all applications to switch to the new theme.
4) Copy an existing theme.
5) Navigate to the Themes page.
6) Change the templates in the new theme.
7) Edit the theme definition.
What is the most likely sequence for the steps be performed in?

• A. 4, 5, 7, 1, 2, 6, 3
• B. 4, 5, 3, 7, 2, 6, 1
• C. 5, 4, 7, 2, 3, 1, 6
• D. 5, 4, 2. 7, 1, 6, 3
• E. 5, 4, 3, 6, 1, 2, 7
• F. 4, 5, 3, 1, 7, 2, 6

Answer: D

Explanation:

You can create a theme from scratch or select an existing theme from the repository. To create a theme:
1. (5) Navigate to the Themes page:
2. (4) On the Tasks list, click Copy Theme.
3. On Copy Theme:
a. Copy From Theme - Select the theme you want to copy.
(2) b. Copy to this Theme Identification Number - Enter a new ID for the theme. c. Click Next.
4. Click Copy Theme ID. Etc.
Reference: Oracle Application Express, Application Builder User’s Guide, Release 3.2, Copying a Theme

NEW QUESTION 13
Which four can be exported using the application export utility?

• A. UI defaults
• B. Images
• C. Themes
• D. Schema objects
• E. Application components

Answer: ABCE

Explanation:

Once you export an application and any related files, you need to import them into the
target Oracle Application Express instance before you can install them. As a general rule, always import the application first and then the related files
This section contains the following topics: * Importing an Application or Page (E)
Application groups are exported with an application, application exports include an group ID, name, and comments.
* Importing Cascading Style Sheets
* Importing Images (B)
* Importing Themes (C)
* Importing User Interface Defaults (A)
Reference: Oracle Application Express, Application Builder User’s Guide, Release 3.2, Importing Export Files

NEW QUESTION 14
In your application both page 2 and page 4 branches to page 5. Page 5 has a Cancel button which currently redirects to page 2, however it should redirect to either page 2 or page 4 depending on the originating page. Which three actions need to be performed?

• A. Create two application items: LAST_PAGE and CURRENT_PAGE.
• B. Create an application computation on item LAST_PAGE, computation point Before Header, type PL/SQL Function Body and the computation body as: BEGIN:LAST_PAGE := nvl(:CURKENT_PAGE, :APP_PAGE_I
• C. ; :CURRENT_PAGE := ;APP_PAGE_ID; RETURN :LAST_PAGE; END;
• D. Create an application computation on Item LAST_PAGE, computation point After Submit, type PL/SQL Function Body and the computation body as:BEGIN:LAST_PAGE := :CURRENT_PAGE; :CURRENT_PAGE : = :APP_PAGE_ID; RETURN :LAST_PAGE; END;
• E. On page 5 create a validation to check whether the value stored in application item LAST_PAGE is equal to the value of APP_PREVJ_PAGE_ID where APPJ>REV_PAGE_ID is Built-in Substitution String in Oracle APEX that stores the number of calling page.
• F. On page 5 use the value stored in application item LAST_PAGE to go back to the page from which you browsed to the current page.

Answer: ABE

NEW QUESTION 15
A new column called TEMPLATE (In bold below) was added to an existing Interactive Report query as shown below.
SELECT title, product, release, subproduct, keywords, id, focus_area, template, type, link
FROM content-repository
Which two actions need to be performed so when the report is run, the columns appear as they do in the query on the report by default?

• A. Select Columns and move the TEMPLATE column to be displayed and move it up between FOCUS-AREA and TYPE.
• B. Add a control break on the TEMPLATE column.
• C. Save the Report as Default Settings.
• D. Change the Report attributes so that TEMPLATE is displayed between FOCUS_AREA and TYPE.
• E. Create a sort on the TEMPLATE column.
• F. Reset the Interactive Repor

Answer: AD

Explanation:

A: The new column need to be added to the report. D: Editing Interactive Report Column Attributes
You can use the Column Attributes section of the Report Attributes page to precisely control the report layout. Common Report Column Edits for Interactive Reports include: Alter column display sequence.
Incorrect Option:
B: You can create a break group of one or several columns by selecting Control Break from the Actions menu.
Creating a break group pulls the columns out of the interactive report and displays them as a master record.
C: Saving Default Report Settings Default report settings determine the way a report initially displays to end users. End users can then modify any of the settings.
To save default report settings:
1. Click the Actions menu and select Save Report.
2. From Save, select As Default Report Settings.
3. Click Apply.
F: Resetting a Report
You can reset a report back to the default settings by selecting Reset from the Actions menu. Resetting a report removes any customizations you have made.
Reference: Oracle Application Express, Application Builder User’s Guide, Release 3.2

NEW QUESTION 16
You have 5 buttons in a region. These buttons are of style "HTML Button". Each button is of a different size (depending on the name of the button). How will you ensure that all the buttons are of the same size (150 pixels) and they look uniform?

• A. Set the button attribute for each button to style "width: 150px”.
• B. The size of an HTML Button is always decided based on the label of the button.
• C. Select the button type as "Template Driven". Choose the same template for each button.
• D. Change the button style to "Imag
• E. Create an image-based button of same size for each of the buttons and use them in the application.

Answer: A

NEW QUESTION 17
Choose three actions by which you can set a text item as read-only.

• A. Set the item as Text Field (Disabled, saves state)
• B. Set the item as Password
• C. Navigate to Page Definition > Edit that item > Navigate to Read Only section > Select "Always” from the Read Only Condition Type
• D. Set the item as Text Field (Disabled, does not save state)
• E. Set the item as Text Field (always submits page when Enter pressed)

Answer: ACD

Explanation:

A: Change Items to Display-onlyTo make the item P2_REC_CREATE_DATE display-only:
? Go to the Page Definition for page 2. Click Edit Page 2 on the Developer toolbar.
? Under Items, select the item P2_REC_CREATE_DATE.
? From the Display As list in the Name section, select Text Field (Disabled, saves state).
? Click Apply Changes.
C: Read Only Condition Type:
Defines conditions and expressions that determine if the item displays as read-only. Use this attribute to display certain items to a set of users as updatable, while displaying that same set of items to others users as nonupdatable. Reduces the need to code duplicate interfaces for different users.
D : For Application Item Protection you can use: / Restricted - May not be set from browser The item may not be altered using the URL or POSTDAT
A. Use this option when you want to restrict the way that the item value can be set to internal processes, computations, and so on. This attribute is applicable only to items that cannot be used as data entry items and is always observed even if Session State Protection is disabled.
Use this attribute for application items or for page items with any of these Display As types:
* Display as Text (escape special characters, does not save state)
* Display as Text (does not save state)
* Display as Text (based on LOV, does not save state)
* Display as Text (based on PLSQL, does not save state)
* Text Field (Disabled, does not save state)
* Stop and Start HTML Table (Displays label only)

NEW QUESTION 18
When a user runs an Oracle Application Express application, how is information identified and preserved from one page view to the next for that user?

• A. Using cookies
• B. Using hidden items and regions in the URL
• C. Using Session IDs
• D. Using session state protection
• E. Using authorization schemes

Answer: A

Explanation:

Oracle Application Express assigns new session IDs during authentication processing, records the authenticated user's identity with the session ID, and continually checks the session ID in each page request's
URL or POST data with the session cookie and the session record in the database. These checks provide users with flexibility and security.
While the session ID is the key to session state, the session cookie (where applicable) and the session record safeguard the integrity of the session ID and the authentication status of the user.
Reference: Oracle Application Express Application Builder User's Guide, Understanding Session IDs

NEW QUESTION 19
Marcie, Lauren, and Nancy are part of a project team to create an Inventory Application for ABC industries. The team members need to perform the following activities daily:
• Marcie: Modify application, manage user groups, and view usage reports of her workspace
• Nancy: Manage workspaces, and approve storage requests
• Lauren: Modify database objects, view session state and view application reports. What privileges would you assign to these three users?

• A. Marcie: Developer, Nancy: Developer, Lauren: Workspace Administrator
• B. Marcie: Workspace Administrator, Nancy: Developer, Lauren: Developer
• C. Marcie: Application Express Administrator, Nancy: Workspace Administrator, Lauren: Developer
• D. Marcie: Workspace Administrator, Nancy: Application Express Administrator, Lauren: Developer
• E. Marcie: Workspace Administrator, Nancy: Workspace Administrator, Lauren: Developer

Answer: C

Explanation:

Marcie needs to modify applications and manage users groups so she needs at least the Developer privileges and WorkSpace administrator (not A, not B, not D, not E).
Nancy needs to handle workspaces and approve storage requests so she needs at least the WorkSpace Administrator privileges or Application Express Administrator (not A, not B).
Lauren as a Developer would be fine.
Note: When setting up Application Express users at a large organization, you assign roles and privileges to specific users. The roles within Application Express include the following:
* Workspace administrators are users who perform administrator tasks specific to a workspace such as managing user accounts, monitoring workspace activity, and viewing log files. For this guide, you will be acting as the workspace administrator when setting up the development environment.
* Developers are users who create and edit applications. Developers can have their own workspace or share a workspace.
* End users have no development privileges. You define end users so that they can access applications that do
not use an external authentication scheme.
* Oracle Application Express administrators are superusers that manage an entire hosted instance using the Application Express Administration Services application.

NEW QUESTION 20
Which two statements are true when navigating on a Page Definition window?

• A. an LOV appears only if it is associated with an item on that page.
• B. an Authorization scheme appears only if it is associated with a region on that page
• C. A Region Template appears only if it is associated with an item on that page.
• D. The last updated history for the page would appear.
• E. Images that are referred in the regions on the page appea

Answer: AD

Explanation:

A: The Referenced Components page lists page components and shared components associated with the current page.
Note: A list of values (LOV) is a static or dynamic definition used to display a specific type of page item, such as a radio group, check box, popup list, or select list. LOVs can be static (that is, based on a set of predefined display and return values) or dynamic (based on SQL queries that select values from tables). Once created, an LOV can then be referenced by one or more page items.
You define LOVs at the application level by running the LOV Wizard and adding them to the List of Values repository.
D: The History page displays a history of recent changes to the currently selected page by developer (or user), application, page number, modification date, component, and
action.
Reference: Oracle Application Express, Application Builder User’s Guide, Release 3.2, Understanding the Page Definition

NEW QUESTION 21
......