This test consists of a wide variety of questions that relate to the Oracle database administration for PeopleSoft 9 applications. The questions cover topics such as PeopleTools architecture, PeopleTools tables and the corresponding Oracle database tables, performance monitoring and tuning, DDL statements, PeopleSoft dictionary and Oracle database catalog views, etc. This question set is well suited to test candidates who are experienced with administering PeopleSoft 9 applications on 9i or 10g Oracle databases. Total Questions 39 Question Types Multiple Choice Competencies Tested DatabasePeopleTools TablesPeopleSoft DDLPerformance Monitoring and TuningAttributes and Indexes Tasks Tested PeopleTools TableImport Utility for PeopleSoft ObjectsTablespacesTwo-Tier ConnectionsPeopleSoft Schema Referenced TablesPeopleSoft AccountsTable TypesDatabase Table Not FoundRolesDatabase ConnectivityPeopleSoft SchemasDatabase SchemasFunctionsDatabase RolesApplication Development StepsMatching Tables with Dictionary ViewsRecord Definition DetailsPSRECDEFN TableCorresponding ViewsPSRECFIELD TableData Dictionary DiscrepanciesNull ColumnsReferenced TablespacesDatabase StructuresPeopleSoft DDLQuery StatisticsSQL Trace File LocationPeopleSoft PingDatabase MetricsOptimizer HintsProcess SchedulerCachingSQL TraceSearch AttributesSearch RecordsKeys and IndexesIndexes
