Oracle 1Z0-450 問題集

質問 1：
Which two actions are associated with page rendering?
A. The process of generating a page from the Database.
B. A DML page process inserting records into a table after the Form Page is submitted.
C. A computation which sets the session state with process point 'On Load - Before Header.
D. The process of submitting a page.
E. A validation check on a user input field to verify that the entered value is numeric.
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
A new column called TEMPLATE (In bold below) was added to an existing Interactive Report query as shown 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. Add a control break on the TEMPLATE column.
B. Change the Report attributes so that TEMPLATE is displayed between FOCUS_AREA and TYPE
C. Create a sort on the TEMPLATE column.
D. Select Columns and move the TEMPLATE column to be displayed and move it up between FOCUS-AREA and TYPE
E. Reset the Interactive Report.
F. Save the Report as Default Settings.
正解：B,D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which three statements are true about a wizard-generated tabular form?
A. Only allows you to change the updateable columns.
B. Allows you to add more than one record at a time.
C. You can drill down to a detail record view.
D. Allows you to add and update multiple records at a time.
E. Only allows you to update one record at a time.
正解：A,B,D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
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 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 SQL and enter the following in the validation method; SELECT 1 FROM CUSTOMERS WHERE COUNTRY= 'US' AMD PROVINCE IS NULL
正解：A

質問 5：
Which two actions are true about creating a form based on a table with a report?
A. The first page provides users with the ability to update the selected table or view.
B. This report and form combination can be based on more than one table or view.
C. This wizard builds two pages, the first page for the report and the second page for the form.
D. The second page enables users to specify the row to be updated.
E. This report and form combination is based on a single table or view.
正解：C,E
解説: (Topexam メンバーにのみ表示されます)