Question 5 Part A For each index type in the table below, put a tick (v) for all categories that apply. Index organization Dense Non-Dense Index type Primary index Clustering index Secondary index Part B Choose the correct answer for each of the following multiple choice questions. 1. Primary Index can be defined on ordered files on non-key attribute: a. True. b. False. 2. A file organization in which records are sorted based on the value of one of field is called: a. Heap file organization. b. Sequential file organization. c. Hash file organization. d. Both (a) and (b). 3. Which of the following statement is NOT correct? a. A Database is a collection of related data b. A Database Management System is a collection of programs that enables user to create and maintain a database C. Data are known facts that can be recorded and that have implicit meaning. d. Meta-Data is a subset of the database. 4. It is always better to use a DBMS, even for small applications with one user. a. True b. False