A secondary page exists that has a Level 1 scroll area.  If a push button is inserted into a standard page with three levels to trigger the secondary page, which of the following would always be illegal?
Inserting the push button for the secondary page at Level 0
Inserting the push button for the secondary page at Level 1
Inserting the push button for the secondary page at Level 2
Inserting the push button for the secondary page at Level 3
All of the above

All of the following describe characteristics of a Control Table EXCEPT:
Generally contain static data
Store master lists of data, such as customers, vendors, items, accounts
Always have BUSINESS_UNIT as the high-level key
Used as prompt tables
Always have SETID as the high-level key

Within a Style Sheet, what is responsible for formatting individual page controls?
Sub Style Sheet
Secondary Style Sheet
Class
PTSTYLEDEF
Sub Class

A PeopleSoft subrecord must be referenced on a subpage.
True
False

Which of the following suggests the best key structure for an effective dated table used to track vendor information?
VENDOR_CD (Key, Ascending), EFFDT (Key, Descending), EFF_STATUS (Key, Ascending)
VENDOR_CD (Key, Ascending), EFFDT (Key, Ascending), EFF_STATUS
VENDOR_CD (Key, Descending), EFFDT (Key Descending), EFF_STATUS
VENDOR_CD (Key, Ascending), EFF_STATUS, EFFDT (Key, Descending)
VENDOR_CD (Key, Ascending), EFFDT (Key, Descending), EFF_STATUS

What would be the outcome if a new field were added to an existing subrecord?
The subrecord would need to be re-created
The subrecord would need to be altered
Each record using the subrecord would need to be altered
No additional steps would be necessary

When a subpage is added to a page definition, what must be specified?
The Subpage Record Name Substitution
The Component Record Name Substitution
The Secondary Page Record Name Substitution
The Record Field Name Substitution
None of the above

Which of the following best describes the purpose of a TableSet ID (SETID)?
Identifies RDBMS tablespaces for application data tables
Enables the system to secure and share data in certain prompt tables throughout an application
Defines the Parent-Child relationships in record definitions
Used to define DDL parameters for SQL tables in PeopleSoft
Used to differentiate views from SQL tables

In creating a record that is the child of another record, when is it necessary to specify a parent record name in the definition properties?
It is always necessary since it ensures that the Parent-Child relationship will work correctly on the page
It is necessary in order for prompting to work between the two tables
It is used for documentation purposes only
It is necessary in order for the Record Hierarchy Join to be available between the 2 tables in the Query tool
None of the above

To which of the following definitions may PeopleCode be attached?
Record Fields
Component Record Fields
Component Records
Components
All of the above

A view does not store data
True
False

Which of the following page types can be directly inserted into a component?
Standard Pages
Standard Pages and Secondary Pages
Standard Pages, Secondary Pages, and SubPages
Standard Pages and SubPages
SubPages and Secondary Pages

On a page, a user must specify a Department ID.  Not knowing the value offhand, he uses the prompt button to select from a list of valid departments from the Department Table on the Lookup Page.  Which statement best explains how the Department ID value is retrieved when prompting against the Department Table?
When prompting against a table, PeopleSoft always retrieves the high-level key in the prompt table (with the exception of EFFDT and EFFSEQ)
The developer determines which field will be retrieved at the prompt
When prompting against a table, PeopleSoft always retrieves the lowest-level key in the prompt table (with the exception of EFFDT and EFFSEQ)
When prompting against a table, PeopleSoft always retrieves all keys in the prompt table and the user decides which to use
When prompting against a table, PeopleSoft always retrieves the search keys in the prompt table

Which of the following statements regarding Null values in PeopleSoft is TRUE?
Null values can only be stored in Character and Numeric fields
Null values cannot be stored in Character and Numeric fields
No field in PeopleSoft can contain a null value
Any field in PeopleSoft can contain a null value
All of the above statements are true

Changing the system style sheet must be accompanied by what action before the end-users will notice any formatting changes?
The application server must be rebooted
The process scheduler server must be rebooted
The user must re-navigate to the main menu
The user must start a new browser session
Changes to the system style sheet will immediately change the formatting of all pages

A user may enter data into a summary page.
True
False

Under what circumstances should the Add Search Record be used in the component properties to help enforce row-level security?
The Add Search Record should be used when the Add action is designated for a component using a view as the search record
The Add Search Record should be used in all circumstances
The Add Search Record is necessary only when the component is used to access effective dated tables
The Add Search Record is necessary only when the component is used to access effective dated tables and the Update/Display All action is designated
The Add Search Record is necessary only when the component is used to access effective dated tables and the Update/Display All and Correction actions are designated

Why does PeopleSoft recommend including the PSIMAGEVER field along with a given image field on both the record and page definition?
PSIMAGEVER allows more than one image field to be placed on the page
PSIMAGEVER translates BMP image formats to the more commonly used JPG image formats
PSIMAGEVER helps the web server handle appropriate image versioning so that only images not already stored in the web server’s  cache are downloaded from the application server
PSIMAGEVER is used to debug complex applications
PeopleSoft does not recommend using PSIMAGEVER in this manner

Which of the following changes to a record definition would require an SQL-Alter on the corresponding database table after the change has been saved in the Application Designer?
Making a Date field required in the record
Adding a Prompt Table Edit to a key field
Turning off the Reasonable Date Check setting on a field
Making one of the fields an Alternate Search Key
All of the Above

A page can contain a maximum of how many scroll areas?
2
3
4
5
Unlimited

Which of the following best describes the purpose of views in PeopleSoft applications?
Display Data in Summary Pages
Implement row-level security in search records
Join tables together for application reporting
Prompt Table editing
All of the above

If radio buttons are not grouped properly on a page definition, what message will be returned by the Application Designer?
“Warning – Field occurs more than once on the page”
“Invalid combo box in page definition
“Invalid related display – related display before control or related to field outside scroll
“Invalid record”
None of the above

While attempting to save a newly developed page in the Application Designer, you receive this message:  "Invalid related display -- related display before control or related to field outside scroll".  What is the best way to correct this
Change the Level 2 scroll areas and grids to Level 1
Use grids instead of scroll areas on the page
Make sure all related fields are display only
Go to the page field properties for the display control field and select the “First Occurs Only “ checkbox
Select the Order tab and make sure that each display control field precedes its related field

Individual messages in the Message Catalog are uniquely identified by which of the following?
Message ID
Message Set Number
Message Catalog ID and Message Set Number
Message Set Number and Message Number
None of the above

Where does the mapping between Business Units, SetIDs, and Record Groups occur?
Record Group Utility
TableSet Control Utility
TableSet ID Utility
Business Units table
Message Catalog

 
Back to Learn PeopleSoft