Database Questions: will give thumbs up if both questions are answered. Q1: Q2: This question refers to the Q1 question
Posted: Sat May 14, 2022 2:44 pm
Database Questions: will give thumbs up if both questions are
answered.
Q1:
Q2: This question refers to the Q1 question above
We have a database file with six million pages (6,000,000 pages), and we want to sort it using external merge sort. Assume that the DBMS is not using double buffering or blocked I/O, and that it uses quicksort for in-memory sorting. Assume that the DBMS has six buffers. How many runs will you produce in the second pass (Pass #1)? 200,000 O 1,000,000 1,000,001 3,334 O 200,001
Refer to the previous question. How many passes does the DBMS need to perform in order to sort the file completely? (Note: an online log calculator can be found at https://www.calculator.net/log- calculator.html ) 13 11 10 6 12
answered.
Q1:
- Database Questions Will Give Thumbs Up If Both Questions Are Answered Q1 Q2 This Question Refers To The Q1 Question 1 (30.22 KiB) Viewed 81 times
- Database Questions Will Give Thumbs Up If Both Questions Are Answered Q1 Q2 This Question Refers To The Q1 Question 2 (19.42 KiB) Viewed 81 times
Refer to the previous question. How many passes does the DBMS need to perform in order to sort the file completely? (Note: an online log calculator can be found at https://www.calculator.net/log- calculator.html ) 13 11 10 6 12