1z0 450 PDF

QUESTION NO: 1
Your application includes a standard tab set TSl 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?

A. Edit the tab definition. In the Tab Also Current for Pages field, specify the page number for
which the tab is to be rendered.
B. Edit the tab definition. Select "Current pageExpression 1" for Condition Type and then specify
page 1 in the "Expression 1* field. Repeat this process for the other tab.
C. Edit the tab definition. Select "Current pageisNOT in Expression 1" for Condition Type and then
specify the page number for which the tab is to render in the "Expression 1" field.
D. Change the region template on the page where the tabs should not be rendered.

Answer: A
Explanation:

QUESTION NO: 2

The Interactive Report is displayed in Exhibit 2Exhibit 2

Oracle 1z0-450: Practice Exam
"Pass Any Exam. Any Time." - 100% Pass Guarantee 2
Which combination of three actions would need to take place to create the interactive report?

A. Create an Interactive Report region to show the list of EMPLOYEES and PRODUCTS based on
the Customer ID.
B. Create an Interactive Report region that contains a query between the CUSTOMERS,
EMPLOYEES, PRODUCTSand SALEStable.
C. Create an SQL Report region that contains a query between the CUSTOMERS, PRODUCTS
andSALES tables only.
D. Create a filter on Customer FIRST_NAME and LAST_NAME.
E. Create a Control Break on Sales Representative.
F. Concatenate FIRST_NAME and LASTJYAME for both CUSTOMERS and EMPLOYEES in the
query.

Answer: E
Explanation:

QUESTION NO: 3

There are four departments listed as radio group, appearing one below the otherina form (View
Exhibit A). You want to edit the item attributes so that they appear as shown in Exhibit B
(horizontally, next to each other). Which action would you take to satisfy this requirement?

Exhibit A


A. Change "Begin on new Line" attribute of radio group to No and set "Begin on New Field"
attribute to Yes.
B. Change "Begin on new Line" attribute of radio group to Yes and set "Begin on New field"
attribute to Yes.
C. Change "Begin on new Lineattribute of radio group to No and set "Begin on New field" attribute
to No.
D. Edit the List of Values section for the item. Change the "Number of Columns" attribute to the
number of columns that should be displayed horizontally.
E. Edit the List of Values In Shared Components. Specify the number of columns that you want
the List of Values to span.

Answer: D
Explanation:

QUESTION NO: 4

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

QUESTION NO: 5

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

QUESTION NO: 6

You have created an access control list. Which authorization scheme would you select to control
access to an application or a page component?

A. Access control 1 update
B. Restricted access. Only users defined in the access control list are allowed
C. Public read only. Edit and administrative privileges controlled by access control list
D. Access control - view
E. Administrative access only

Answer: D
Explanation:

QUESTION NO: 7

In your Orders application, you created a 30 Pie Flash chart page to display products by category.
You provided the following query:

Selectnull link, category_name# count (*) from (SELECT CASE

WHEN (category_id between 10 and 19) THEN'Television1

WHEN (category_id between 20 and 29) THEN'Computer1

ELSE 'Others1

ENDcategory_name

VMMnew_product.Groupbycategory_nameorder by 1

ViewtheExhibit. What action should you perform to display the chart title and the total number of
products under each category without using custom XML?

A. Edit the Flash Chart region to select the Show Values check box.
B. Modify the query to display the value and edit the Flash Chart region to display the chart title
C. Edit the Flash Chart region to specify the chart title and select the Show Values check box.
D. Edit the Flash Chart region to specify the chart title.

Answer: C
Explanation:

QUESTION NO: 8

Which two are true about creating interactive reports?

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

Answer: A,D
Explanation:

QUESTION NO: 9

Which two statementsistrue relating to authentication in Oracle Application Express?

A. It is a process of establishing user identity before the user can access an application.
B. An authentication scheme can be specified for an entire application, page, or specific
components
Suchas item, button and regions on a page.
C. An authentication scheme prevents a user from accessing session state belonging to other
users.
D. An authentication scheme helps a user to reestablish their session when they log back
intoanapplication allowing them to bookmark the application.
E. An authentication scheme can only be applied to one application.

