Approved 1Z0-450 Exam Questions 2021

NEW QUESTION 1
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 2
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 3
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 4
ABC company wants to set up his email accounts using APEX and wants to eliminate nulls before they are receiving. How to do that?

• A. Use SQL query
• B. Use authorization scheme
• C. Use dynamic action
• D. Use validation
• E. Use the help tab

Answer: D

NEW QUESTION 5
The Order Totals page in the Orders application includes a link to January 2009 that should link to a calendar view of the order totals for that month. But if you click January 2009, it displays the calendar for the current month instead of January 2009. What action should you perform to rectify this?

• A. Modify the display attributes of the calendar.
• B. Edit the P<n>_CALENDAR_DATE hidden item and replace the default value with 20090101.
• C. Edit the P<n>_CALENDAR_DATE hidden item to specify a condition.
• D. Edit the P<n>_CALENDAR_DATE hidden item to replace the default value with 20090101 and select Static Text with Session State Substitutions for the default value type.

Answer: D

NEW QUESTION 6
Which two are true about creating interactive reports?

• A. A form and Interactive' -report can be created at the same time,
• B. An interactive report must be baseiHHp SQL Query.
• C. All the columns must be shown in the Interactive repor
• D. D . Only one interactive report can be defined on a page.
• E. More than one Interactive report can be viewed on a pag

Answer: AD

NEW QUESTION 7
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 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
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 10
User Details form page is page 1 in your application. On this page the end user is required to provide his Name and Address details- You need to create a validation that requires the end user to enter a province if the country is not the United States (US).
Which action needs to be performed?

• A. Create a validation of type SQL and enter the following in the validation method; SELECT 1 FROM CUSTOMERSWHERE COUNTRY= ‘US' AMD PROVINCE IS NULL
• B. Create a validation of type PL/SQL Function Returning Boolean and enter the following in the validation method:BEGIBIF :Pi_COUNTRY = 'US' AMD : Pl_PROVINCE IS NULL THEN RETURM FALSE; ELSERETURN TRUE; END IF; END;
• C. Create a validation of type PL/SQL Function Returning Boolean and enter the following in the validation method;beginIF :P1_COUNTRY != ‘US' AND ; Pl_PROVINCE IS NULL THEN RETURN FALSE; ELSERETURN TRUE; END IF; END;

Answer: C

NEW QUESTION 11
Which two actions are true about creating lists?

• A. you can track clicks on list entries.
• B. All list templates support hierarchical lists.
• C. Once created; you cannot update the parents of list entries.
• D. you can edit multiple list entries simultaneously.
• E. You can add to a list directly from the page definition pag

Answer: DE

Explanation:
D: You can edit multiple list entries simultaneously by clicking Grid Edit on the List Entries page.
E:
To add a list to a page:
1. Navigate to the appropriate Page Definition.
2. On the Page Definition, add a list region:
*Tree view - Under Page Rendering, right-click Regions and select Create. * Component view - Under Region, click the Create icon.
The Create Region Wizard appears.
3. For Region, select List as the region type and click Next.
4. For Display Attributes, specify the following and click Next Etc.
Reference: Oracle Application Express, Application Builder User’s Guide, Release 3.2, Creating Lists

NEW QUESTION 12
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 13
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 14
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 15
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 16
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 17
You created a page that includes a form based on a Table along with associated Report. When you click the "Create" button in the report page, the form appears. You observe that you are unable to view P2_SALARY item. How do you make sure that you can view and enter a value through this form?

• A. Do nothin
• B. The Create Form wizard assumes that a sequence, trigger, or both will populate the primary key of the for
• C. It therefore has to remain as a hidden item.
• D. Change the type of P2_SALARY to display only.
• E. Change the type of P2_SALARY to text.
• F. Change the type of P2_SALARY to text and add a computation to populate the ite

Answer: C

Explanation:
A text field most be used to allow the user to enter data.

NEW QUESTION 18
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