Question: The placement of noncommittal data occurs when two transactions are executed concurrently and one of the transactions is rolled back after the second transaction has already accessed the uncommitted data.
Answer Options:
Answer: (A) True.
Question: _______ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
Answer Options:
Answer: (C) Isolation.
Question: ANSI has defined standards that govern SQL database transactions. Transaction support is provided by two SQL statements: _______ and ROLLBACK.
Answer Options:
Answer: (D) COMMIT.
Question: The information stored in the _______ is used by the DBMS for a recovery requirement triggered by a ROLLBACK statement, a program’s abnormal termination, or a system failure such as a network discrepancy or a disk crash.
Answer Options:
Answer: (D) transaction log.
Question: As long as two transactions, T1 and T2, access _______ data, there is no conflict, and the order of execution is irrelevant to the final outcome.
Answer Options:
Answer: (A) shared.
Question: _______ are required to prevent another transaction from reading inconsistent data.
Answer Options:
Answer: (A) Locks.
Question: Lock _______ indicates the level of lock use.
Answer Options:
Answer: (A) granularity.
Question: An _______ specifically reserves access to the transaction that locked the object.
Answer Options:
Answer: (B) exclusive lock.
Question: _______ occurs when a transaction accesses the database and commits the changes but the changes are not yet reflected in the database.
Answer Options:
Answer: (A) Inconsistent retrievals.
Question: An entity in the entity relationship model corresponds to a table in the relational environment.
Answer Options:
Answer: (A) True.
Question: A composite identifier is a primary key composed of more than one attribute.
Answer Options:
Answer: (A) True.
Question: The entity relationship diagram (ERD) represents the _______ database as viewed by the end user.
Answer Options:
Answer: (D) conceptual.
Question: A relationship is an association between _______.
Answer Options:
Answer: (B) entities.
Question: When using the Crow’s Foot notation, the associative entity is indicated by _______ relationship lines between the parents and the associative entity.
Answer Options:
Answer: (D) solid.
Question: The first step in building an entity-relationship diagram (ERD) is _______.
Answer Options:
Answer: (B) creating a detailed narrative of the organization’s description of operations.
Question: The Crow’s foot symbol with two vertical parallel lines indicates _______ cardinality.
Answer Options:
Answer: (D) (1,1).
Question: Database design is an _______ process based on repetition.
Answer Options:
Answer: (B) iterative.
Question: A(n) _______ is the set of possible values for a given attribute.
Answer Options:
Answer: (A) domain.