Oracle 1Z0-450 問題集

質問 1：
In your Orders application, you created a 30 Pie Flash chart page to display products by category. You provided the following query:
Select null 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
END category_name
VMM new_product. Group by category_name order by 1
View the Exhibit. What action should you perform to display the chart title and the total number of products under each category without using custom XML?

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

質問 2：
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. Remove the Compute and Aggregate options when creating the interactive report.
C. Uncheck the Compute and Aggregate options from the Search Bar section within Report Attributes definition.
D. Change the column attribute that contains the link specification to remove the Compute and Aggregate options from the Search Bar.
E. Click Reset from the Actions Menu after deselecting the Compute and Aggregate options.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Your application includes a standard tab set TS1 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 page is NOT in Expression 1" for Condition Type and then specify the page number for which the tab is to render in the "Expression 1" field.
C. Edit the tab definition. Select "Current page Expression 1" for Condition Type and then specify page 1 in the "Expression 1* field. Repeat this process for the other tab.
D. Change the region template on the page where the tabs should not be rendered.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
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 hidden items and regions in the URL
B. Using cookies
C. Using authorization schemes
D. Using Session IDs
E. Using session state protection
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 5：
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. 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.
D. Create Navigation bar Entry for the page from the application's shared components. Refer this navigation bar entry in the application URL.
E. Use the built-in substitution string PAGE_ALIAS.
正解：A