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
271. The ability to modify the schema definition in one level should not affect the schema definition in the next higher level is known as _____________
- Data Independence
- Data dependence
- Conceptual Independence
- none
272. Modification in physical level should not affect the logical level.This is
- Physical data independence
- Logical Data independence
- Conceptual Independence
- none
273. Modification in logical level should not affect the external level.This is
- Physical data independence
- Logical Data independence
- Conceptual Independence
- none
274. A__________ collection of conceptual tools for describing data, data relationships data semantics and constraints
- Data model.
- Object oriented model
- both A & B
- none
275. An attribute or attributes that uniquely identify each row in a relation is called a(n)
- field pointer.
- column.
- primary key.
- foreign key.
276. Data modeling may be the most important part of the systems development process because
- data characteristics are important in the design of programs and other systems components
- The data in a system are generally more complex than processes, and play a central role in development
- Data are less stable than processes
- A and B.
277. A database is an organized collection of _____ related data.
- not
- badly
- physically
- logically
278. Which of the following is an entity type on which a strong entity depends?
- member.
- weak.
- unary.
- owner.
279. Disadvantages of traditional file processing systems include
- reduced data duplication.
- program-data dependence
- limited data sharing
- B and C.
280. A(n) _____ specifies the number of instances of one entity that can be associated with the each instance of another entity
- maximum
- cardinality constraint
- limit
- counter constraint