GoConqr hat ein neues Design! Sag uns, wie es dir gefällt.

Quiz

C192 Thuggery

Brandon Gagon 10 Fragen

Quiz starten

Fragen in diesem Quiz (10)

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

Informationen

Beschreibung
Quiz am C192 Thuggery, erstellt von Brandon Gagon am 28/11/2020.
Sprache
English
Aufrufe
1
Bewertung
Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz

Feedback

Worum geht es?

Wie gefällt dir das neue Design?

Dein Eindruck