COMP9315 19T2 Quiz 5
Sample Solutions
DBMS Implementation

  1. How many tuples from query select * from Parts where size = 'huge'; ?


  2. For the query
    select a,b,c,d,e,f from R, S, T where R.id = S.rid and T.id = S.tid
    which is not a valid join order?


  3. Number of pages read for block nested loop join with 35 buffers.


  4. Cost of hybrid hash join on R&bowties;S, with 17 memory buffers, b_R = 60, b_S = 60, ...