Register

Recent questions tagged nptel-quiz

1 votes
0 answers
92
NPTEL
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
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. ...
User Avatar
1 votes
0 answers
93
nptel
Consider the following database Col 1 Col 2 Col 3 1 2 3 4 5 6 7 8 9 If Col1 and Col2 form a column family and Col3 is another column family, how is the data stored? A. 1 2 3 4 5 6 7 8 9 B. 1 4 7 2 5 8 3 6 9 C. 1 2 4 5 7 8 3 6 9 D. 1 4 7 3 6 9 2 5 8
Consider the following databaseCol 1Col 2Col 3123456789If Col1 and Col2 form a column family and Col3 is another column family, how is the data stored?A. 1 2 3 4 5 6 7 8 ...
User Avatar
1 votes
0 answers
95
nptel
Consider the following schedule $S$. S: l1(A),l3(D),l1(B),u1(A),l2(C),l2(B),l1(D),l2(B),l3(C),l4(A),l4(C),l5(A); Which of the following is a valid set of transactions that are potential victims? 1. {T1,T2,T3,T5} 2. {T1,T2} 3. {T1,T2,T3,T4} 4. {T1,T2,T3}
Consider the following schedule $S$. S: l1(A),l3(D),l1(B),u1(A),l2(C),l2(B),l1(D),l2(B),l3(C),l4(A),l4(C),l5(A); Which of the following is a valid set of transactions tha...
User Avatar
1 votes
1 answer
99
NPTEL
If 5 relations are put through the zig-zag configuration of join tree and the order of join does not matter, how many different join trees are possible? 1. 960 2. 840 3. 1024 4. 512
If 5 relations are put through the zig-zag configuration of join tree and the order of join does not matter, how many different join trees are possible?1. 960 2. 840 3. 1...
User Avatar
1 votes
1 answer
100
NPTEL
A system where commutativity is considered different, in how many ways the join of n relations r1,r2,…, rn can be taken? 1. (2n−2)!/(n−1)! 2. (2n−2)!/n!(n−1)! 3. (2n−1)!/n!(n−1)! 4. None
A system where commutativity is considered different, in how many ways the join of n relations r1,r2,…, rn can be taken?1. (2n−2)!/(n−1)! 2. (2n−2)!/n!(n−1)! 3...
User Avatar
2 votes
2 answers
102
NPTEL
Which of the following is not a cause of transaction failure? 1. System Crash 2. Deadlock 3. Exception 4. All of the above are causes of transaction failures
Which of the following is not a cause of transaction failure?1. System Crash2. Deadlock3. Exception4. All of the above are causes of transaction failures
User Avatar
0 votes
0 answers
104
NPTEL
For which of the following operators does the following relation hold. ΠL(E1⊕E2)=ΠL(E1)⊕ΠL(E2) 1. ∪ 2. ∩ 3. − 4. Both ∩ and ∪
For which of the following operators does the following relation hold. ΠL(E1⊕E2)=ΠL(E1)⊕ΠL(E2) 1. ∪ 2. ∩ 3. − 4. Both ∩ and ∪
User Avatar
1 votes
0 answers
105
NPTEL
The number of configurations of a zig-zag join tree that can be formed when the order of leaves matters. 1. 2n−1 2. (2n−2)!2n−1(n−1)! 3. 2n−2 4. (2n−2)!n!(n−1)!
The number of configurations of a zig-zag join tree that can be formed when the order of leaves matters.1. 2n−1 2. (2n−2)!2n−1(n−1)! 3. 2n−2 4. (2n−2)!n!(n−...
User Avatar
1 votes
0 answers
106
NPTEL
The most generalized form of a join tree is a zig-zag tree. 1. False 2. True
The most generalized form of a join tree is a zig-zag tree.1. False2. True
User Avatar
0 votes
0 answers
107
NPTEL
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
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...
User Avatar
0 votes
1 answer
111
NPTEL
Which of the following relational operators is commutative? 1. Difference, Union 2. Full outer join and Left outer join 3. Full outer join and intersection 4. Right outer join and Union
Which of the following relational operators is commutative?1. Difference, Union 2. Full outer join and Left outer join 3. Full outer join and intersection 4. Right outer...
User Avatar
0 votes
1 answer
112
NPTEL
In what kind of index does an index entry appear only for certain keys? 1. Dense 2. Sparse 3. Simple 4. Inner
In what kind of index does an index entry appear only for certain keys?1. Dense2. Sparse3. Simple4. Inner
User Avatar
1 votes
0 answers
114
NPTEL
In an external merge sort, where the number of blocks in the relation is 324, suppose we can put only 4 blocks at a time into the memory. In the worst case, how many totals seeks will happen? 1. ∼2400 2. ∼2700 3. ∼3000 4. ∼3300
In an external merge sort, where the number of blocks in the relation is 324, suppose we can put only 4 blocks at a time into the memory. In the worst case, how many tota...
User Avatar
0 votes
0 answers
115
NPTEL
In an external merge sort, where number of blocks in the relation is 324, suppose we can put only 4 blocks at a time into the memory. In the worst case, how many total block transfers will happen? 1. 2592 2. 3240 3. 3888 4. 4230
In an external merge sort, where number of blocks in the relation is 324, suppose we can put only 4 blocks at a time into the memory. In the worst case, how many total bl...
User Avatar
0 votes
1 answer
116
NPTEL
Which of the following does not interrupt a running process? 1. A device 2. Timer 3. Power Failure 4. None of the above
Which of the following does not interrupt a running process?1. A device2. Timer3. Power Failure4. None of the above
User Avatar
Page: