DBMS MCQ Questions and Answers
DBMS MCQ questions with answers form a vital part of technical exams and campus interviews. This topic explores database concepts, normalization, SQL queries, transaction management, and ER models. Practicing programming questions and answers from this section strengthens your database design and query optimization skills. These questions are frequently asked in GATE, Infosys, TCS, and Wipro assessments, making them essential for students and professionals alike. Detailed solutions and explanations make this section perfect for both beginners and advanced learners aiming to master database management fundamentals.
DBMS MCQ
Showing 10 of
527 questions
91. A characteristic or quality describing a particular entity is called
- record
- file
- attribute
- pointer
92. Which of the following is an attribute?
- a student
- a student database
- a student personal history file
- a student
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
95. Problems with the traditional file environment include
- data redundancy
- poor data security
- inability to share data among applications
- all of the above
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
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.
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