Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
What is bucket overflow and how bucket overflow is handled through Over Flow Chaining or Closed Hashing?
Ans: Bucket: unit of storage holding records. Bucket is a disk block or contiguous block .Bucket contains multiple records.
Hash Function: maps records to bucket numbers Function h from set of all search key values K to the set of all bucket addresses (numbers) B .Records along with different search key values may be mapped similar bucket. Whole bucket has to be searched to locate record. If bucket is full required overflow buckets and pointers
How to handle bucket overflow:
• Buckets overflow is handled through using overflow buckets1. Closed Hashing (Chaining): The overflow buckets of a given bucket are chained together in a linked list2. Open Hashing: place in further available bucket (not suitable for database applications)3. Multiple Hashing : use a second hash function
When is UPDATE_STATISTICS command used? - When processing of large data is done, this command is used. - Whenever large number of modification, deletions or copy takes place
Describe the Association: Design Before we describe association design let us define association "Association is set of links between two objects in the object model". It is
Explain the shadow paging recovery technique. Ans: Shadow paging is a method used to acquire atomic and durable transactions, and provides the capability to manipulate pages i
A Functional dependency is described by X Y between two groups of attributes Y and X that are subsets of R specifies a constraint on the possible tuple that can make a relation
Q. State the Technique for converting a state diagram to code. i) Identify the major control path. Starting with first state, find the path from diagram that corresponds
The Internal or Physical Level The collection of files permanently stored on secondary storage devices is called as the physical database. The internal or physical level is t
Explain the B + tree? B + tree is a type of tree which denotes sorted data in a way that permits for efficient insertion, retrieval and removal of records, each of which is
what is the need of a log in dbms
Explain the term - Handling Boundary Condition These are some circumstances that to be handled in any system initialization and termination. Describes how system is bro
How to design a formal and exact model How to design a formal and exact model of real-world problems by applying findings of analysis phase of OMT. The object design phase find
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd