Latest 1Z0-450 Item Pool 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
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 3
Your application includes a standard tab set TS1 with two tabs. You want the tabs to show up only in page 1 but not in page 2. Which actions achieve the stated requirement?

• A. Edit the tab definitio


• B. In the Tab Also Current for Pages field, specify the page number for which the tab is to be rendered.


• C. Edit the tab definitio


• D. Select "Current page Expression 1" for Condition Type and then specify page 1 in the "Expression 1* fiel


• E. Repeat this process for the other tab.


• F. Edit the tab definitio


• G. Select "Current page is NOT in Expression 1" for Condition Type and then specify the page number for which the tab is to render in the "Expression 1" field.


• H. Change the region template on the page where the tabs should not be rendere

Answer: B

Explanation:

B (not A): Even though you set the current for, the tab will still be visible. Only if you use a condition (or authorization) will the table disappear.

NEW QUESTION 4
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 5
You are testing a completed application from within your workspace. You would like to change the Field Template of all your form items from "Optional Label with Help" to "Required Label". Identify the best possible option to accomplish this?

• A. Navigate to the appropriate page and dick the region name link within the Items section.


• B. Navigate to the page that holds these item


• C. Click Edit All to change the Held Template for all your items.


• D. Navigate to the appropriate Page Definition section and edit each page item.


• E. Turn on Show Edit Link


• F. Click the small orange icon that appears next to each Ite


• G. Change the Field Template for each item from the Edit Page Item window.

Answer: B

NEW QUESTION 6
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 7
In your Orders application, you created a 30 Pie Flash chart page to display products by category. You provided the following query:
Select null link, category_name# count (*) from (SELECT CASE WHEN (category_id between 10 and 19) THEN 'Television1 WHEN (category_id between 20 and 29) THEN 'Computer1 ELSE 'Others1
END category_name
VMM new_product. Group by category_name order by 1
View the Exhibit. What action should you perform to display the chart title and the total number of products under each category without using custom XML?

• A. Edit the Flash Chart region to select the Show Values check box.


• B. Modify the query to display the value and edit the Flash Chart region to display the chart title


• C. Edit the Flash Chart region to specify the chart title and select the Show Values check box.


• D. Edit the Flash Chart region to specify the chart titl

Answer: C

NEW QUESTION 8
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 9
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 10
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 11
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 12
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 13
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 14
After creating buttons in a region position, you cannot change the position of the buttons to

• A. Bottom of the region


• B. Above or below the region


• C. In any button position defined in the region template


• D. To the left or the right of the page title


• E. Among this region's Items

Answer: B

Explanation:

The position of the button must be within the region.
Create a button in a region position - Select this option to place the button in a region position. A region position is a position defined by a region template.
Note 1:
For Display Properties:
If the button position is Create a button in a region position:
* Sequence - Enter the sequence for this component. The sequence determines the order of evaluation.
* Position - Select a position for this button.
* Alignment - Select Right or Left.
Note 2: A region is a area on a page that serves as a container for content. Each page can have any number of regions. You control the appearance of a region through a specific region template. The region template controls the look of the region, the size, determines whether there will be a border or a background color, and what type of fonts display. A region template also determines the standard placement for any buttons placed in region positions.
You can use regions to group page controls (such as items or buttons).
Reference: Oracle Application Express Application Builder User's Guide, Creating Buttons Reference: Oracle Application Express Application Builder User's Guide,
Understanding Regions

NEW QUESTION 15
Which three steps are presented when importing an application?

• A. Specify where to store the imported application


• B. Browse to the file location and select the name of the file to be imported


• C. Select how to resolve Application ID conflicts


• D. Select the parsing schema and build status


• E. Select the database character set

Answer: BCD

Explanation:

To import an Application or Page Export into a target Oracle Application Express instance:
1. Navigate to the Import page
(B) 2. For Specify File, specify the following:
a. Import file - Click Browse and navigate to the file.
b. File Type - Select Application, Page, or Component Export.
c. Verify that File Character Set is correct.
d. Click Next.
Once you import a file, you have the option to install it.
3. To install an imported file, click Next.
4. In the Install Application wizard, specify the following:
(D) a. Parsing Schema - Select a schema. b. Build Status
(C) c. Install As Application - Select one of the following:
– Auto Assign New Application ID
– Reuse Application ID From Export File
– Change Application ID
Use these options to avoid application ID conflicts. These options come in handy when you have two versions of the same application in the same instance. For example, you might be migrating an application to a production instance and still need to maintain the development version.
Reference: Oracle Application Express, Application Builder User’s Guide, Release 3.2, To import an Application or Page Export into a target Oracle Application Express

NEW QUESTION 16
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 17
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 18
There are four departments listed as radio group, appearing one below the other in a form (View Exhibit A). You want to edit the item attributes so that they appear as shown in Exhibit B (horizontally, next to each other). Which action would you take to satisfy this requirement?
Exhibit A

• A. Change "Begin on new Line" attribute of radio group to No and set "Begin on New Field" attribute to Yes.


• B. Change "Begin on new Line" attribute of radio group to Yes and set "Begin on New field" attribute to Yes.


• C. Change "Begin on new Line” attribute of radio group to No and set "Begin on New field" attribute to No.


• D. Edit the List of Values section for the ite


• E. Change the "Number of Columns" attribute to the number of columns that should be displayed horizontally.


• F. Edit the List of Values In Shared Component


• G. Specify the number of columns that you want the List of Values to span.

Answer: D

NEW QUESTION 19
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 20
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 21
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 22
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 23
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 24
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 25
......