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!
Explain hash file organization?
Hash functions
a) The distribution is uniform
Hash functions assign each bucket the similar number of search -key values from the set of all possible search-key values
b) The distributed in random
In the average case every bucket will have nearly same no of values assigned to it, regardless of the actual distribution of search-key values
Handling of bucket overflows
o Insufficient buckets
o Skew
Open hashing
Under an alternative approach known as open hashing
Close hashing
The form of hash structure that we have just explained is something referred to as close hashing.
Hash indices
What is meant by functional dependencies? Consider a relation schema R and α C R and β C R. The functional dependency α ->β holds on relational schema R if in any legal relati
What is the meaning of Data Independence ?
Draw an ER diagram that represents the information described below. Show all entity sets, relationship sets, primary keys, and the mapping cardinality of the relationship sets.
define lock conversion
Give the levels of data abstraction? There are three levels of Data Abstraction a) Physical level b) logical level c) view level
Define Shared locks? Ans: Shared lock: Throughout concurrent execution of transactions, earlier than a transaction can access a data item, it has to obtain a lock on it. Now he
What is Thread splitting A thread of control is a path by which a set of state diagrams on that a single object is active at a time. Objects are shared between threads
Having Clause with sub queries: First we have to recollect the GROUP BYclause. The following query searches the minimum salary in every department. SELECT DEPTNO, MIN (SAL)
What are the uses of functional dependencies? To test relations to see whether they are legal under a given set of functional dependencies. To state constraints on the set
Consider the subsequent relation Professor (Pfcode, dept, head, time) It is assumed that (i) A professor can work in much more than one
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