Quiz Space

Database Management Systems · End Term · 11 Dec 2022 · September 2022 term

Question 13: Consider a relation Books (isbn_no, title, publication).…

Question 13

+2 marksWritten answer

Consider a relation Books (isbn_no, title, publication). The attribute publication consists of 4 distinct values. A bitmap index is created on the attribute publication, the size of the bitmap index file is 800 bytes. Find the number of tuples in the Books relation.

Show answer

A written answer, not marked automatically.

See the whole paperTake it as a mock test

Question 13 of 28 in the IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 11 Dec 2022, in the September 2022 term (IIT M DIPLOMA FN1 EXAM ETD1 11 Dec 2022). It carries 2 marks.

More questions from this paper

  1. Q1THIS IS QUESTION PAPER FOR THE SUBJECT "DIPLOMA LEVEL: DATABASE MANAGEMENT SYSTEMS" ARE YOU SURE YOU HAVE TO WRITE EXAM…
  2. Q2Figure question
  3. Q3Figure question
  4. Q4Consider the following entity relationship diagram as shown in figure 1. Consider the following entity relationship dia…
  5. Q5Figure question
  6. Q6The RAID-4 is implemented using four disks. How much space is being utilized effectively? [Note: Each disk has a size o…
  7. Q7What is the full form of RAID?
  8. Q8Figure question
  9. Q9Consider the following schedules: S1:W3(A), R2(A), W2(A), W3(B), W3(C), W1(C) S2:W1(A), W3(A), W3(C), W2(A), W1(B), W3(…
  10. Q10Figure question
  11. Q11Figure question
  12. Q12Consider a Binary Search Tree(BST) consisting of 16 elements. What is the maximum possible height of the given BST?
  13. Q14Figure question
  14. Q15Consider the following schedule S as given below: S : R2(A), W2(A),W1(B),W2(C),W3(A),W1(A) According to the timestamp p…
  15. Q16Figure question
  16. Q17Consider a disk with a sector size of 256 bytes, 1500 tracks per surface, 60 sectors per track, and 4 double-sided plat…
  17. Q18Figure question
  18. Q19Figure question
  19. Q20Insert the key values in the following order into an empty 3 order B tree: 44, 23, 89, 56, 24, 60, 99, 10, 78, 5. The r…
  20. Q21Figure question
  21. Q22Figure question
  22. Q23Figure question
  23. Q24Figure question
  24. Q25Figure question
  25. Q26Figure question
  26. Q27Consider a multilevel index, where the outermost index entries must be kept in a single disk block. In each block, 20 e…
  27. Q28Figure question