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
101. Which of the following is an automated or manual tool for storing and organizing information about the data maintained in a database?
- JAD
- electronic journal
- data dictionary
- hypermedia database
102. A row or record in a relational database is called a(n)
- field
- pointer
- file
- tuple
103. In a relational database, the operation that creates a subset of data consisting of columns in a table, permitting the user to create new tables that contain only the information required is the
- join operation
- project operation
- section operation
- select operation
104. In the relational database, the operation that combines relational tables to provide the user with more information than is available in individual tables is the
- join operation
- merge operation
- select operation
- grow operation
105. The logical database model that presents data to users in a treelike structure is the
- object-oriented DBMS
- network DBMS
- relational DBMS
- hierarchical DBMS
106. The hierarchical DBMS organizes data elements into
- segments
- data compartments
- data units
- objects
107. An abstract model of the database from a business perspective best defines
- physical design
- object design
- organizational view
- conceptual design
108. The process of creating small, stable data structures from complex groups of data when designing a relational database defines
- data decomposition
- data structuring
- data transcribing
- normalization
109. Which of the following best describes a special organizational function for managing the organization
- database administration
- information management
- data analysis
- data administration
110. Data administration
- establishes specific policies and procedures through which data can be managed as an organizational resource
- establishes access rules and procedures
- defines and organizes database structure and content
- maintains the database