ADABAS D Questions and Answers

Top Level

Ordering the Manual

 

• General Information

 

• The Name of the DBMS

 

• Versions

 

• The DBMS Supplier

 

• Language Versions

 

• Operating Systems

 

• Features of the DBMS

 

• Components of the DBMS

 

• Components of the DBMS

 

• CONTROL

 

• LOAD

 

• DOMAIN

 

• QUERY

 

• QueryPlus

 

• AccessPlus

 

• SQL-PL

 

• Precompilers

 

• CALL Interface

 

• ODBC Driver

 

• Display-oriented Interfaces

 

• Display-oriented Interfaces

 

• Interactive SQL

 

• Interactive SQL

 

• Report Generator

 

• Report Generator

 

• SQL

 

• SQL

 

• Extended SQL Functions of ADABAS

 

• Extended SQL Functions of ADABAS

 

• Referential Integrity

 

• Updatable Join View

 

• Outer Join

 

• DB Procedure

 

• Trigger

 

• DB Function

 

• Scrollable Cursor

 

• Precompiler Concept

 

• Precompiler Concept

 

• Data Dictionary

 

• Data Dictionary

 

• Database Statistics

 

• Database Statistics

 

• Characterization of the DBMS

 

• Database Objects

 

• The Elements of the Database Language SQL

 

• The Elements of the Database Language SQL

 

• The Data Definition Language

 

• The Data Manipulation Language

 

• The Data Control Language

 

• Operating and Administration

 

• Operating and Administration

 

• Installation and Configuration

 

• Remote Administration

 

• Restart

 

• Shutdown

 

• Access Authorization

 

• User Classes

 

• User Classes

 

• The User Class SYSDBA

 

• The User Class DBA

 

• The User Class RESOURCE

 

• The User Class STANDARD

 

• Database Objects

 

• Database Objects

 

• Accounting

 

• Accounting

 

• Audit

 

• Audit

 

• Backup/Recovery

 

• Backup/Recovery

 

• Backup

 

• Backup

 

• Online Backup

 

• Parallel Backup and Recovery

 

• Log

 

• Log

 

• MIRRORED DEVSPACES

 

• MIRRORED DEVSPACES

 

• Recovery

 

• Recovery

 

• Recovery of a Previous Database State

 

• 7-Day Operation

 

• 7-Day Operation

 

• Resource Control

 

• Resource Control

 

• Security Criteria

 

• Security Criteria

 

• Consistent Database State

 

• Consistent Database State

 

• Transaction Integrity

 

• Transaction

 

• Subtransaction

 

• User Control of Transactions

 

• Rollback

 

• Concurrent Access

 

• Lock Modes

 

• Lock Modes

 

• Isolation Levels

 

• Explicit Locking

 

• Explicit Locking

 

• Releasing Locks

 

• Releasing Locks

 

• Deadlocks

 

• Deadlocks

 

• General Technical Features

 

• SERVERDB

 

• SERVERNODE

 

• Client-Server Support

 

• Data Types

 

• Data Types

 

• Numeric Data Types

 

• Alphanumeric Data Types

 

• Date/Time Values

 

• BOOLEAN

 

• LONG

 

• Varchar

 

• SQLMODE

 

• SQLMODE

 

• TERMCHAR SET

 

• TERMCHAR SET

 

• MAPCHAR SET

 

• MAPCHAR SET

 

• Costs of a SELECT Statement

 

• Costs of a SELECT Statement

 

• Key Generation

 

• Key Generation

 

• System Resources

 

• System Resources

 

• Space Required by the Database Programs and Documentation

 

• Space Required by the Database

 

• Embedding the Database in the System

 

• Storage Procedures

 

• Storage Procedures

 

• B* Trees

 

• No Reorganization

 

• Storage Management

 

• Logging

 

• Logging

 

• Data Storage

 

• Data Storage

 

• Multi-volume Tables

 

• Multi-volume Tables

 

• Protection

 

• Protection

 

• Data Area Failures

 

• Data Area Failures

 

• Optimization

 

• Optimization

 

• Independent Optimization

 

• User-controlled Tuning

 

• Constraints

 

• Constraints