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
151. Which of the following is a group of files?
- attribute
- database
- field
- segment
152. A logical view is:
- the process of creating small stable data structures from complex groups of data when designing a relational database
- a methodology for documenting databases illustrating the relationship between various entities in the database
- an approach to data management that stores both data and the procedures acting on the data as objects that can be automatically retrieved and shared.
- a representation of data as they would appear to an application programmer or user.
153. The language associated with a database management system that is employed by end users and programmers to manipulate data in the database is the:
- data definition language
- data presentation language
- data manipulation language
- data translation language
155. 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
156. A row or record in a relational database is called a(n):
- field
- pointer
- file
- tuple
157. 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
158. 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
159. The logical database model that presents data to users in a treelike structure is the:
- object-oriented DBMS
- network DBMS
- relational DBMS
- hierarchical DBMS
160. The hierarchical DBMS organizes data elements into:
- segments
- data compartments.
- data units.
- objects.