DBMS MCQ Question and Answer

DBMS MCQ Question and Answer
91. A characteristic or quality describing a particular entity is called
  • record
  • file
  • attribute
  • pointer
Show Answer
92. Which of the following is an attribute?
  • a student
  • a student database
  • a student personal history file
  • a student
Show Answer
93. The field in a record that uniquely identifies instances of that record so that it can be retrieved, updated, or sorted best describes
  • master key
  • master field
  • attribute
  • key field
Show Answer
94. The smallest data element in the data hierarchy is a
  • byte
  • field
  • bit
  • file
Show Answer
95. Problems with the traditional file environment include
  • data redundancy
  • poor data security
  • inability to share data among applications
  • all of the above
Show Answer
96. The situation that occurs when different divisions, functional areas, and groups in an organization independently collect the same piece of information best describes
  • program-data independence
  • data redundancy
  • lack of flexibility
  • poor security
Show Answer
97. Which of the following is a group of files?
  • attribute
  • database
  • field
  • segment
Show Answer
98. A logical view is
  • the process of creating small stable data structures from complex groups of data when designing a relational database.
  • a methodology for documenting databases illustrating the relationship between various entities in the database.
  • an approach to data management that stores both data and the procedures acting on the data as objects that can be automatically retrieved and shared.
  • a representation of data as they would appear to an application programmer or user.
Show Answer
99. The language associated with a database management system that is employed by end users and programmers to manipulate data in the database is the
  • data definition language
  • data presentation language
  • data manipulation language
  • data translation language
Show Answer
100. The most prominent data manipulation language today is
  • COBOL.
  • DL/1
  • IMS
  • SQL
Show Answer
Questions and Answers for Competitive Exams Various Entrance Test