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
371. the number of attribute of a relation schema is known as
- degree of a relation.
- cardinality of a relation.
- both A & B
- none
372. an entity set may not have sufficient attributes to form the primary key.
- strong entity set
- small entity set
- weak entity set
- none.
373. which of the following are the advantages of E-R model
- conceptual simplicity
- visual representation
- integrity
- both a & b
374. The following term applies to a collection of related records in a database
- File
- Layout
- File
- Field
375. This set of related data items is known as a
- File
- Record
- Table
- None of the above
377. The following command is used to search the record that safisfies the secified criteria
- Found
- Search
- Get
- Locate
378. The data in a record is of the following types
- Four text fields and three numeric fields
- two integer fields and five text fields
- Three text fields and four numeric fields
- none of the above
379. A treelike structure of records in a database. Select the best fit for answer
- Hierarchical database structure
- Relational atabase structure
- Multidimensional database structure
- Sequential database access
380. The followingg language used by most of the DBMSs for helping their users to access data
- High level language
- Query language
- SQL
- 4GL