Database Question Answers

1. If a relation scheme is in BSNF then it is also in

1. First normal form
2. Second normal form
3. Third normal form
4. Not in any normal form

2. Attribute of one table matching to the primary key of other table, is called as

1. foreign key
2. secondary key
3. candidate key
4. composite key

3. Allocation map

1. Used to store program data
2. specifies which blocks are used by which file
3. is updated by application programs
4. allow programs to erase files

4. The master list of an indexed file

1. is sorted in ascending order
2. contains only a list of keys and record numbers
3. has a number assigned to each record
4. none of above

5. Database management systems are used to

1. eliminate data redundancy
2. establish relationships among records in different files
3. manage file access
4. none of above