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.
The rule that a value of a foreign key must appear as a value of some specific table is called a
Precedence graphs help to find a
Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
SQL server stores index information in the _____system table
In a relational schema, each tuple is divided into fields called
The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
The collection of information stored in a database at a particular moment is called as ......
In b-tree the number of keys in each node is than the number of its children.
A transaction is in state after the final statement has been executed.
If an entity can belong to only one lower level entity then the constraint is
A top-to-bottom relationship among the items in a database is established by a
Which of the following is not a characteristic of a relational database model?
The middleware databases in which the business rules act are applicable to _______ tier architectures
The _______ is a set of programs to use and / or modify this data.
In SQL the statement select * from R, S is equivalent to
A _____ is used to define overall design of the database
______is a special type of integrity constraint that relates two relations & maintains consistency across…
The part of a database management system which ensures that the data remains in a consistent state is
_____ First proposed the process of normalization.
Which of the following is not a property of transactions?
The normal form that is not necessarily dependency preserving is
Which of the following is not a consequence of concurrent operations?
Grant and revoke are _____ statements.
approach reduces time and effort required for design and lesser risk in database management.
____specifies a search condition for a group or an aggregate.
A _____ is a logical unit of database processing that includes one or more data access operations that…
Which is the best file organization when data is frequently added or deleted from a file?
The relational model is based on the concept that data is organized and stored in two-dimensional tables…
In E-R Diagram total participation is represented by
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter