Database Management System Set 27
Computer Science Engineering (CSE),
Bachelor of Science in Computer Science FY (BSc CS),
Bachelor of Science in Computer Science SY (BSc CS),
Bachelor of Science in Information Technology SY (BSc IT),
Bachelor of Computer Applications (BCA),
Bachelor of Business Administration in Computer Applications (BBA [CA]),
Bachelor of Science in Information Technology (BSc IT),
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