ADABAS, from Software AG, is a multi-threaded database management system specially designed for complex integration. It delivers unparalleled performance and offers features supporting continuous operation. It is used for various types of applications across many branches of industry. Adabas-based applications do have one common denominator though; all of them depend on the outstanding reliability, the high availability and the extraordinary performance of the underlying database. This test covers all the main areas of ADABAS among them; SQL Programming, Data manipulation and retrieval, Transactions, System Tables, Authorization, Data Definition, Queries, and Restrictions. The test contains questions possessing differing complexities that are sufficient to evaluate an experienced developer. 50% of the questions fall under the Basic category, 30% are Intermediate and the remaining 20% fall under the advanced category. Assessments for Adabas Natural and Adabas DBA are also available. Total Questions 40 Question Types Multiple Choice Competencies Tested ProgrammingAuthorizationDataTransactionsConceptsSQLSTATEData DefinitionStored ProcedureFunctionsCursorsElementsSQL ProgrammingLockViewsTriggerPermissionsQuerying Date Tasks Tested QueryDate and TimeLock ModeStringsExistence of a TableTablesTimestampFixed Point NumberFunctionsDML StatementsRolling Back a TriggerJoinsMemory RequirementsUser ClassesAuthenticationTriggerCharacter StringsMeaningDefault TriggerSubtractColumn DefinitionReleasing the DataPurposeJoin ConditionsColumn RenameProgrammingStoring Computed ColumnsPrimary KeySTAMPIndexesNested Stored ProcedureConcatenationUpdating Snapshot TableSubtrans StatementOutput of QuerySynonym
