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
291. Number of tuples present in a table at any instance is called as?
- intension
- extension
- integrity
- None of the above
292. Tables derived from the ERD
- Are totally normalized
- Are always in 1NF
- Can be further denormalised
- May have multi-valued attributes
293. What is degree of a Relation?
- It is the number of attribute of its relation schema
- It is an association among two or more entities
- The collection (or set) of similar relationships
- None of the above
294. What is Relationship?
- It is the number of attribute of its relation schema
- The collection (or set) of similar relationships
- None of the above
- It is an association among two or more entities
295. The particular property which describes the entity is called as
- Integrity
- Table
- Database
- Attribute
296. Which language of database specifies user views and their mappings to the conceptual schema
- SDL (Storage Definition Language)
- VDL (View Definition Language)
- DDL (Data Definition Language)
- Data Storage - Definition Language
297. Which translates DML statements in a query language?
- DDL Interpreter
- Query evaluation engine
- DML Compiler
- None of the above
298. Which abstraction existing in the DBMS?
- Physical level
- Logical level
- View level
- All the above
299. The 'thing' in the real world with an independent existence is called as.
- Entity set
- attributes
- degree
- entity
300. A database with single table structure is called a _________
- Hierarchical data model
- Relational data model
- Flat file structure
- Network data model