Oracle 1Z0-241 問題集

質問 1：
The Run Status column on the Process List page indicates the current state of a process.
Assume that the Process Scheduler server is running, which three statements are true regarding the Run Status column on the Process List page? (Choose three.)
A. No Success status is same as the Error status, which indicates that the program that is associated with the process request encountered an error while processing transactions within the program.
B. Processing status indicates that PeopleSoft ProcessScheduler has successfully initiated the program, and that the program is running.
C. Pending status indicates that this item is waiting for a previous item in the job before PeopleSoft Process Scheduler releases this item. When the previous item has completed successfully, PeopleSoft Process Scheduler changes the status of the item to Queued.
D. Queued status indicates that this process has successfully initiated the program and the program is running.
E. Initiated status indicates that a PeopleSoft Process Scheduler Server has acknowledged the new request. At this time, PeopleSoft Process Scheduler validates the parameters that are associated with this request and submits the command line to start the process.
正解：B,C,E

質問 2：
This PeopleCode function uses effective-date logic to return the current row from PSXLATITEM.
SQLExec("SELECT A.XLATSHORTNAME, A.XLATLONGNAME FROM PSXLATITEM A
WHERE A.EFFDT = (SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE
A. FIELDVALUE = FIELDVALUE AND
B. %CurrentDateOut
C. %EffDtCheck
D. %Date
E. EFFDT <= <date>)");
Which system variable should be substituted for <date> so the function correctly returns the
current row as of the run date for all supported databaseplatforms?
F. %AsOfDate
G. %CurrentDateIn
H. %DateTime
I. FIELDNAME = B.FIELDNAME AND
正解：F

質問 3：
You write a PeopleCode program that checks whether the user is selecting an existing search key value on the Search page or creating a new search key value. Which system variable do you use?
A. %Mode
B. %Search
C. &Mode
D. &Add
E. &Search
F. %Add
正解：A

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

質問 5：
Select the three modifications that require you to rebuild or alter the SQL table or indexes. (Choose three.)
A. You change the default field definition label.
B. You make an existing key field a search key.
C. You change an ascending key to a descending key.
D. You delete an unused field from the record definition.
E. You change the length of a field definition.
正解：C,D,E

質問 6：
What is the maximum number of duplicate levels that you can place on a page?
A. One
B. Three
C. Two
D. As many as the page real estate can support
E. Four
F. Zero
正解：D