C170 (All questions correctly solved)

Access plan correct answers 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 correct answers An alternative name for a column or table in a SQL statement. ALTER TABLE correct answers 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 correct answers In DB2, a named section of permanent storage space that is reserved to store the database. Atomic attribute correct answers An attribute that cannot be further subdivided to produce meaningful components. For example, a person's last name attribute cannot be meaningfully subdivided. Atomicity correct answers 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 correct answers A method by which a DBMS finds the most efficient access path for the execution of a query. B-tree index correct answers An ordered data structure organized as an upside-down tree. Base tables correct answers Tables on which the view is based batch update routine correct answers A routine that pools transactions into a single batch to update a master table in a single operation. BETWEEN correct answers In SQL, a special comparison operator used to check whether a value is within a range of specified values. binary relationship correct answers An ER term for an association (relationship) between two entities. For example, PROFESSOR teaches CLASS. Bitmap index correct answers An index that uses a bit array (0s and 1s) to represent the existence of a value or condition. Boolean Algebra correct answers A branch of mathematics that uses the logical operators OR, AND, and NOT.