|
INTERVIEW QUESTIONS
PEOPLESOFT
DETAILS
Question: Suppose the CEO wants a list of the departments, whose MINIMUM salary is greater than $100,000? Your manager asks you to determine the quickest method to deliver this data to the CEO. Since writing an SQR will take too much time, you decide to use PeopleSoft query. Referring to the above, what function would you use, in combination with the aggregate function "Minimum" to produce the result set required?
Answer: Having CRITERIA 18
DoSave( ) can be called from one of the following events?
FieldEdit, FieldChange, MenuItemSelected, Save Prechange & SavePostChange
|
|
|
Category |
PeopleSoft Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 8079 users |
Added on |
9/23/2014 |
Views |
71227 |
Rate it! |
|
|
Question:
Suppose the CEO wants a list of the departments, whose MINIMUM salary is greater than $100,000? Your manager asks you to determine the quickest method to deliver this data to the CEO. Since writing an SQR will take too much time, you decide to use PeopleSoft query. Referring to the above, what function would you use, in combination with the aggregate function "Minimum" to produce the result set required?
Answer:
Having CRITERIA 18
DoSave( ) can be called from one of the following events?
FieldEdit, FieldChange, MenuItemSelected, Save Prechange & SavePostChange Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
Which is the PeopleSoft’s hub to handle complex system-to-system interactions?
|
View Answer
|
|
Interlink data type can be declared as?
|
View Answer
|
|
Which one of the following is NOT a valid PeopleSoft query type?
|
View Answer
|
|
When do configuration changes made using the configuration Manager take effect?
|
View Answer
|
|
If you change the long name of translate field what object is to be altered?
|
View Answer
|
|
If you delete a page from PSPT application, which all tables are affected?
|
View Answer
|
|
How can youset Non-Repudiation property?
|
View Answer
|
|
Where can you see the status of the job report and details in secured way?
|
View Answer
|
|
WhichTrace 255 command line options produces the trace file with the name?
|
View Answer
|
|
Which of the following menu options allows you to modify the Last Process Instance Number used within the system?
|
View Answer
|
|
Assume that you just finished customization work that involved the creation of many new objects. You can move these objects from your development database (source) to a testing database (target) to conduct more elaborate testing. Referring to the above information, why would adding your objects to a Project streamline the migration to a new database?
|
View Answer
|
|
Which Three PeopleSoft Tables the DB User mentioned in Connect ID should have permission?
|
View Answer
|
|
Which command shuts down an application server domain using a “forced” shutdown method?
|
View Answer
|
|
What is the configuration file that contains the entire collection configuration values for a given application server domain?
|
View Answer
|
|
Which is a record that PeopleTools adds to every level of the Message Structure during processing?
|
View Answer
|
|
PeopleSoft has its own naming convention for system and non-system (application) tables. In the list below, RECORDNAME refers to the name of any table or record. Referring to the above information, which one of the following identifies the naming convention PeopleSoft uses for system tables.
|
View Answer
|
|
PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?
|
View Answer
|
|
From the following statements, which one is NOT true about Pub Broker?
|
View Answer
|
|
In which one of the following views would you see the fields, criteria, and other details associated with the current query?
|
View Answer
|
|
What is the event that fires after all database updates?
|
View Answer
|