This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Multiversion Schemes”. 1. The most recent version of standard SQL prescribed by the American National Standards Institute is a) SQL 2016 b) SQL 2002 c) SQL – 4 d) SQL2 2. ANSI-standard SQL allows the use of special operators in conjunction with the … Read more
This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Multiple Granularity”. 1. In a granularity hierarchy the highest level represents the a) Entire database b) Area c) File d) Record 2. In a database the file is contained in ________ a) Entire database b) Two area c) One area d) more than … Read more
This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Deadlocks”. 1. A system is in a ______ state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set. a) Idle b) Waiting c) Deadlock d) Ready 2. The deadlock state … Read more
This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Lock-Based Protocols”. 1. In order to maintain transactional integrity and database consistency, what technology does a DBMS deploy? a) Triggers b) Pointers c) Locks d) Cursors 2. A lock that allows concurrent transactions to access different rows of the same table is known … Read more
This set of Basic Database Questions and Answers focuses on “Transactions as SQL Statements”. 1. Which of the following is a property of transactions? a) Atomicity b) Concurrency c) Isolation d) All of the mentioned 2. SNAPSHOT is used for (DBA) a) Synonym b) Tablespace c) System server d) Dynamic data replication 3. Isolation of … Read more
This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Implementation of Isolation Levels”. 1. In concurrency control policy the lock is obtained on a) Entire database b) A particular transaction alone c) All the new elements d) All of the mentioned 2. A concurrency-control policy such as this one leads to ______ … Read more
This set of Database Interview Questions and Answers for Experienced people focuses on ” Querying database part – 5″. 1. Which is refers to a stalemate situation due to which no further progress is possible as computer await response of each other: a) Concurrency b) Deadlock c) Backup d) Recovery 2. Which is a duplicate … Read more
This set of Database Questions and Answers for Experienced people focuses on ” Querying database part – 4″. 1. Which s essential a business problem not a data problem: a) Data b) Database c) Database design d) All of the mentioned 2. Which is primarily the result of a thorough understanding of information about an … Read more
This set of Database Interview Questions and Answers for freshers focuses on ” Querying database part – 3″. 1. _______________ joins are SQL server default a) Outer b) Inner c) Equi d) None of the Mentioned 2. The ________________ is essentially used to search for patterns in target string. a) Like Predicate b) Null Predicate … Read more
This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Transaction Atomicity and Durability”. 1. A transaction may not always complete its execution successfully. Such a transaction is termed a) Aborted b) Terminated c) Closed d) All of the mentioned 2. If an transaction is performed in a database and committed, the changes … Read more
