Isolation of the transactions is ensured by
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
Which of the following concurrency control schemes is not based on the serializability property?
What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
The _______ is a set of programs to use and / or modify this data.
Shadow paging has
In b-tree the number of keys in each node is than the number of its children.
In an E-R diagram double lines indicate
By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
_____ is a utility to capture a continuous record of server activity and provide auditing capability.
Which of the following ensures the atomicity of the transaction?
Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
A _____ is used to define overall design of the database
What is a disjoint less constraint?
The statement that is executed automatically by the system as a side effect of the modification of the…
It is an abstraction through which relationships are treated as higher level entities
Which one is correct statement?Logical data independence provides following without changing application…
Relational Algebra is
DROP is a statement in SQL.
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
______contains information that defines valid values that are stored in a column or data type.
Tree structures are used to store data in
DBMS helps achieve
An outstanding functionality of SQL is its support for automatic_____ to the target data.
Relationships among relationships can be represented in an-E-R model using
The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common…
The data in the database at a particular moment of time is called the _______
Which is the best file organization when data is frequently added or deleted from a file?
The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
Which of the following is not a recovery technique?