This SQL definition uses effective-date logic to return the current row from PSXLATITEM.

Which meta-SQL element should be substituted for date so the SQL correctly returns the current row as of the run date for all supported database platforms?

• A. %CurretnDateIn
• B. %DateTime
• C. %CurrentDateOut
• D. %EffDtCheck
• E. %Date

You are testing the new Customer Table page and notice that you are missing a Return to Search button on the page.

To add this button in Application Designer, open the Component Properties dialog box and ____.

• A. On the Internet tab, select Return to List
• B. On the Internet tab, select Return to Search
• C. On the Internet tab, select Page Navigation in History
• D. On the Use tab, select Return to Search
• E. On the Use tab, select Update/Display

When you are modifying, customizing, or configuring PeopleSoft application definitions using Application Designer, which two statements are true regarding the impact on other application elements? (Choose two.)

• A. If you modify field definition properties or record definition properties, the PeopleTools system insanity and automatically synchronizes the definition changes with the underlying SQL database table
• B. If you alter a table, you must rebuild any views that reference the altered table
• C. PeopleTools provides utilities to help you determine relationships between application definitions, such as PeopleTools cross-reference reports and the Find Definition References option
• D. Changing a single field property, such as the field name or type, typically has no effect on other definitions such as records or pages
• E. Running an alter table process in Application Designer is required only during major upgrades, not after small changes to a single record definition

Select the two Application Designer definitions that demonstrate how referential integrity is maintained in PeopleSoft applications. (Select two.)

• A. Option B
• B. Option A
• C. Option D
• D. Option C