Oracle 1Z0-450 Pdf 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
You can create List of Values for which five types of page items?

• A. Date Picker
• B. Select List
• C. Check Box
• D. Text Area
• E. Radio Group
• F. Shuttle
• G. Multiple Select list

Answer: BCEFG

Explanation:

A list of values (LOV) is a static or dynamic set of values used to display a specific
type of page item, such as popup lists of values, a select list (B), a check box (C), a radio group (E), or multiple select lists (G).
Note: Shuttle:
Renders as a multiple select list that includes two boxes containing lists. The left list displays a source list of values. Users use the shuttle control icons and buttons to select list items and move them from the left (source) list to the right (destination) list.

NEW QUESTION 3
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 4
You can use Query Builder when creating which three region types?

• A. Interactive Report
• B. SQL Report
• C. Master-Detail Form
• D. Form on a Table
• E. Flash Chart

Answer: ABE

Explanation:

Query Builder enables you to define queries by dragging and dropping tables and easily create relationships between objects.
A: Interactive Report - Creates an interactive report based on a custom SQL SELECT statement you provide. For assistance in writing the SQL query, click the Query Builder button.
B: SQL Report - Creates a report based on a custom SQL SELECT statement or a PL/SQL function returning a SQL SELECT statement that you provide. For assistance in writing the SQL query, click the Query Builder button.
E: See step 8a) below.
Adding a Flash Chart to an Existing Page To add a flash chart to an existing page:
1. Navigate to the Page Definition. See "Accessing a Page Definition" on page 5-2. 2. Under Regions, click the Create icon.
The Create Region Wizard appears. 3. Select Chart and click Next.
4. For Region, select Flash Chart.
5. For Display Attributes
6. On Chart Preview, configure the chart attributes. Click Update to refresh the preview image.
7. Click Next.
8. For Source:
a. Specify a query by either:
– Entering a SQL query in the field provided.
– Clicking the Build Query button. When the Build Chart Query Wizard appears, follow the on-screen instructions.
b. Specify relevant chart attributes. To learn more, click the item label.
9. Click Create Region.
Reference: Oracle Application Express, Application Builder User’s Guide, Release 3.2, Creating a Page from the Application Home Page

NEW QUESTION 5
Which three statements are true about a wizard-generated tabular form?

• A. Only allows you to update one record at a time.
• B. Allows you to add and update multiple records at a time.
• C. You can drill down to a detail record view.
• D. Allows you to add more than one record at a time.
• E. Only allows you to change the updateable column

Answer: BDE

Explanation:

A tabular form enables users to update multiple rows in a table. The Tabular Form Wizard creates a form to perform update, insert, and delete operations on multiple rows in a database table.
Reference: Oracle Application Express, Application Builder User’s Guide, Release 3.2, Creating a Tabular Form

NEW QUESTION 6
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 7
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 8
The Interactive Report is displayed in Exhibit 2

Which combination of three actions would need to take place to create the interactive report?

• A. Create an Interactive Report region to show the list of EMPLOYEES and PRODUCTS based on the Customer ID.
• B. Create an Interactive Report region that contains a query between the CUSTOMERS, EMPLOYEES, PRODUCTS and SALES table.
• C. Create an SQL Report region that contains a query between the CUSTOMERS, PRODUCTS and SALES tables only.
• D. Create a filter on Customer FIRST_NAME and LAST_NAME.
• E. Create a Control Break on Sales Representative.
• F. Concatenate FIRST_NAME and LAST NAME for both CUSTOMERS and EMPLOYEES in the quer

Answer: BEF

Explanation:

B: The report needs to access data from all four tables.
E: 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.
F: The concatenated names of the Sales Representative (from Employee table) and the concatenated names of Customers are used.
Note: Interactive reports include components that enable users to alter the layout of report data. Users can select
columns, create filters, apply highlighting, sort columns, define break groups, aggregate columns, create charts, and define computations. Once customized, users can then save an interactive report as named report and download
the data to various file formats.

NEW QUESTION 9
ABC Company wants to change the font color of a Region Title to blue. Which two actions could be performed to accomplish this task?

• A. Use a standard class in the template definition for #TTTL£#.
• B. Add a font tag around the substitution #TITLE# found in the region template definition.
• C. Reference a class from a cascading style sheet that changes the text color to the desired color and apply that class in the HTML that immediately precedes the substitution #TITLE# found hi the region template definition.
• D. Add a font class that contains the desired color to the Region Header field in the Region Definition.
• E. Add an APEX standard class to the header for the page.

Answer: BC

NEW QUESTION 10
You can set the value of an item in your application by using which four methods?

