Oracle 1Z0-450 問題集

質問 1：
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 メンバーにのみ表示されます)

質問 2：
View the Exhibit. To display only the names of all cities In Italy, you could perform which two tasks?
A. Run the following SQL query in the SQL Commands worksheet area.
SELECT locations, city
FROM locations, countries
WHERE countries.country_name='Italy';
B. Use Query Builder to select the countries and locations tables. Create a join between the two tables by using the country_id column. Then, select the city column in the locations table and country_name column in the countries table. For the country_name, specify the condition = ' Italy'.
C. Use Query Builder to select the countries and locations tables. Select the country_id column in both the tables and create a join between them. Then, select the city column in the locations table and country_name column in the countries table. For the country name, specify the condition 'Italy'.
D. Run the following SQL query in the SQL Commands worksheet area.
SELECT locations. City
FROM locations, countries
WHERE countries.country_id=locations.country_id AND
Countries. country__name=f Italy';
E. Use Query Builder to select the countries and locations tables. Create a join between the two tables by using the country_id column. Then, select the city column in the locations table and country_name column in the countries table. For the country_name, specify the condition ='Italy'. Uncheck the Show check box for country_name.
正解：D,E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You can create List of Values for which five types of page items?
A. Multiple Select list
B. Text Area
C. Date Picker
D. Radio Group
E. Check Box
F. Shuttle
G. Select List
正解：A,D,E,F,G
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which three actions can be performed by a Workspace Administrator?
A. Monitor workspace activity
B. Manage user accounts
C. Manage workspace to schema assignments
D. View usage reports of workspace
E. Approve workspace requests
正解：A,B,D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which three steps are presented when importing an application?
A. Select the database character set
B. Select the parsing schema and build status
C. Select how to resolve Application ID conflicts
D. Browse to the file location and select the name of the file to be imported
E. Specify where to store the imported application
正解：B,C,D
解説: (Topexam メンバーにのみ表示されます)