Oracle Application Express 4: Developing Web Applications v7.1 (1z0-450)

Page:    1 / 4   
Total 56 questions

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 items. Click Edit All to change the Held Template for all your items.
  • C. Navigate to the appropriate Page Definition section and edit each page item.
  • D. Turn on Show Edit Links. Click the small orange icon that appears next to each Item. Change the Field Template for each item from the Edit Page Item window.


Answer : B

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 heading.


Answer : A,B,D

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 Users Guide, Release 3.2,
Configuring Classic Report Region Print Attributes

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 appear.


Answer : A,D

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 Users Guide, Release 3.2,
Understanding the Page Definition

Your manager has asked you to not allow any calculations when viewing an interactive report. Which action would you perform to satisfy this requirement?

  • A. Deselect the Compute and Aggregate actions from the Search Bar while running the report.
  • B. Uncheck the Compute and Aggregate options from the Search Bar section within Report Attributes definition.
  • C. Click Reset from the Actions Menu after deselecting the Compute and Aggregate options.
  • D. Change the column attribute that contains the link specification to remove the Compute and Aggregate options from the Search Bar.
  • E. Remove the Compute and Aggregate options when creating the interactive report.


Answer : E

Explanation: Do not include calculated or aggregated columns in the Report.

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 CUSTOMERS WHERE 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: BEGIB IF :Pi_COUNTRY = 'US' AMD : Pl_PROVINCE IS NULL THEN RETURM FALSE; ELSE RETURN TRUE; END IF; END;
  • C. Create a validation of type PL/SQL Function Returning Boolean and enter the following in the validation method; begin IF :P1_COUNTRY != US' AND ; Pl_PROVINCE IS NULL THEN RETURN FALSE; ELSE RETURN TRUE; END IF; END;


Answer : C

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?

  • A. Include <br> <hr> <strong > </strong> tags In Region Source section of the region
  • B. Place a Stop and start table item between form elements and set the label for each of these Stop and start table item using a label template
  • C. Include multiple <br> tags between form elements
  • D. Change the region template to "Form Region"


Answer : B

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 the application 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 components. Refer this navigation bar entry in the application URL.
  • D. Use the built-in substitution string PAGE_ALIAS.
  • E. As an instance administrator, log in to the Application Express Administration Services. 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

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

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_ORDERDATE. and V (P21_ORDERTOTAL)
  • C. &P21_QRDERDATE. And &P21_ORDERTOTAL.
  • D. NV (‘P21_ORDERDATE’) and NV (‘P21_ORDERTOTAL’)


Answer : C

You can create List of Values for which five types of page items?

  • A. Date Picker
  • B. Select List
  • C. Check Box
  • D. Text Area
  • E. Radio Group
  • F. Shuttle
  • G. Multiple Select list


Answer : B,C,E,F,G

Explanation: A list of values (LOV) is a static or dynamic set of values used to display a specific type of page item, such as popup lists of values, a select list (B), a check box (C), a radio group (E), or multiple select lists (G).
Note:
Shuttle:
Renders as a multiple select list that includes two boxes containing lists. The left list displays a source list of values. Users use the shuttle control icons and buttons to select list items and move them from the left (source) list to the right
(destination) list.

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 Users Guide, Release 3.2,

Copying a Theme -

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 : A,B,E

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 Users Guide, Release 3.2,
Creating a Page from the Application Home Page

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 -

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

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 : B,C

Page:    1 / 4   
Total 56 questions