Oracle 1Z0-241 問題集

質問 1：
Oracle's PeopleSoft Query uses query access group trees to control security of the tables in your PeopleSoft database. Which three statements are true regarding query access group trees? (Choose three.)
A. After you build a query tree, users can then generate queries on any tables that exist in the database.
B. Users can use PeopleSoft Query to retrieve information only from those tables with record definitions they have access to.
C. You define a hierarchy of record components, based on logical or functional groupings, and then give users access to one or more branches of the tree.
D. You can create, view, and update query access group trees using PeopleSoft Query Access Manager.
E. After you build your query access group trees, users are granted access by default to create new queries and to run existing queries, and they have the access rights to the record components that are used in the queries.
正解：B,C,D

質問 2：
This PeopleCode snippet creates a record object, where TASK and RESOURCE_NAME are keys on TASK_RSRC.
&MyRec = CreateRecord(Record.TASK_RSRC);
&MyRec.TASK.Value = &Task;
&MyRec.RESOURCE_NAME.Value = &Resource;
Which method will populate the record object with one row from PS_TASK_RSRC?
A. Update
B. Insert
C. Fetch
D. SelectByKey
E. Execute
正解：D

質問 3：
Select the two true statements regarding search attributes. (Choose two.)
A. Search keys do not have to be part of the record definition primary key structure.
B. Unlike search keys, alternate search keys do not appear on the search page in Basic Search mode.
C. A field does not have to be a search key or an alternate search key to be a list box item.
D. Alternate search keys generate the search page unless they are not list box items.
正解：B,C

質問 4：
If your Crystal report contains numeric fields that are formatted to have single-line or double-line borders at the top of the container, you may experience incorrect justification of numbers in the HTML output.
Which two options would solve your problem? (Choose two.)
A. Select the Design tab and, in the Page Header section, double-click the field that has single-line or double-line borders at the top, and then click a blank area of thereport to deselect the text object.
B. Draw lines above the numeric fields using the line drawing tool.
C. Get full reporting flexibility by signing out and then successfully signing in to a PeopleSoft database using the PeopleSoft sign-in dialog.
D. Select the Design tab, save the report, return to the Preview tab, and click the Refresh button to refresh your data after making changes.
E. Insert summary fields into a blank text object and then format the container text object to include borders above the text.
正解：B,E

質問 5：
In Crystal Reports, you use the Design tab to format reports. Which three statements are true regarding the usage of the Design tab? (Choose three.)
A. It is used to preview your report in portrait or landscape orientation according to the number and width of the columns that are in your query.
B. It is used to display the rows of data from your database.
C. It is used to enter the title of the report and other information that you want to appear at the top of the first page andat the bottom of the page.
D. It is used to define the default language of your reports based on the languages that you license when you purchased Oracle's PeopleSoftEnterprise software.
E. It is used to enter or modify the column headings and other identifying information that you want to appear at the top of each page.
正解：B,C,E

質問 6：
Examine this PeopleCode snippet:
SetDefault(ORDER.DATE);
Select the object-oriented equivalent.
A. &Field = CreateField(ORDER.DATE);&Field.SetDefault = True;
B. &Field = CreateField();&Field.SetDefault(ORDER.DATE);
C. &Field = GetField(ORDER.DATE);&Field.SetDefault();
D. &Field = CreateField(ORDER.DATE);&Field.SetDefault();
E. &Field = GetField(ORDER.DATE);&Field(SetDefault);
正解：C