Home

Maximum height of a B+ tree of order m with n key values is

A. Logm(n)

B. (m+n)/2

C. Logm/2(m+n)

D. None of these

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