II. (10 points) Assume the following create table statement in answering the following question CREATE TABLE TAB01 ( Col

[answerhappygod]

Ii 10 Points Assume The Following Create Table Statement In Answering The Following Question Create Table Tab01 Col 1 (320.39 KiB) Viewed 100 times

II. (10 points) Assume the following create table statement in answering the following question CREATE TABLE TAB01 ( Coll CHAR (4), Col2 CHAR (4), Col3 CHAR (4), Col4 CHAR (4) PRIMARY KEY (Coll), UNIQUE (Col2) ); Assume TAB01 is a sequential file ordered by Col3. (5 points) Write “X” on the cell where the type is the correct one of the corresponding index. Index on Primary Clustering Secondary Sparse Dense a. Coll Col2 Col3 Col4 b. (5 points) According to your answer in Part a, calculate the size of the index created on Col2, assuming that: Disk block size = 1024 bytes Record pointer = 8bytes Block pointer = 6 bytes Records in TAB01 = 10,000