Oracle 1Z0-450 Dumps Questions 2021

NEW QUESTION 1
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 2
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 3
View the Exhibit. A Master-Detail page was created. Which option would a developer choose in the Master- Detail wizard to scroll through records in the Master table?

• A. Include master row navigation.
• B. Master row navigation order.
• C. Secondary navigation order.
• D. Include master repor

Answer: A

NEW QUESTION 4
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 5
Which two actions can be performed using the Object Browser?

• A. Browse database objects of the current schema
• B. Build and save SQL queries
• C. Transfer SQL scripts between schemas
• D. Create a lookup table based on a column in the current table
• E. Display APEX View reports

Answer: AD

Explanation:
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.
D: When you view a table in Object Browser, the table description appears. While viewing this description, you can add a column, modify a column, rename a column, drop a column, rename the table, copy the table, drop the table, truncate the table, or create a lookup table based upon a column in the current table.
Reference: Oracle Application Express, SQL Workshop and Utilities Guide Release 3.1.2, Browsing a Table

NEW QUESTION 6
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 7
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 8
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 9
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 10
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 11
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 12
You want to refer to a page by a name (or alias) Instead of by the page number in the application URL which action most accurately achieves the stated objective?

• A. Enter an alphanumeric alias in the Page Alias field on the Page Attributes page and refer this alias in theapplication URL as f?p=myapp:page_alias:&APP_SESSION.
• B. Enter an alphanumeric name in the Title field on the Page Attributes page and refer this title in the application URL.
• C. Create Navigation bar Entry for the page from the application's shared component
• D. Refer this navigation bar entry in the application URL.
• E. Use the built-in substitution string PAGE_ALIAS.
• F. As an instance administrator, log in to the Application Express Administration Service
• G. Go to Manage Services > Feature Configuration > Application Development and set the value to 'Yes' for Refer a page by name (or alias) in the application URL and click Apply Changes.

Answer: A

NEW QUESTION 13
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 14
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 15
You have created an access control list. Which authorization scheme would you select to control access to an application or a page component?

• A. Access control 1 update
• B. Restricted acces
• C. Only users defined in the access control list are allowed
• D. Public read onl
• E. Edit and administrative privileges controlled by access control list
• F. Access control - view
• G. Administrative access only

Answer: D

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