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
143. Collectively, a course number, course title, and course description would be called
- record
- field
- file
- database
145. A characteristic or quality describing a particular entity is called
- record
- file
- attribute
- . pointer.
146. Which of the following is an attribute?
- student
- student database
- student personal history file
- student
147. 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.
149. Problems with the traditional file environment include
- data redundancy
- poor data security
- inability to share data among applications
- all of the above
150. 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.