Answer: A,B
Explanation:

QUESTION NO: 10

You have 5 buttonsina region. These buttons are of style "HTML Button". Each button isof a
different size (depending on the name of the button). How will you ensure that all the buttons are
of the same size (150 pixels) and they look uniform?
A. Set the button attribute for each button to style "width: 150px.
B. The size of an HTML Buttonisalways decided based on the label of the button.
C. Select the button type as "Template Driven". Choose the same template for each button.
D. Change the button style to "Image. Create an image-based button of same size for each of the
buttons and use them in the application.

Answer: A
Explanation:

QUESTION NO: 11

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 apages in the application

Answer: E
Explanation:

QUESTION NO: 12

Which four can be exported using the application export utility?

A. UI defaults
B. Images
C. Themes
D. Schema objects
E. Application components

Answer: A,B,C,D
Explanation:

QUESTION NO: 13

You currently have all your users set up in a directory. Which authentication scheme would you
select to checktheusernameand password in the directory?

A. Database Accountcredentials,from thepre-configuredschemes.
B. DatabaseAccess Descriptor (DAD.credentialsverification, from the pre-configured schemes.
C. SingleSign On authentication,from the pre-configured schemes.
D. LDAPcredentialsverification, from thepreconfiguredschemes.
E. Authentication scheme from scratch using theAPP-USERfunction to check for the username
and password.

Answer: D
Explanation:

QUESTION NO: 14

Which two actions are associated with page rendering?

A. The process of generating a page from the Database.
B. The process of submitting a page.
C. A validation check on a user input field to verify that the entered value is numeric.
D. A DML page process inserting records into a table after the Form Page is submitted.
E. A computation which sets the session state with process point 'On Load - Before Header.

Answer: C,E
Explanation:

QUESTION NO: 15

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 are
unable to view P2_SALARY item. How do you make sure that you can view and enter a value
through this form?

A. 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.
B. Change the type of P2_SALARY to display only.
C. Change the type of P2_SALARY to text.
D. Change the type of P2_SALARY to text and add a computation to populate the item.

Answer: A
Explanation:

QUESTION NO: 16

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
"Alwaysfrom 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: C,D
Explanation:

QUESTION NO: 17

Which two actions are true about creating a form based on a table with a report?

A. This wizard builds two pages, the first page for the report and the second page for the form.
B. The first page provides users with the ability to update the selected table or view.
C. This report and form combination is based on a single table or view.
D. The second page enables users to specify the row to be updated.
E. This report and form combination can be based on more than one table or view.

Answer: A,C
Explanation:

QUESTION NO: 18

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

QUESTION NO: 19

Which two actions are true about using standard and parent tabs?

A. To use parent tabs, you must use a page template that supports them.
B. You cannot apply authorization at standard tab level.
C. You can resequence the display order of standard tabs.
D. When you create or edit a standard tab, for the Tab Label attribute, you cannot use
substitutionvalues.

Answer: A,C
Explanation:

QUESTION NO: 20

A new column called TEMPLATE (In bold below) was added to an existing Interactive Report
query asshown below.

SELECT title, product, release, subproduct, keywords, id,

focus_area, template, type, link

FROM content-repository

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?

A. Select Columns and move the TEMPLATE column to be displayed and move it up between
FOCUS-AREA and TYPE.
B. Add a control break on the TEMPLATE column.
C. Save the Report as Default Settings.
D. Change the Reportattributesso that TEMPLATE is displayed between FOCUS_AREA and
TYPE.
E. Create a sort on the TEMPLATE column.
F. Reset the Interactive Report.

Answer: A,F
Explanation:

QUESTION NO: 21

Which three are valid process types of a Page Process?

A. Automatic Row Processing (DHL)
B. PL/SQL
C. ClearCache for Items (ITEM, ITEM,ITEM)
D. Static Assignment
E. Form Pagination

Answer: B,C,E
Explanation:

QUESTION NO: 22

Which two actions are true about creating lists?

A. you can track clicks on list entries.
B. All list templates support hierarchical lists.
C. Once created; you cannot update the parents of list entries.
D. you can edit multiple list entries simultaneously.
E. You can add to a list directly from the page definition page.

Answer: D,E
Explanation:

QUESTION NO: 23

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

QUESTION NO: 24

Before theapplication Installation can proceed, the Installer checks whether the user has required
system privileges or not. Where would you specify the required system privileges?

A. Supporting Objects > Build Options
B. Supporting Objects > Validations
C. Supporting Objects > Install
D. Supporting Objects > Prerequisites
E. Supporting Objects > System Requirements

Answer: D
Explanation:

QUESTION NO: 25

When a user runs an Oracle Application Express application, how is information (identified and
preserved from one page view to the next for that user?

A. Using cookies
B. Using hidden items and regions in the URL
C. Using Session IDs
D. Using session state protection
E. Using authorization schemes

Answer: E
Explanation:

QUESTION NO: 26

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?

A. Include master row navigation.
B. Master row navigation order.
C. Secondary navigation order.
D. Include master report.

Answer: A
Explanation:

QUESTION NO: 27

Which two actions can be performed using the Object Browser?

A. Browse database objects of the current schemaB.Build and save SQL queries
B. Transfer SQL scripts between schemas
C. Create a lookup table based on a column in the current table
D. Display APEX View reports

Answer: A,D
Explanation:

QUESTION NO: 28

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

Answer: B,D,E
Explanation:

QUESTION NO: 29

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:

Marcie: Modify application, manage user groups, and view usage reports of her workspace

Nancy: Manage workspaces, and approve storage requests

Lauren: Modify database objects, view session state and view application reports.

What privileges would you assign to these three users?

A. Marcie: Developer, Nancy: Developer,Lauren: Workspace Administrator
B. Marcie: Workspace Administrator, Nancy: Developer,Lauren: Developer
C. Marcie: Application Express Administrator, Nancy: Workspace Administrator,Lauren: Developer
D. Marcie: Workspace Administrator, Nancy: Application Express Administrator,Lauren:
DeveloperE.Marcie: Workspace Administrator, Nancy: Workspace Administrator,Lauren:
Developer

Answer: C
Explanation:

QUESTION NO: 30

In your application both page 2 and page 4branchesto 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 depending on
the originating page. Which three actions need to be performed?

A. Create two application items: LAST_PAGE and CURRENT_PAGE.
B. Create an application computation on item LAST_PAGE, computation point Before Header,
type
PL/SQL Function Body and the computation body as:
BEGIN
:LAST_PAGE := nvl(:CURKENT_PAGE, :APP_PAGE_ID.;
:CURRENT_PAGE := ;APP_PAGE_ID;
RETURN :LAST_PAGE;
END;
C. Create an application computation on Item LAST_PAGE, computation point After Submit, type
PL/SQL Function Body and the computation body as:
BEGIN
:LAST_PAGE := :CURRENT_PAGE;
:CURRENT_PAGE : = :APP_PAGE_ID;
RETURN:LAST_PAGE;
END;
D. On page 5 create a validation to check whether the value storedinapplication item LAST_PAGE
is equal to the value of APP_PREVJ_PAGE_ID whereAPPJ>REV_PAGE_ID is Built-in
Substitution String in Oracle APEX that stores the number of calling page.
E. On page 5 use the value stored in application item LAST_PAGE to go back to the page from
which you browsed to the current page.

Answer: A,B,E
Explanation:

QUESTION NO: 31

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
Explanation:

QUESTION NO: 32

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

QUESTION NO: 33

Which two statements are true whennavigating on a Page Definition window?

A. anLOV appears only if it is associated withan item on that page.
B. anAuthorization 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,C
Explanation:

QUESTION NO: 34

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: C
Explanation:

QUESTION NO: 35

User Details form page is page 1 in your application. On this pagetheenduserisrequired
toprovidehis Name and Address details- You need to create a validation that
requirestheendusertoenteraprovince if the countryisnot the United States (US).

Whichaction needs to be performed?

A. Create a validation of type SQL and enter the followinginthe validationmethod;
SELECT1FROMCUSTOMERS
WHERE COUNTRY=US' AMD PROVINCEIS NULL
B. Create a validation of type PL/SQL Function Returning Boolean and enterthe
followinginthevalidation method:
BEGIB
IF :Pi_COUNTRY = 'US' AMD : Pl_PROVINCE IS NULL THEN
RETURM FALSE;
ELSE
RETURN TRUE;
END IF;
END;
C. Create a validationoftype PL/SQL Function Returning Booleanand enter
thefollowinginthevalidation method;
begin
IF :P1_COUNTRY !=US' AND ; Pl_PROVINCE IS NULLTHEN
RETURN FALSE;
ELSE
RETURN TRUE;
END IF;
END;
Answer: C
Explanation:

QUESTION NO: 36

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
Explanation:

QUESTION NO: 37

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. CreateNavigationbarEntry 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
Explanation:

QUESTION NO: 38

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,itdisplays 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: B
Explanation:

QUESTION NO: 39

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_ORDERDATEand: P21_ORDERTOTAL
B. V (P21_ORDERDATE.andV (P21_ORDERTOTAL)
C. &P21_QRDERDATE.And&P21_ORDERTOTAL.
D. NV (P21_ORDERDATE)andNV (P21_ORDERTOTAL)

Answer: C
Explanation:


QUESTION NO: 40

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:

QUESTION NO: 41

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 performedin?

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

QUESTION NO: 42

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:

QUESTION NO: 43

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 orthe right of the page title
E. Among this region's Items

Answer: C
Explanation:

QUESTION NO: 44

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
Explanation:

QUESTION NO: 45

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# foundinthe region template definition.
C. Reference aclassfrom 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 thepage.

Answer: B,C
Explanation:

QUESTION NO: 46

You can set the value of an item in your application by using which four methods?

A. Form submission
B. By using built-in substitution strings
C. Using bind variables to reference session state of a specified item
D. Application or page computations
E. By invoking the f procedure in an HTTP request

Answer: B,C,D,E
Explanation:

QUESTION NO: 47

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 area.
SELECTlocations. City
FROMlocations, countries
WHEREcountries.country_id=locations.country_id AND
Countries. country__name=fItaly;
B. Use Query Builder to select the countries and locations tables. Create a join between thetwo
tables by using the country_id column. Then, select the city column inthe locationstable
andcountry_namecolumn in the countries table. For the country_name, specify the condition = '
Italy.
C. Use Query Builder to select the countries and locations tables. Select thecountry_id column
inboth the tables and create a join between them. Then, select the city column inthelocations table
and country_namecolumn in the countries table. For the countryname,specify the condition Italy.
D. Run the following SQL query in the SQL Commands worksheet area.
SELECT locations,city
FROM locations,countries
WHERE countries.country_name=Italy;
E. Use Query Builder to select the countries and locations tables. Create a join between the two
tables by using the country_id column. Then, select the city column in thelocations table and
country_name column in the countries table. For the country_name, specify the condition =Italy'.
Uncheck the Show check box for country_name.

Answer: B,C
Explanation:

QUESTION NO: 48

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?

A. Open each pageinthe application and review the templates section.
B. Open the template and review the pagesitreferences.
C. Select the Utilization tab and view the pages referenced from the Shared Components >
Templates page.
D. Select the references link for the template on the Shared Components > Template page.
E. Preview the template to see the list of pages that referenceit.

Answer: D
Explanation:

QUESTION NO: 49

Where would you specify data load scripts that need to run as part of installing your application?

A. Supporting Objects > Build Options
B. Supporting Objects > Substitutions
C. Supporting Objects > Installation Scripts
D. Supporting Objects > Prerequisites
E. Supporting Objects > System Requirements

Answer: C


1z0 450 PDF

Uploaded by

Copyright:

Available Formats

1z0 450 PDF

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

1z0 450 PDF

Uploaded by

Copyright:

Available Formats

QUESTION NO: 1

You might also like