access path

The method used by the database to access data (as determined by the database optimizer).


An acronym for atomicity, consistency, isolation, and durability. Each of these four qualities is necessary for a transaction to be designed correctly.

active log

The instance of the database log that is currently in use.

Active Server Pages (ASP)

A Microsoft technology enabling programmers to develop custom code that works with Microsoft’s Internet Information Server (IIS).

ad hoc query

A query constructed and executed to answer an immediate and unanticipated question or need.


Short for Microsoft ActiveX Data Objects. ADO enables client applications to access and manage data from a range of sources through an OLE DB provider. ...

Get Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.