A database consists of the tables STUDENT (PK = sno, sname, major), COURSE (PK = cno, major, ), OFFERINGS (PK = cno and ofno, ), ENROLLMENT (sno, cno, ofno, grade). All tables satisfy BCNF. Overall_gpa and gpa_in_major are computed for each student.
-There is a DBMS with 3 disks that can be read and written in parallel and a file that contains the following sequential physical records: PR1,PR2,PR3,PR4,PR5,PR6,PR7,PR8,PR9.The records are allocated in sequence to disk stripes.Select the correct statement:
A) PR1, PR2, PR3 are located each on a different disk
B) PR1, PR2, PR3 may be read in parallel from disks
C) PR1, PR2, PR3 may be written in parallel to disks
D) All of the above

Question

Quizplus · Accepted Answer

Given the setup with 3 disks that can be read and written in parallel and the sequential allocation of records across disk stripes, all statements are correct. PR1, PR2, PR3 would be allocated to different disks in a round-robin fashion, allowing for parallel read and write operations.

A Database Consists of the Tables STUDENT (PK = Sno