Database Management System (DBMS)

71. How many levels of abstraction in DBMS:

  1. 2
  2. 3
  3. 4
  4. 5

Correct answer: (B)
3

72. Which are the three levels of abstraction:

  1. Physical
  2. Logical
  3. External
  4. All of these

Correct answer: (D)
All of these

73. How many types of data independence:

  1. 1
  2. 2
  3. 3
  4. 4

Correct answer: (B)
2

74. Which are the types of data independence:

  1. Physical
  2. Logical
  3. Both
  4. All of these

Correct answer: (C)
Both

75. Which is the transformation of requests and results between different levels of abstraction:

  1. Evaluation
  2. Mapping
  3. Compiler
  4. Precompiler

Correct answer: (B)
Mapping

76. Which mapping exists between the conceptual and internal levels:

  1. Conceptual
  2. Internal
  3. Both
  4. None

Correct answer: (C)
Both

77. Which mapping exists between the external and conceptual levels:

  1. Conceptual
  2. Internal
  3. Both
  4. None

Correct answer: (C)
Both

78. The related and interconnected software components of a DBMS are described by the ___________:

  1. Logical architecture
  2. Physical architecture
  3. Both
  4. None

Correct answer: (C)
Both

79. Which are the types of physical DBMS architecture can be split:

  1. Back end
  2. Front end
  3. Both
  4. None

Correct answer: (C)
Both

80. In which end is really just any application that runs on top of the DBMS and acts as a user interface:

  1. Back end
  2. Front end
  3. Both
  4. None

Correct answer: (B)
Front end

Page 8 of 45