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!
Differance between Open addressing and chaining for collision resolution ?
In open addressing, proceeding from the occupied position specified by hash address the program checks the subsequent positions in order until an unused (empty) position is found.
Chaining: In this method various overflow locations are kept, commonly by extending the way with a number of overflow positions. In addition, a pointer field is added to each record location. A collision is resolved by placing the latest record in an unused overflow location and setting the pointer of occupied hash address location to the address of in which overflow location. A linked list of overflow records for every hash address is therefore maintained.
A domain is a set of permissible values that can be given to an attribute. So each attribute in a table has a definite domain. Values to these attributes cannot be assigned outside
What is property - properties of a database ? It is an integrated collection of logically related records. It consolidates separate files into a common pool of data records and
what do you mean by consistency in rdbms?
What is data block? Data Block - In oracle the data blocks are referred to as tablespaces. A tablespace is an fields of disk consisting of one or more disk files. A tablespace
What is De-normalization? De-normalization is the method of attempting to optimize the performance of a database by adding redundant data. It is sometimes essential because cur
Creation of Indexes Automatically: When a primary key or Unique constraint is show in a table definition then a unique index is formed automatically. Manually: User can
Briefly explain each of the following database terms. Use no more than 2-3 lines for each term. 1. DBMS 2. Update Anomaly 3. Alias (referring to tables in SQL queries)
as a customer service employee, explain five measures you would recommend a displeased student to patronise a school canteen
Which operation is used if we are interested in only certain columns of a table? PROJECTION operation is used if we are interested in only certain columns of a table.
Can we delete data element, which is being used by table fields. No we cant delete data element.
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