1Z0-450 Exam Questions
49 real 1Z0-450 exam questions with expert-verified answers and explanations. Page 1 of 1.
- Question #1Setting Up ODI Components
What is page zero used for?
page zeroshared componentsapplication pagesglobal page - Question #2Setting Up ODI Components
Which two actions are true about creating lists?
listslist entrieshierarchical listslist templates - Question #3Setting Up ODI Components
Which three actions are performed in the detail pane of the Object Browser?
Object BrowserconstraintsUI defaultsSQL interface - Question #5Setting Up ODI Components
You can set the value of an item in your application by using which four methods?
session stateform submissioncomputationsHTTP request - Question #6Developing Integration Mappings
View the Exhibit. To display only the names of all cities In Italy, you could perform which two tasks?
SQL queriesQuery Builderdata filteringtable joins - Question #7Setting Up ODI Components
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?
templatesshared componentsutilization tabpage references - Question #8
Where would you specify data load scripts that need to run as part of installing your application?
- Question #9
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)
- Question #10
ABC company wants to hide/fade certain columns of his budget. Which function keys should they use?
- Question #11
ABC company wants to set up his email accounts using APEX and wants to eliminate nulls before they are receiving. How to do that?
- Question #12Setting Up ODI Components
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?
tab setstab definitionpage-level displayregion templates - Question #13Building Forms and Reports
The Interactive Report is displayed in Exhibit 2 Which combination of three actions would need to take place to create the interactive report?
interactive reporttable joinscontrol breakcolumn concatenation - Question #14
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 Exh...
- Question #17
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...
- Question #18
You have created an access control list. Which authorization scheme would you select to control access to an application or a page component?
- Question #19
Which two are true about creating interactive reports?
- Question #20Implementing Security
Which two statements is true relating to authentication in Oracle Application Express?
authenticationauthentication schemesession stateuser identity - Question #21
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...
- Question #22Developing and Deploying Applications
Which four can be exported using the application export utility?
application exportUI defaultsthemesapplication components - Question #23Building Forms and Reports
Which two actions are true about creating a form based on a table with a report?
form wizardreport form combinationtable viewwizard pages - Question #24Building Forms and Reports
Which four actions can be performed when you click the Reorder Region Items Icon under items on a page definition page?
region itemsreorder itemsitem propertiespage definition - Question #25Working with Shared Components
Which two actions are true about using standard and parent tabs?
standard tabsparent tabspage templatetab authorization - Question #26Building Forms and Reports
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,...
interactive reportcolumn displaydefault report settingsreport attributes - Question #28Introduction to APEX and Architecture
Which two actions can be performed using the Object Browser?
Object Browserdatabase schemalookup tableschema objects - Question #29Building Forms and Reports
Which three statements are true about a wizard-generated tabular form?
tabular formmultiple record updatewizard generated formupdateable columns - Question #30Implementing Security
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: - Marci...
user privilegesworkspace administratorAPEX administratordeveloper role - Question #31
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...
- Question #32
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...
- Question #33Building Forms and Reports
Values of which three items can be set from the Print Attributes page of a SQL Query report?
print attributesreport output formatcolumn widthSQL report - Question #34Introduction to APEX and Architecture
Which two statements are true when navigating on a Page Definition window?
page definitionLOVpage historyauthorization scheme - Question #35Building Forms and Reports
Your manager has asked you to not allow any calculations when viewing an interactive report. Which action would you perform to satisfy this requirement?
interactive reportcomputeaggregatereport attributes - Question #36
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 t...
- Question #37
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?
- Question #38
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?
- Question #39
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 200...
- Question #40
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 Exhibi...
- Question #41Working with Shared Components
You can create List of Values for which five types of page items?
list of valuesselect listradio grouppage item types - Question #42Working with Shared Components
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) P...
theme managementworkspace themetheme templatestheme switching - Question #43Building Forms and Reports
You can use Query Builder when creating which three region types?
Query Builderregion typeschart regionsFlash Chart - Question #44
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?
- Question #45Introduction to APEX and Architecture
Which two actions are associated with page rendering?
page renderingpage processingcomputationsession state - Question #46Building Forms and Reports
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...
page itemsform field typesitem visibilitytext item - Question #47Building Forms and Reports
Choose three actions by which you can set a text item as read-only.
read-only itemstext field disableditem propertiespage definition - Question #49
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?
- Question #51Building Forms and Reports
After creating buttons in a region position, you cannot change the position of the buttons to
button positionsregion templatepage titlebutton placement - Question #52
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 Proc...
- Question #53
ABC Company wants to change the font color of a Region Title to blue. Which two actions could be performed to accomplish this task?
- Question #54
Which three are valid process types of a Page Process?
- Question #55Developing and Deploying Applications
Which three steps are presented when importing an application?
application importbuild statusfile character setdeployment steps