• A. Form submission
• B. By using built-in substitution strings
• C. Using bind variables to reference session state of a specified item
• D. Application or page computations
• E. By invoking the f procedure in an HTTP request

Answer: ABDE

Explanation:

A: When the page is submitted, Oracle Application Express captures the value entered in the field and stores the value for future use.
B: You can use substitution strings in Application Builder in the following ways:
* Include a substitution string within a template to reference component values
* Reference page or application items using &ITEM. syntax
* Use built-in substitution strings to achieve a specific type of functionality
Application Builder supports a number of built-in substitution strings. You may need to reference these values to achieve specific types of functionality.
Example: APP_SESSIONAPP_SESSION is one of the most commonly used built-in substitution strings. You can use this substitution string to create hypertext links between application pages that maintain a session state by passing the session number. Note that you can also use the substitution string SESSION in place of APP_SESSION.
E: The "f" procedure is widely known and well covered in the Oracle APEX User Guide. The following example resets the value of the items THE_EMPNO and THE_DEPTNO. f?p=100:5:&APP_SESSION.::NO:THE_EMPNO,THE_DEPTNO
Note:
It can be used to create links between pages in your application using the following syntax: f?p=App:Page:Session:Request:Debug:ClearCache:itemNames:itemValues:PrinterFriendly

NEW QUESTION 11
Which two actions are true about using standard and parent tabs?

• A. To use parent tabs, you must use a page template that supports them.
• B. You cannot apply authorization at standard tab level.
• C. You can resequence the display order of standard tabs.
• D. When you create or edit a standard tab, for the Tab Label attribute, you cannot use substitution value

Answer: AC

Explanation:

A: Before you can create parent and standard tabs, you must check that your default
template has positions defined for both standard and parent tabs using the appropriate substitution strings. You also must make sure you do not override this template at the page-level.
C: The Standard Tab Task list displays on the right side of the Tabs page. You can access the links on this list to rename a standard tab set, resequence the display order, associate pages with a tab set, create a new standard tab, or create a new standard tab set.
Note: Tabs
Tabs are an effective way to navigate between pages of an application. Application Builder includes two types of tabs: standard tabs and parent tabs.
An application having only one level of tabs uses a standard tab set. A standard tab set is associated with a specific page. You can use standard tabs to link users to other pages within your application. A parent tab set functions as a container to hold a
group of standard tabs. Parent tabs give users another level of navigation and context (or sense of place) within the application.
Reference: Oracle Application Express, Application Builder User’s Guide, Release 3.2, Using the Standard Tab Task List

NEW QUESTION 12
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 13
Which two actions are associated with page rendering?

• A. The process of generating a page from the Database.
• B. The process of submitting a page.
• C. A validation check on a user input field to verify that the entered value is numeric.
• D. A DML page process inserting records into a table after the Form Page is submitted.
• E. A computation which sets the session state with process point 'On Load - Before Heade

Answer: AE

Explanation:

A: The Application Express engine dynamically renders and processes pages based on data stored in Oracle database tables.
E: On Load: Before Header - Branching occurs before a page is rendered. This option displays another page instead of the current page or redirects the user to another URL or procedure.
Reference: Oracle Application Express, Application Builder User’s Guide, Release 3.2, How the Application Express Engine Renders and Processes Pages

NEW QUESTION 14
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 15
Values of which three items can be set from the Print Attributes page of a SQL Query report?

• A. View report as an attachment or inside the browser window.
• B. Report output format.
• C. Print server port.
• D. Report column width.
• E. Report column headin

Answer: ABD

Explanation:

A: View File As - Select how the Web browser opens the report query document.
Options include:
– Attachment - Displays a File Open/Save dialog box when the user clicks the report query download button.
– Inline - Displays the report query document inside the Browser window. B: Output Format - Select an output option.
D: Under Report Columns, specify the width for each column.
Reference: Oracle Application Express, Application Builder User’s Guide, Release 3.2, Configuring Classic Report Region Print Attributes

NEW QUESTION 16
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 17
ABC Company wants to see which pages use the Reports - Standard template in a particular application. What three actions can be performed to find this information?

• A. Open each page in the application and review the templates section.
• B. Open the template and review the pages it references.
• C. Select the Utilization tab and view the pages referenced from the Shared Components > Templates page.
• D. Select the references link for the template on the > Template page.
• E. Preview the template to see the list of pages that reference i

Answer: ACD

Explanation:

