NEW QUESTION 1
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 2
What is page zero used for?

• A. To perform page processing
• B. To maintain session state values
• C. To translate application
• D. As a default login page
• E. To display a set of items or buttons on all pages in the application

Answer: E

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

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

Answer: B

NEW QUESTION 6
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)

• A. Create a page navigation
• B. Create a data grid
• C. Create a data section based on data from a data grid
• D. Add a text section to a page
• E. Use a SQL queryF Create a section navigation

Answer: BC

NEW QUESTION 7
View the Exhibit. To display only the names of all cities In Italy, you could perform which two tasks?

• A. Run the following SQL query in the SQL Commands worksheet are
• B. SELECT location
• C. City FROM locations, countriesWHERE countries.country_id=locations.country_id AND Countrie
• D. country name=f Italy’;
• E. Use Query Builder to select the countries and locations table
• F. Create a join between the two tables by using the country_id colum
• G. Then, select the city column in the locations table and country_name column in the countries tabl
• H. For the country_name, specify the condition = ' Italy’.
• I. Use Query Builder to select the countries and locations table
• J. Select the country_id column in both the tables and create a join between the
• K. Then, select the city column in the locations table and country_name column in the countries tabl
• L. For the country name, specify the condition ‘Italy’.
• M. Run the following SQL query in the SQL Commands worksheet are
• N. SELECT locations, city FROM locations, countriesWHERE countries.country_name=’Italy’;
• O. Use Query Builder to select the countries and locations table
• P. Create a join between the two tables by using the country_id colum
• Q. Then, select the city column in the locations table and country_name column in the countries tabl
• R. For the country_name, specify the condition =‘Italy'. Uncheck the Show check box for country_name.

Answer: AE

Explanation:
A (not D): The WHERE constraints " countries.country_id=locations.country_id" ensures that a correct join is made on the two tables.
Only the City column in displayed through the SELECT statement E: Join between the tables.
Put a condition on the Country_name. Only display the City column

NEW QUESTION 8
Which three statements are true about a wizard-generated tabular form?

• A. Only allows you to update one record at a time.
• B. Allows you to add and update multiple records at a time.
• C. You can drill down to a detail record view.
• D. Allows you to add more than one record at a time.
• E. Only allows you to change the updateable column

Answer: BDE

Explanation:
A tabular form enables users to update multiple rows in a table. The Tabular Form Wizard creates a form to perform update, insert, and delete operations on multiple rows in a database table.
Reference: Oracle Application Express, Application Builder User’s Guide, Release 3.2, Creating a Tabular Form

NEW QUESTION 9
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_ORDERDAT
• C. and V (P21_ORDERTOTAL)
• D. &P21_QRDERDAT
• E. And &P21_ORDERTOTAL.
• F. NV (‘P21_ORDERDATE’) and NV (‘P21_ORDERTOTAL’)

Answer: C

NEW QUESTION 10
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 11
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: BCEFG

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.

NEW QUESTION 12
Which two are true about creating interactive reports?

• A. A form and Interactive' -report can be created at the same time,
• B. An interactive report must be baseiHHp SQL Query.
• C. All the columns must be shown in the Interactive repor
• D. D . Only one interactive report can be defined on a page.
• E. More than one Interactive report can be viewed on a pag

Answer: AD

NEW QUESTION 13
Which three actions are performed in the detail pane of the Object Browser?

• A. Enable and disable constraints
• B. View the model of a selected table along with all related tables
• C. Write an SQL statement to update data in a table
• D. Restore dropped database objects
• E. Create UI defaults

Answer: ABE

Explanation:
A: Constraints
Displays a list of constraints for the current table. Actions you can perform include Create, Drop, Enable, and Disable.
B: Model
Displays a graphical representation of the selected table along with all related tables. Related tables are those that reference the current table in a foreign key and those tables referenced by foreign keys within the current table.
E: UI Defaults
Displays user interface defaults for forms and reports. User interface defaults enable developers to assign default user interface properties to a table, column, or view within a specified schema.
Click Edit to edit defined user interface defaults. Click Create to initialize user interface defaults for tables that do not currently have user interface defaults defined.
See the screenshot below:

Note: 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.
Reference: Oracle Application Express, SQL Workshop and Utilities Guide Release 3.1.2,About Object Browser

NEW QUESTION 14
Which three actions can be performed by a Workspace Administrator?

• A. Monitor workspace activity
• B. Manage workspace to schema assignments
• C. Manage user accounts
• D. Approve workspace requests
• E. View usage reports of workspace

Answer: ACE

Explanation:
Developers can create and edit applications and view developer activity, session state, workspace activity(A), application, and schema reports. Workspace administrators additionally can create and edit user accounts (C), manage groups, and manage development services.

NEW QUESTION 15
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 16
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 appea

Answer: AD

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