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?
Answer : B
Values of which three items can be set from the Print Attributes page of a SQL Query report?
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?
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?
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?
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?
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?
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?
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.
Answer : C
You can create List of Values for which five types of page items?
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?
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?
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
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?
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?
Answer : B,C