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
341. Which of the following is/are true about a relation? (a) Each relation in a database should have a unique name. (b) Intersection of each row and column is single valued. (c) Primary key of a relation should be the first column. (d) Each attribute within a relation has a unique name. (e) The sequence of rows in a relation should be in ascending order
- a,b and c
- c, d and e
- a,b and d
- d,e and b
342. Which of the following is/are true for the relational data structure? (a) Cardinality of a relation is the number of columns in a relation. (b) Every attribute of a relation must be defined on exactly one underlying domain. (c) A foreign key cannot contain null values. (d) Degree of a relation is the number of columns in a relation. (e) An alternate key is a candidate key that is not the primary key.
- a,b and c
- c, d and e
- a,b and d
- b,d and e
343. . On an entity-relationship diagram, a relationship is documented with
- ellipse.
- square.
- diamond
- pyramid.
344. The most important stages in arriving at a physical database design are
- Business modeling and physical database design
- Requirement gathering and logical database design
- E-R diagrams and SQL scripts
- Logical database design and physical database design
345. __________is a thing that exists and is distinguishable.
- entity
- domain
- entity set
- all the above
346. The term used to identify a row of a table in the relational data model is
- Cardinality
- Data
- Data Set
- Tuple
347. __________ data base design allows us to generate a set of schemas that allows us to store information with minimum redundancy of data
- relational
- hierarchical
- network
- none
348. which of the following is record based logical model
- network model
- object oriented model
- relational model
- both a & c
349. which of the following model supports multiple parent child relationships
- network model
- hierarchical model
- relationl model
- none