Online Access Free 1Z0-450 Exam Questions

Which two statements is true relating to authentication in Oracle Application Express?

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

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.Change the column attribute that contains the link specification to remove the Compute and Aggregate options from the Search Bar.
• 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.Deselect the Compute and Aggregate actions from the Search Bar while running the report.
• E.Uncheck the Compute and Aggregate options from the Search Bar section within Report Attributes definition.

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

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.5, 4, 7, 2, 3, 1, 6
• B.4, 5, 3, 7, 2, 6, 1
• C.5, 4, 2. 7, 1, 6, 3
• D.5, 4, 3, 6, 1, 2, 7
• E.4, 5, 7, 1, 2, 6, 3
• F.4, 5, 3, 1, 7, 2, 6

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 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;
• B.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;
• C.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