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

6. Ascending order of data hierarchy is

1. bit->byte->record->field->file->database
2. bit->byte->field->record->file->database
3. byte->bit->field->record->file->database
4. byte->bit->field->file->record->database

7. Which is not a logical database structure

1. Chain
2. Tree
3. Relational
4. Network

8. Embedded pointer provides

1. a secondary access path
2. a physical record key
3. an inverted index
4. all of above

9. Network structure

1. is a physical representation of data
2. is conceptually simple
3. allows many to many relationships
4. none of above

10. File record length

1. should always be fixed
2. should always be variable
3. should be chosen to match the data character
4. depends upon the size of file