What are destructive statements in SQL?
explain why state records are needed?
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?
Your company obtained the newest Application Release of PeopleSoft, and you need to prepare for the upgrade. Upon reading the new Release Notes, you notice that changes were made to two COBOL modules (batch programs).You need to decide how to compare the current versions of these COBOL programs with the versions delivered with the new PeopleSoft application release. Which would be the fastest method of comparing these different versions?
What is left join?
Which are true sequences with respect to validate signon with database option enabled in psadmin.?
Which is NOT a valid PeopleSoft query type?
How is an establishment different from a company?
Which method is fired after the database is updated?
What is one-to-many?
what is deferred processing?
Can you explain dosave( ) can be called from one of the following events?
How can you set non-repudiation property?