Quiz
C192 Thuggery
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 (10)
1Lock ____ indicates the level of lock use.
- Agranularity
- Bshrinking
- Cgrowing
- Dserializability
2During the ____ phase, the transaction scans the database, executes the needed computations, and makes the updates to a private copy of the database values.
- Aread
- Bvalidation
- Cwrite
- Dshared
3During the ____ phase, the transaction is confirmed to ensure that the changes made will not affect the integrity and consistency of the database.
- Aread
- Bvalidation
- Cwrite
- Dshared
4During the ____ phase, the changes are permanently applied to the database.
- Aread
- Bvalidation
- Cwrite
- Dshared
5A(n) ____ backup of the data is when only the last modifications done to the database are copied.
- Adifferential
- Bcomplete
- Cpartial
- Dincomplete
6A transaction that changes the contents of the database must alter the database from one ____ state to another.
- Aconsistent
- Bdependent
- Cindependent
- Dinconsistent
7When is the implicit beginning of a transaction?
- AWhen the database is started
- BWhen a table is accessed for the first time
- CWhen the first SQL statement is encountered
- DWhen the COMMIT command is issued
8A(n) ____ phase in a two-phase lock is when a transaction releases all locks and cannot obtain any new lock.
- Agrowing
- Bshrinking
- Clocking
- Dunlocking
9The ____ approach is based on the assumption that the majority of the database operations do not conflict.
- Adefault
- Bbasic
- Cscheduled
- Doptimistic
10A diskpage, or page, is the equivalent of a ____.
- Adatabase table
- Bdisk sector
- Cdatabase schema
- Ddiskblock
Information
- Description
- Quiz on C192 Thuggery, created by Brandon Gagon on 28/11/2020.
- Author
- Brandon Gagon
- Language
- English
- Views
- 1
- Rating
- No ratings yet Rate this quiz