Question Detail

Secondary index can be related with

  • Function dependency
  • B tree
  • Domain calculus
  • Relational algebric operators
Similar Questions :

1. Large collection of files are called

  • fields
  • Records
  • Database
  • Sectors

2. Fragmentation of a file system

  • Can always be prevented
  • occurs only is file is not used properly
  • Can be temporarily removed by compaction
  • None of above

3. Related fields in a data base are grouped to form

  • data file
  • data record
  • menu
  • bank

4. Allocation map

  • Used to store program data
  • specifies which blocks are used by which file
  • is updated by application programs
  • allow programs to erase files

5. The command that adds a new field to an active database is

  • MODIFY LABEL
  • MODIFY COMMAND
  • MODIFY STRUCTURE
  • MODIFY REPORT
Read more from - Database Question Answers - Chapter 1