1Z0-450 試験問題を無料オンラインアクセス

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

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.Administrative access only
• D.Access control - view
• E.Public read only. Edit and administrative privileges controlled by access control list

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

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

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; begin IF :P1_COUNTRY != 'US' AND ; Pl_PROVINCE IS NULL THEN RETURN FALSE; ELSE RETURN TRUE; END IF; END;
• B.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
• C.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;

Which two actions can be performed using the Object Browser?

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