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
261. Most database software includes: a. special purpose database management software called the DBMS. b. application software that uses DBMS facilities to manipulate the database to achieve a specific business function. c. application software that is always written using a fourth-generation language supplied with the DBMS. d. application software that utilises the command language of the DBMS.
- a,c and d
- c and b
- b and d
- a and b
262. Which of the following closely describes a workgroup database application?
- A sales person keeping track of his customer information with contact details.
- A software development team maintaining a list of software objects.
- A personnel database that is designed to track data concerning employees, job skills and job assignments for a large organisation.
- A large healthcare organisation that operates a group of medical centres including hospitals, clinics and nursing homes.
263. The following are the three language components of a database management system (DBMS). Data Definition Language (DDL) (ii) Sub-schema DDL (iii) Data Manipulation Language Two different types of people (users and practioners) are concerned with them. Which of them do users of a DBMS usually deal with?
- (i) only
- (iii) only
- (i) and (ii) only
- (ii) and (iii) only
264. Data Independence refers to:
- Handling of data by the DBMS software entirely independent of the operating system.
- Insulating the application program from external changes such as inclusion of a new data item into an existing record structure.
- Separation of data descriptions from the application programs that uses the data.
- Allowing application programs to be executed at a node different to the database server.
265. Which of the following is (are) true with respect to data models? a. The network data model was introduced to overcome the main deficiencies in the use of files. b. The hierarchical data model uses a tree data structure. c. The object-oriented data model was introduced to deal with non-traditional commercial applications such as Geographical Information Systems (GIS). d. The relational data model was widely accepted by most users from its inception in early 1970s.
- a,c and d
- c and d
- b and c
- d and b
266. A _________ is a logically coherent collection of data with some inherent meaning, representing some aspect of real world
- Database
- data
- Data dictionary
- none
267. . A __________ is a collection of programs that enables user to create and maintain a database.
- DBMS
- Data
- Data dictionary
- none
268. The database and DBMS software together is called as_________
- Database collection
- Database method
- Database system.
- Database repository.
269. The following is /are the Advantage(s) of DBMS?
- Redundancy is controlled
- Unauthorised access is restricted
- Providing multiple user interfaces
- All the above
270. The level of abstraction that describes only part of entire database
- Physical
- External
- Internal
- Conceptual