A Database Consists of the Tables STUDENT (PK = Sno

question 4

Multiple Choice

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