DB2 is a strategic product from IBM that is available on all of IBM's key platforms. This database is predicated on the relational model, which is founded on the mathematics of set theory. This provides a solid theoretical base for the management of data. The DB2 5.x DBA test is appropriate to be given to database administrators. Tests for ADABAS DBA, Oracle Applications DBA and SQL Server 2000 DBA are also available. Total Questions 60 Question Types Multiple Choice Competencies Tested VocabularyProblem ResolutionSQLDB2 InternalsDB2 PerformanceUtilities and Commands Tasks Tested EXPLAIN FeatureJoinsData AccessEmbedded SQLUNION ClauseSearch CriteriaReferential ConstraintsDebugging SQLOCCURS ClauseConvert Number to StringCorrelated SubqueriesData Modification with CursorsConsolidating DataSTRIP FunctionSELECTCursorsDetermine Number of RowsStored ProceduresDB2 Data StructuresIdentify SQL TechniqueIdentify StructureLENGTH FunctionCartesian ProductData Modification in Embedded SQLDATE FunctionSQL TechniquesOperatorRetrieve all RowsOPEN CursorsIdentify CodeVALUE FunctionGROUP BY and HAVINGArranging DataControl and AdministrationBIND ParametersNumber of LocksDASD VolumesLock ManagementPhysical StorageDBASLock Acquisition FailureLocking Strategy ComponentsValid Lock TypesWITH UR ClauseTablespace LockMost Valuable TraceWriting TracesAnalysisSpecific Trace TypesTune Database DesignsTrace TypesDB2 UtilitiesMiscellaneous UtilitiesBackup UtilitiesCHECK DATA UtilityData ConsistencyCatalog ManipulationReset Check PendingData Organization
