Quiz
C192 StrongArm
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (18)
1The ____ is responsible for assigning and policing the locks used by the transactions.
- Alock manager
- Bscheduler
- CDBA
- Dtransaction log
2What is a consistent database?
- AOne in which all tables have foreign keys
- BOne in which all data integrity constraints are satisfied
- COne in which all tables are normalized
- DOne in which all SQL statements only update one table at a time
3A transaction acquires a ____ prior to data access.
- Agrain
- Btimestamp
- Clock
- Dkey
4Changes are permanently applied to the database during the ____ phase of a transaction.
- Acommit
- Bwrite
- Cinput
- Doutput
5The ____ approach to scheduling concurrent transactions assigns a global unique stamp to each transaction.
- Ascheduled
- Btable-locking
- Cunique
- Dtime-stamping
6All transactions are controlled and executed by the ____ to guarantee database integrity.
- Ascheduler
- BDBMS
- Ctransaction log
- DDBA
7You can define ____ to help the DBMS ensure that the database remains in a consistent state.
- Aintegrity constraints
- Bbusiness rules
- Clock-level transactions
- Dstored procedures
8By its nature, a single-user database system automatically ensures ____ of the database, because only one transaction is executed at a time.
- Aserializability and durability
- Batomicity and isolation
- Cserializability and isolation
- Datomicity and serializability
9The 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.- Adata dictionary
- Bmetadata
- Crollback manager
- Dtransaction log
10Which of the following is NOT stored in the transaction log?
- AThe type of operation performed
- BA record for the beginning of a transaction
- CThe name of the table
- DThe number of affected records
11What is one of the three most common data integrity and consistency problems?
- ALost updates
- BDisk failures
- CUser errors
- DDeadlocks
12The phenomenon of ____ occurs when two transactions, T1 and T2, are executed
concurrently and the first transaction (T1) is rolled back after the second transaction (T2) has already
accessed the uncommitted data—thus violating the isolation property of transactions.- Alost updates
- Buncommitted data
- Ctransaction failure
- Dinconsistent retrieval
13____ occur when a transaction calculates some summary (aggregate) functions over a set of data while other transactions are updating the data.
- Alost updates
- Buncommitted data
- Ctransaction failures
- Dinconsistent retrievals
14As long as two transactions, T1 and T2, access ____ data, there is no conflict, and the order of execution is irrelevant to the final outcome.
- Ashared
- Bcommon
- Cunrelated
- Dlocked
15The scheduler facilitates data ____ to ensure that two transactions do not update the same data element at the same time.
- Adurability
- Bisolation
- Catomicity
- Dserializability
16What is the most restrictive lock granularity?
- Adatabase
- Btable
- Cpage
- Drow
17Which lock granularity has the highest overhead?
- Adatabase
- Btable
- Crow
- Dfield
18A ____ lock has only two states.
- Ashared
- Bbinary
- Cdatabase
- Drow-level
Information
- Description
- Quiz on C192 StrongArm, created by Brandon Gagon on 28/11/2020.
- Author
- Brandon Gagon
- Language
- English
- Views
- 2
- Rating
- No ratings yet Rate this quiz