Database Question Answers - Chapter 1

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

  1. MODIFY LABEL
  2. MODIFY COMMAND
  3. MODIFY STRUCTURE
  4. MODIFY REPORT

  Answer :

  Option C

• 2. 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

  Answer :

  Option B

• 3. In order to use a DBMS, it is important to understand

  1. the physical schema
  2. all subschemas
  3. one sub schema
  4. none of above

  Answer :

  Option C

• 4. Natural join can be related with

  1. Function dependency
  2. B tree
  3. Domain calculus
  4. Relational algebric operators

  Answer :

  Option D

• 5. Which is not a logical database structure

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

  Answer :

  Option A

• 6. Which command is used to set a link between two database files

  1. JOIN
  2. UPDATE
  3. BROWSE
  4. SET RELATION

  Answer :

  Option D

• 7. Data item characteristics that are important in data management include

  1. punctuation
  2. language
  3. spelling
  4. width

  Answer :

  Option D