Oracle 10g DBA Assessment
The Oracle 10g DBA test aims at assessing the skill level of the test taker in several areas often encountered on the job. Topics include SQL and PL/SQL, Administration, Performance Monitoring and Tuning, Backup and Recovery, Security, and Oracle Net configuration. This test is appropriate to administer to Oracle DBAs. Assessments for Oracle 9i DBA and Oracle 8 DBA are also available. Total Questions 45 Question Types Multiple Choice Competencies Tested AdministrationPerformance Monitoring/TuningSecuritySQL and PL/SQLBackup and RecoveryMiscellaneousOracle Net Tasks Tested Terminate SessionOEM ArchitectureDefault 10G FeatureTablespaceAutomatic Storage ManagementCreate Control FileAutomatic Segment ManagementAlert LogSystem TablespaceArchive Log ModeShutdown InstanceStartup DatabaseStart Enterprise ManagerSQL Tuning AdvisorOptimizerAnalyze TableObsolete FeaturesDynamic Performance ViewsAutomatic Workload RepositorySQL Access AdvisorVPD functionOS AuthenticationSQL SubsetsListener CommandsDatabase AuditingVirtual Private DatabaseUser SecurityPackage CompileTablespace ObjectsRMAN FeaturesRMAN Backup TypesRMAN and TempfilesRMAN BackupWrite ArchiveRecovery CatalogSGAOracle Data PumpTransportable TablespacesOracle SchedulerNet ProtocolsDynamic RegistrationNaming MethodsLocal ConnectionStopped ListenerNet Configuration