As per equivalence rules for query transformation, selection operation distributes over
All of the above.
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
The one guideline to be followed while designing the database is
For correct behaviour during recovery, undo and redo operation must be
The default level of consistency in SQL is
The data in the database at a particular moment of time is called the _______
_____ command can be used to modify a column in a table
Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
An advantage of the database management approach is
Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common…
A _____ is used to define overall design of the database
Which of the following statement on the view concept in SQL is invalid?
The middleware databases in which the business rules act are applicable to _______ tier architectures
DROP is a statement in SQL.
By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
Processed data is called _____
A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
Checkpoints are a part of
A list consists of last names, first names, addresses and pin codes. If all people in the list have…
Union operator is a :
The full form of GUI is _________
____specifies a search condition for a group or an aggregate.
Which of the following concurrency control schemes is not based on the serializability property?
Which of the following relational algebra operations do not require the participating tables to be union-compatible?
Which of the following ensures the atomicity of the transaction?
In an E-R diagram double lines indicate
Isolation of the transactions is ensured by
operator is used to compare a value to a list of literals values that have been specified.
Shadow paging has
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter