C170 QUESTION AND ANSWER ALREADY PASSED

Access plan -A set of instructions generated at application compilation time that is created and managed by a DBMS. The access plan predetermines how an application's query will access the database at run time. Alias -An alternative name for a column or table in a SQL statement. ALTER TABLE -The SQL command used to make changes to table structure. When the command is followed by a keyword (ADD or MODIFY), it adds a column or changes column characteristics. AREA -In DB2, a named section of permanent storage space that is reserved to store the database. Atomic attribute -An attribute that cannot be further subdivided to produce meaningful components. For example, a person's last name attribute cannot be meaningfully subdivided. Atomicity -The transaction property that requires all parts of a transaction to be treated as a single, indivisible, logical unit of work. All parts of a transaction must be completed or the entire transaction is aborted. automatic query optimization -A method by which a DBMS finds the most efficient access path for the execution of a query. B-tree index -An ordered data structure organized as an upside-down tree. Base tables -Tables on which the view is based batch update routine -A routine that pools transactions into a single batch to update a master table in a single operation.