A: This is an awkward and time consuming solution. C: Viewing Template Reports
Application Builder includes reports describing template utilization, subscription, published templates and edit history.
To view template reports for the current application:
? Navigate to the Templates page.
? You can narrow the display by making a selection from the following lists and clicking Go.
? To view template reports, click the following tabs:
Reference: Oracle Application Express Application Builder User's Guide, Viewing Template Reports

NEW QUESTION 18
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 19
Which three are valid process types of a Page Process?

• A. Automatic Row Processing (DML)
• B. PL/SQL
• C. Clear Cache for Items (ITEM, ITEM, ITEM)
• D. Static Assignment
• E. Form Pagination

Answer: ABE

Explanation:

A: Process Category Data Manipulation:
Data Manipulation process types are frequently used by wizards to support data manipulation language (DML) actions. Application Builder supports the following declarative
B: Process Category PL/SQL:
Runs the PL/SQL you provide. Use this process type to execute a block of PL/SQL entered directly into the process or to simply call an existing API.
E: Process Category: Form Pagination
Implements pagination through the detail records associated with a master detail form.
Note: Processes are logic controls used to execute data manipulation language (DML) or PL/SQL. Processes are executed after the page is submitted.
Reference: Oracle Application Express, Application Builder User’s Guide, Release 3.2, Creating a Page Process

NEW QUESTION 20
View the Exhibit. To display only the names of all cities In Italy, you could perform which two tasks?

• A. Run the following SQL query in the SQL Commands worksheet are
• B. SELECT location
• C. City FROM locations, countriesWHERE countries.country_id=locations.country_id AND Countrie
• D. country name=f Italy’;
• E. Use Query Builder to select the countries and locations table
• F. Create a join between the two tables by using the country_id colum
• G. Then, select the city column in the locations table and country_name column in the countries tabl
• H. For the country_name, specify the condition = ' Italy’.
• I. Use Query Builder to select the countries and locations table
• J. Select the country_id column in both the tables and create a join between the
• K. Then, select the city column in the locations table and country_name column in the countries tabl
• L. For the country name, specify the condition ‘Italy’.
• M. Run the following SQL query in the SQL Commands worksheet are
• N. SELECT locations, city FROM locations, countriesWHERE countries.country_name=’Italy’;
• O. Use Query Builder to select the countries and locations table
• P. Create a join between the two tables by using the country_id colum
• Q. Then, select the city column in the locations table and country_name column in the countries tabl
• R. For the country_name, specify the condition =‘Italy'. Uncheck the Show check box for country_name.

Answer: AE

Explanation:

A (not D): The WHERE constraints " countries.country_id=locations.country_id" ensures that a correct join is made on the two tables.
Only the City column in displayed through the SELECT statement E: Join between the tables.
Put a condition on the Country_name. Only display the City column

NEW QUESTION 21
You are testing a customer entry form that is part of an Order Processing application. When you open the form the first time, enter data, and click 'Submit", a message "Action Processed" is displayed and data is inserted into the underlying table. However, when you open the page again, it displays old data In place of a blank new form. How do you ensure that a blank form is displayed so that you can enter new customer data?

• A. Modify the branch for the "Submit" button to clear the cache for the page or items on the page.
• B. Select "Always, replacing any existing value in session state" from Source Used field for each form item on the page.
• C. Set Caching to "Not Cached" for the region that hosts the customer entry form.
• D. Set Caching to "Not Cached" for the page that hosts the customer entry form.
• E. Set the "Maintain session state* item property to "Per Session".

Answer: B

NEW QUESTION 22
Which two statements is true relating to authentication in Oracle Application Express?

• A. It is a process of establishing user identity before the user can access an application.
• B. An authentication scheme can be specified for an entire application, page, or specific components Such as item, button and regions on a page.
• C. An authentication scheme prevents a user from accessing session state belonging to other users.
• D. An authentication scheme helps a user to reestablish their session when they log back into an application allowing them to bookmark the application.
• E. An authentication scheme can only be applied to one applicatio

Answer: AC

Explanation:

A: Authentication establishes the identity of each user who accesses your application. Authentication is the process of establishing each user's identify before they can access your application. Authentication may require a user identify a user name and password or could involve the use of digital certificates or a secure key.
C: When running custom authentication, Oracle Application Express attempts to prevent two improper situations:
* Intentional attempts by a user to access session state belonging to someone else. However, users can still type in an arbitrary application session ID into the URL.
* Inadvertent access to a stale session state (probably belonging to the same user from an earlier time). This
would commonly result from using bookmarks to application pages.
Reference: Oracle Application Express, Application Builder User’s Guide, Release 3.2, Using Preconfigured Authentication Schemes

NEW QUESTION 23
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 24
......