The drawback of shadow paging technique are
All 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.
If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
As per equivalence rules for query transformation, selection operation distributes over
Which of the following concurrency control schemes is not based on the serializability property?
Protection of data from unauthorized Disclosure results in loss of _______
A list consists of last names, first names, addresses and pin codes. If all people in the list have…
_____ command can be used to modify a column in a table
The statement that is executed automatically by the system as a side effect of the modification of the…
Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
______contains information that defines valid values that are stored in a column or data type.
Which of the following is not a recovery technique?
The _______ is a set of programs to use and / or modify this data.
Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
The set of all values that can be taken by the attribute is called as _______ of the attribute.
Tree structures are used to store data in
Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
An advantage of views is
_____ database is used to provide statistical information or summaries of values based on various criteria.
In SQL the word natural can be used with
An outstanding functionality of SQL is its support for automatic_____ to the target data.
Dependency preservation is not guaranteed in
_____clause is an additional filter that is applied to the result.
Which of the following is not a consequence of non-normalized database?
Which one is true statement :
In SQL, testing whether a subquery is empty is done using
In multiple granularity of locks SIX lock is compatible with
A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
In b-tree the number of keys in each node is than the number of its children.
Data independence means
Employees in a company are each assigned their own office, i.e. for each employee there exists a unique…
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter