This test is intended to evaluate PeopleSoft 8 Database Administrators. Since PeopleSoft can reside on many databases, such as Oracle, DB2, SQL Server and others, this test is geared towards application issues rather than questions focusing on database-specific issues. Among the topical areas included are PeopleSoft 8 Architecture, PeopleSoft 8 Application Server, PeopleSoft 8 PeopleTools, upgrades, patches and fixes. This test is appropriate to administer to people who have worked as a PeopleSoft DBA for at least one year. Tests are also available for Oracle 9i DBA and Db2 5.x DBA. Total Questions 39 Question Types Multiple Choice Competencies Tested PeopleSoft 8 ArchitecturePeopleSoft 8 Web ServerPeopleSoft 8 Database ServerPeopleSoft 8 Application ServerMisc Tasks Tested Acronym - PIALogging into PeopleSoft's 2-tier EnvironmentThe Three Serves in the 3-tier EnvironmentInstalling Server ComponentsLogging on to PeopleSoft's 3-tier EnvironmentStarting the PIA EnvironmentStopping the PIA EnvironmentPeopleSoft 8 Web Server Setup and Configuration - Changing OptionsStarting WebLogic for the Command PromptNaming Convention for PeopleTools TablesNaming Convention for PeopleSoft Applications Data TablesDefault Owner of PeopleSoft Application and Data TablesIdentifying Where to Locate Record Fields on the Database LevelPeopleSoft 8 Database Server Configuration - Categorization of TablesClearing the CacheShutting Down Individual ServicesFile Containing the Settings for DomainsUtilities Used to Create and Configure Application Server DomainsPrefacing Editing and Administering PeopleSoft Application Server DomainsThe Process SchedulerStarting or Stopping the Application Server for a DomainIdentifying Differences Between Two SystemsMonitoring JobsCopying Project from One System to AnotherUnderstanding PeopleSoft 8 Security IDsIdentify the Different Type of UpgradesLocating Patches and FixesUnderstanding Where to Enable Tracing - Process SchedulerIdentifying Data Mover CommandsReports - Finding Inconsistencies Between Data Structures and DatabaseKnowing Where to Find Supporting DocumentationReports - Identifying Orphaned PeopleSoft DefinitionsInstalling PeopleSoft ClientKnowing What Table Holds the Application Release InformationREN ServerUnderstanding Where to Enable Tracing - Application ServerUnderstanding Where to Enable Tracing - Configuration ManagerLoading DataConnecting 2-Tier
