search
Log In
0 votes
388 views
The distribution of values for each attribute is stored in the form of an equi-width histogram. Using this histogram, the estimated size for a non-equality selection when compared to no histogram being used

1. remains the same
2. improves
3. deteriorates
4. can be exactly predicted always
in Databases 388 views

Please log in or register to answer this question.

Related questions

2 votes
0 answers
1
118 views
Which of the following transaction(s) follow 2-phase locking protocol? lock1(a)read1(a)lock2(b)write2(b)lock1(c)unlock2(b)unclock1(c)lock2(c)unlock1(a) lock1(a)lock1(b)unlock1(a)lock2(a)write2(a)unlock2(a)unlock1(b) lock1(a)lock2(b)lock1(c)lock3(d)unlock2(b)lock3(b)unlock1(a)unlock3(d)unlock1(c)lock3(c) 1. Only 1 2. Only 2 3. Only 1 and 3 4. None of them
asked Sep 29, 2017 in Databases gulsanchouhan 118 views
2 votes
0 answers
2
161 views
Which of the following statement is correct ? 1. 2 phase locking protocol does not suffer with problem of cascading rollback 2. Strict 2 phase protocol never results in deadlock 3. In strict 2 phase protocol, restriction of releasing exclusive locks until commit ensures no cascading rollbacks 4. Time-stamp ordering protocol can generate non-recoverable schedules
asked Sep 29, 2017 in Databases gulsanchouhan 161 views
3 votes
2 answers
3
107 views
Choose the correct option about the following schedule. S:R2(A);W3(A);(commitT3);W1(A);(commitT1);W2(B);R2(C);(commitT2);R4(A);R4(B);(commitT4) 1. S is both recoverable and conflict serializable 2. S is neither recoverable nor conflict serializable 3. S is recoverable but not conflict serializable 4. S is not recoverable but conflict serializable
asked Sep 29, 2017 in Databases gulsanchouhan 107 views
1 vote
0 answers
4
117 views
Which of the following can be described as a programming model used to develop applications processing massive amounts of data in a distributed and/or parallel manner? 1. Map Reduce 2 .OLAP 3. Mahout 4. Cloud Computing
asked Sep 29, 2017 in Databases gulsanchouhan 117 views
...