in Education by
A hash table can store a maximum of 10 records, currently there are records in location 1, 3,4,7,8,9,10. The probability of a new record going into location 2, with hash functions resolving collisions by linear probing is (a) 0.1 (b) 0.6 (c) 0.2 (d) 0.5 This question was addressed to me in an international level competition. This key question is from Hashing techniques in chapter Indexing and Hashing of Database Management Select the correct answer from above options Interview Questions and Answers, Database Interview Questions and Answers for Freshers and Experience

1 Answer

0 votes
by
Right option is (b) 0.6 The best explanation: Hashing is used to index and retrieve items in a database because it is easier to find the item using the shortened hashed key than using the original value.

Related questions

0 votes
    The digits 1,2,3,4,5,6,7,8 and 9 are written in random order to form a nine digit number. The probability that this ... 2 9 2 D. 7 9 7 Select the correct answer from above options...
asked Nov 15, 2021 in Education by JackTerrance
0 votes
    Which of the following scenarios leads to linear running time for a random search hit in a linear-probing ... topic in division Indexing and Hashing of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    Can you arrange 9 numerals - 1, 2, 3, 4, 5, 6, 7, 8 and 9 [using each numeral just once] above and below a division line, to create a fraction equaling to 1/3 [one third]?...
asked Feb 13, 2021 in Education by JackTerrance
0 votes
    _____________ will produce a sequential vector c( (1,2,3,4,5,6,7,8,9)). (a) Seq(9) (b) Seq ... Functions and Debugging of R Programming Select the correct answer from above options...
asked Feb 13, 2022 in Education by JackTerrance
0 votes
    >>> list(range(0, -9,-1)) will print [-1, -2, -3, -4,-5, -6, -7, -8) [0,-1, -2, -3, -4,-5, -6, -7, -8 ... [0,-1, -2, -3, -4,-5, -6, -7] Select the correct answer from above options...
asked Dec 28, 2021 in Education by JackTerrance
0 votes
    If h is any hashing function and is used to hash n keys in to a table of size m, where n...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    8 cards are numbered as 1, 2, 3, 4, 5, 6, 7, 8 respectively. They are kept in a box and mixed thoroughly. Once card ... 4? ½ ¾ 3/8 3/5 Select the correct answer from above options...
asked Nov 23, 2021 in Education by JackTerrance
0 votes
0 votes
    A game of chance consists of spinning an arrow, which comes to rest pointing at one of the numbers 1, 2, 3, 4, ... at any factor of 8. Select the correct answer from above options...
asked Nov 23, 2021 in Education by JackTerrance
0 votes
    In a game of chance, a spinning arrow comes to rest at one of the numbers 1, 2, 3, 4, 5, 6, 7, 8. All ... 2. iv. a number less than 9. Select the correct answer from above options...
asked Nov 13, 2021 in Education by JackTerrance
...