On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 27

Q1 | Which server can join the indexes when only multiple indexes combined can cover the query:
  • sql
  • dbms
  • rdbms
  • all of the mentioned
Q2 | In concurrency control policy the lock is obtained on
  • entire database
  • a particular transaction alone
  • all the new elements
  • all of the mentioned
Q3 | A concurrency-control policy such as this one leads to              performance since it forces transactions to wait for preceding transactions to finish before they can start.
  • good
  • average
  • poor
  • unstable
Q4 |                      are used to ensure that transactions access each data item in order of the transactions’          if their accesses conflict.
  • zone
  • relay
  • line
  • timestamps
Q5 | In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?
  • to find the groups forming the subtotal in a row
  • to create group-wise grand totals for the groups specified within a group by clause
  • to create a grouping for expressions or columns specified within a group by clause in one direction, from right to left for calculating the subtotals
  • to create a grouping for expressions or columns specified within a group by clause in all possible directions, which is cross- tabular report for calculating the subtotals
Q6 | Which statement is true regarding external tables?
  • the default reject limit for external tables is unlimited
  • the data and metadata for an external table are stored outside the database
  • oracle_loader and oracle_datapump have exactly the same functionality when used with an external table
  • the create table as select statement can be used to unload data into regular table in the database from an external table
Q7 | SNAPSHOT is used for (DBA)
  • synonym
  • tablespace
  • system server
  • dynamic data replication
Q8 | Isolation of the transactions is ensured by
  • transaction management
  • application programmer
  • concurrency control
  • recovery management
Q9 | Which of the following statements is/are not true for SQL profiler?
  • enables you to monitor events
  • check if rows are being inserted properly
  • check the performance of a stored procedure
  • all of the mentioned
Q10 | Which of the following is the original purpose of SQL?
  • to specify the syntax and semantics of sql data definition language
  • to specify the syntax and semantics of sql manipulation language
  • to define the data structures
  • all of the mentioned
Q11 | SQL can be used to:
  • create database structures only
  • query database data only
  • modify database data only
  • all of the mentioned
Q12 | A lock that allows concurrent transactions to access different rows of the same table is known as a
  • database-level lock
  • table-level lock
  • page-level lock
  • row-level lock
Q13 | Which of the following are introduced to reduce the overheads caused by the log- based recovery?
  • checkpoints
  • indices
  • deadlocks
  • locks
Q14 | Which of the following protocols ensures conflict serializability and safety from deadlocks?
  • two-phase locking protocol
  • time-stamp ordering protocol
  • graph based protocol
  • none of the mentioned
Q15 | Which refers to a property of computer to run several operation simultaneously and possible as computers await response of each other
  • concurrency
  • deadlock
  • backup
  • recovery
Q16 | The          lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.
  • table-level
  • page-level
  • row-level
  • field-level
Q17 | Which of the following is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released?
  • record controller
  • exclusive lock
  • authorization rule
  • two phase lock
Q18 | 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.
  • idle
  • waiting
  • deadlock
  • ready
Q19 | The deadlock state can be changed back to stable state by using                             statement.
  • commit
  • rollback
  • savepoint
  • deadlock
Q20 | What are the ways of dealing with deadlock?
  • deadlock prevention
  • deadlock recovery
  • deadlock detection
  • all of the mentioned
Q21 | When transaction Ti requests a data item currently held by Tj, Ti is allowed to wait only if it has a timestamp smaller than that of Tj (that is, Ti is older than Tj). Otherwise, Ti is rolled back (dies). This is
  • wait-die
  • wait-wound
  • wound-wait
  • wait
Q22 | When transaction Ti requests a data item currently held by Tj, Ti is allowed to wait only if it has a timestamp larger than that of Tj (that is, Ti is younger than Tj ). Otherwise, Tj is rolled back (Tj is wounded by Ti). This is
  • wait-die
  • wait-wound
  • wound-wait
  • wait
Q23 | The situation where the lock waits only for a specified amount of time for another lock to be released is
  • lock timeout
  • wait-wound
  • timeout
  • wait
Q24 | The deadlock in a set of a transaction can be determined by
  • read-only graph
  • wait graph
  • wait-for graph
  • all of the mentioned
Q25 | A deadlock exists in the system if and only if the wait-for graph contains a                        
  • cycle
  • direction
  • bi-direction
  • rotation