Maximum height of a B+ tree of order m with n key values is
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.
_____ database is used to provide statistical information or summaries of values based on various criteria.
If an entity can belong to only one lower level entity then the constraint is
Dependency preservation is not guaranteed in
The normal form that is not necessarily dependency preserving is
Which of the following is true for network structure?
Which of the following is not a recovery technique?
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
The metadata is created by the
By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
HSAM stands for .
What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
As per equivalence rules for query transformation, selection operation distributes over
_____ is a utility to capture a continuous record of server activity and provide auditing capability.
When an E-R diagram is mapped to tables, the representation is redundant for
Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
Which of the following is not a consequence of concurrent operations?
In an ER model,_____ is described in the database by storing its data.
Data independence means
______is a special type of integrity constraint that relates two relations & maintains consistency across…
What is a disjoint less constraint?
SQL server stores index information in the _____system table
DFD stands for
In b-tree the number of keys in each node is than the number of its children.
____specifies a search condition for a group or an aggregate.
______ keyword is used to find the number of values in a column.
An advantage of the database management approach is
The language that requires a user to specify the data to be retrieved without specifying exactly how…
_____ command can be used to modify a column in a table
Precedence graphs help to find a
Processed data is called _____
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter