Drop Table cannot be used to drop a table referenced by a ______ constraint.
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
The data in the database at a particular moment of time is called the _______
Which normal form is considered adequate for normal relational database design?
Which is the best file organization when data is frequently added or deleted from a file?
Which of the following statement on the view concept in SQL is invalid?
Which of the following is not a consequence of concurrent operations?
The normalization was first proposed by .
In b-tree the number of keys in each node is than the number of its children.
A table can have only one
For correct behaviour during recovery, undo and redo operation must be
____specifies a search condition for a group or an aggregate.
If the closure of an attribute set is the entire relation then the attribute set is a
By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
Which of the following is not a characteristic of a relational database model?
Which of the following is true for network structure?
The common column is eliminated in
In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
If a transaction T has obtained an exclusive lock on item Q, then T can
In SQL the word natural can be used with
Grant and revoke are _____ statements.
In SQL, testing whether a subquery is empty is done using
In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect…
………………… approach reduces time and effort required for design…
Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
DBMS helps achieve
What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
Which of the following is not comparison operator?
The size of a data item is called its _______, which can be a field of some record or may be a larger…
The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
In multiple granularity of locks SIX lock is compatible with
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter