Database Question Answers - Chapter 1

• 22. Which is a type of DBMS software

  1. utilities
  2. query language
  3. report writer
  4. All of above

  Answer And Explanation

  Answer: Option D

  Explanation:

  • View Answer
  • Comment on this question

• 23. Large collection of files are called

  1. fields
  2. Records
  3. Database
  4. Sectors

  Answer And Explanation

  Answer: Option C

  Explanation:

  • View Answer
  • Comment on this question

• 24. 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 And Explanation

  Answer: Option C

  Explanation:

  • View Answer
  • Comment on this question

• 25. Data dictionary is a special file that contains

  1. the names of all fields in all files
  2. the data types of all fields of all files
  3. Both of above
  4. None of above

  Answer And Explanation

  Answer: Option B

  Explanation:

  • View Answer
  • Comment on this question

• 26. Two basic types of record access methods are

  1. sequential and random
  2. direct and immediate
  3. sequential and indexed
  4. online and real time

  Answer And Explanation

  Answer: Option A

  Explanation:

  • View Answer
  • Comment on this question

• 27. Secondary index can be related with

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

  Answer And Explanation

  Answer: Option B

  Explanation:

  • View Answer
  • Comment on this question

• 28. Natural join can be related with

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

  Answer And Explanation

  Answer: Option D

  Explanation:

  • View Answer
  • Comment on this question