Which of the following concurrency control schemes is not based on the serializability property?
Two - phase locking
Time-stamp based locking
None of these .
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
Manager salary details are hidden from the employee .This is
The rule that a value of a foreign key must appear as a value of some specific table is called a
Which of the following is not a recovery technique?
Protection of data from unauthorized Disclosure results in loss of _______
Which one is correct statement?Logical data independence provides following without changing application…
As per equivalence rules for query transformation, selection operation distributes over
DFD stands for
A table can have only one
_____is a full form of SQL.
What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
The size of a data item is called its _______, which can be a field of some record or may be a larger…
An advantage of the database management approach is
Which of the following is a reason to model data?
A _____ is used to define overall design of the database
Relationships among relationships can be represented in an-E-R model using
DBMS helps achieve
For using a specific database command is used.
Employees in a company are each assigned their own office, i.e. for each employee there exists a unique…
Which two files are used during operation of the DBMS?
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
The normal form that is not necessarily dependency preserving is
_____ database is used to provide statistical information or summaries of values based on various criteria.
Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for…
Which of the following constitutes a basic set of operations for manipulating relational data?
Drop Table cannot be used to drop a table referenced by a ______ constraint.
A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
An outstanding functionality of SQL is its support for automatic_____ to the target data.
Which of the following is not comparison operator?
In SQL the statement select * from R, S is equivalent to
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter