This set of Basic RDBMS Questions and Answers focuses on “Timestamp Based Protocols”. 1. Which of the following cannot be used to implement a timestamp a) System clock b) Logical counter c) External time counter d) None of the mentioned 2. A logical counter is _________ after a new timestamp has been assigned a) Incremented … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Deadlock Handling”. 1. A system is in a _______ state if there exists a set of transactions in which every transaction is waiting for another transaction in the set. a) Deadlock b) Starved c) Isolated d) None of the mentioned 2. Which of … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Lock Based Protocols”. 1. If a transaction has obtained a __________ lock, it can read but cannot write on the item a) Shared mode b) Exclusive mode c) Read only mode d) Write only mode 2. If a transaction has obtained a ________ … Read more
This set of RDBMS Question Bank focuses on “Transaction Isolation Levels”. 1. Which of the following is a transaction isolation level as specified by SQL standard? a) Serializable b) Repeatable read c) Read committed d) All of the mentioned 2. State true or false: Serializable level may allow both serializable and non-serializable executions a) True … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Transaction Isolation”. 1. A transaction that performs only one operation is called as a _________ a) Partial schedule b) Complete schedule c) Dependent schedule d) Independent schedule 2. The phenomenon in which one failure leads to a series of transaction rollbacks is called … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Serializability”. 1. I and J are _________ if they are operations by different transactions on the same data item, and at least one of them is a write operation. a) Conflicting b) Overwriting c) Isolated d) Durable 2. If a schedule S can … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Transaction Concept and Model”. 1. Collections of operations that form a single logical unit of work are called __________ a) Views b) Networks c) Units d) Transactions 2. The “all-or-none” property is commonly referred to as _________ a) Isolation b) Durability c) Atomicity … Read more
This set of RDBMS online quiz focuses on “Materialized Views and Advanced Topics in Query Optimization”. 1. A view whose contents are computed and stored is called as _______ a) Storage view b) Backup view c) Materialized view d) Advanced view 2. The task of keeping a view up to date with the underlying data … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Choice of Evaluation Plans”. 1. A ________ explores the space of all query evaluation plans that are equivalent to a given query. a) Cost based optimizer b) Space based optimizer c) Time based optimizer d) None of the mentioned 2. What is the … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Estimating Statistics of Expression Results”. 1. Which of the following information does the database system catalog store? a) Number of tuples b) Number of blocks c) Size of a tuple of a relation d) All of the mentioned 2. Most databases store the … Read more
