Free Oracle 1Z0-450 Exam Dumps Questions & Answers

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;

Which two actions are associated with page rendering?

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

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.  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.
• B.  Edit the P<n>_CALENDAR_DATE hidden item and replace the default value with 20090101.
• C.  Modify the display attributes of the calendar.
• D.  Edit the P<n>_CALENDAR_DATE hidden item to specify a condition.

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.  Add a text section to a page
• B.  Create a page navigation
• C.  Create a section navigation
• D.  Use a SQL query
• E.  Create a data grid
• F.  Create a data section based on data from a data grid

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.  Uncheck the Compute and Aggregate options from the Search Bar section within Report Attributes definition.
• B.  Remove the Compute and Aggregate options when creating the interactive report.
• 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.  Deselect the Compute and Aggregate actions from the Search Bar while running the report.