Oracle Application Express 4: Developing Web Applications
Question No: 11
What is page zero used for?
To perform page processing
To maintain session state values
To translate application
As a default login page
To display a set of items or buttons on all pages in the application
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
Question No: 12
Which four can be exported using the application export utility?
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
Question No: 13
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?
Database Account credentials, from the pre-configured schemes.
Database Access Descriptor (DAD. credentials verification, from the pre-configured schemes.
Single Sign On authentication, from the pre-configured schemes.
LDAP credentials verification, from the preconfigured schemes.
Authentication scheme from scratch using the APP-USER function to check for the username and password.
Question No: 14
Which two actions are associated with page rendering?
The process of generating a page from the Database.
The process of submitting a page.
A validation check on a user input field to verify that the entered value is numeric.
A DML page process inserting records into a table after the Form Page is submitted.
A computation which sets the session state with process point #39;On Load – Before Header.
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
Question No: 15
You created a page that includes a form based on a Table along with associated Report. When you click the quot;Createquot; 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?
Do nothing. The Create Form wizard assumes that a sequence, trigger, or both will populate the primary key of the form. It therefore has to remain as a hidden item.
Change the type of P2_SALARY to display only.
Change the type of P2_SALARY to text.
Change the type of P2_SALARY to text and add a computation to populate the item.
Explanation: A text field most be used to allow the user to enter data.
Question No: 16
Choose three actions by which you can set a text item as read-only.
Set the item as Text Field (Disabled, saves state)
Set the item as Password
Navigate to Page Definition gt; Edit that item gt; Navigate to Read Only section gt; Select quot;Always” from the Read Only Condition Type
Set the item as Text Field (Disabled, does not save state)
Set the item as Text Field (always submits page when Enter pressed)
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 POSTDATA. 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)
Question No: 17
Which two actions are true about creating a form based on a table with a report?
This wizard builds two pages, the first page for the report and the second page for the form.
The first page provides users with the ability to update the selected table or view.
This report and form combination is based on a single table or view.
The second page enables users to specify the row to be updated.
This report and form combination can be based on more than one table or view.
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.
Question No: 18
Which four actions can be performed when you click the Reorder Region Items Icon
under items on a page definition page?
Reorder the Items within a region
Change the label of an item
Change the Display as for the Item
Change the label alignment for an Item
Control whether an item should appear on a new line or create a new field
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
Question No: 19
Which two actions are true about using standard and parent tabs?
To use parent tabs, you must use a page template that supports them.
You cannot apply authorization at standard tab level.
You can resequence the display order of standard tabs.
When you create or edit a standard tab, for the Tab Label attribute, you cannot use substitution values.
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
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
Question No: 20
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
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?
Select Columns and move the TEMPLATE column to be displayed and move it up between FOCUS-AREA and TYPE.
Add a control break on the TEMPLATE column.
Save the Report as Default Settings.
Change the Report attributes so that TEMPLATE is displayed between FOCUS_AREA and TYPE.
Create a sort on the TEMPLATE column.
Reset the Interactive Report.
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.
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:
Click the Actions menu and select Save Report.
From Save, select As Default Report Settings.
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
100% Ensurepass Free Download!
–Download Free Demo:1z0-450 Demo PDF
100% Ensurepass Free Guaranteed!
–Download 2018 EnsurePass 1z0-450 Full Exam PDF and VCE
EnsurePass ExamCollection Testking Lowest Price Guarantee Yes No No Up-to-Dated Yes No No Real Questions Yes No No Explanation Yes No No PDF VCE Yes No No Free VCE Simulator Yes No No Instant Download Yes No No