gs gs117 Transactions - Transaction Atomicity and Durability - Quiz No.1
gs gs117 Database Management System Quiz
This quiz belongs to book/course code gs gs117 Database Management System of gs organization. We have 92 quizzes available related to the book/course Database Management System. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Transactions. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: A transaction may not always complete its execution successfully. Such a transaction is termed
Aborted
Terminated
Closed
All of the mentioned
Question 2: If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by
Flashback
Rollback
Both Flashback and Rollback
Cannot be done
Question 3: Each modification done in database transaction are first recorded into the
Harddrive
Log
Disk
Datamart
Question 4: When the transaction finishes the final statement the transaction enters into
Active state
Committed state
Partially committed state
Abort state
Question 6: Which of the following is an atomic sequence of database actions?
Transaction
Concurrency
Relations
All of the mentioned
Question 7: If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called
Consistent state
Parallel state
Atomic state
Inconsistent state
Question 8: _______ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
Serializability
Atomicity
Isolation
Time stamping
Question 9: DBMS periodically suspends all processing and synchronizes its files and journals through the use of
Checkpoint facility
Backup facility
Recovery manager
Database change log
Question 10: Which of the following is not a state in transaction?
Active
Terminated
Aborted
Partially committed
Online Quizzes of gs117 Database Management System
Indexing and Hashing - Bitmap Indices - Quiz No.1
gs gs117
Database Management System Online Quizzes
