DBMS MCQ Quiz - Objective Question with Answer for DBMS - Download Free PDF
Last updated on Jun 2, 2025
Latest DBMS MCQ Objective Questions
DBMS Question 1:
Which of the following is not an example of a popular Database Management System (DBMS) software ?
Answer (Detailed Solution Below)
DBMS Question 1 Detailed Solution
The correct answer is Python.
- Python is not a Database Management System (DBMS) software. Instead, it is a high-level programming language known for its versatility and ease of use.
- A Database Management System (DBMS) is software that allows users to create, manage, and manipulate databases efficiently.
- Examples of popular DBMS software include:
- MySQL: An open-source relational database management system widely used for web applications.
- Oracle: A powerful commercial DBMS often used in enterprise environments.
- MS Access: A Microsoft-developed DBMS for smaller-scale database applications.
- Python, on the other hand, can be used to interact with databases using libraries such as MySQL Connector, SQLAlchemy, and SQLite3, but it is not a DBMS itself.
- Python is widely used for web development, data analysis, artificial intelligence, machine learning, and many other fields.
- DBMS software allows for efficient data storage, retrieval, and management, which is crucial for large-scale applications.
- DBMS software supports Structured Query Language (SQL) for querying and managing databases.
- Python’s popularity is due to its extensive libraries and frameworks that simplify development processes.
DBMS Question 2:
Which data type can store unstructured data in a column?
Answer (Detailed Solution Below)
DBMS Question 2 Detailed Solution
The correct answer is Raw.
- Raw is a data type used to store unstructured data in a column.
- Unlike structured data types such as integers or strings, raw data type can store data that does not conform to a predefined schema or structure.
- It is useful for storing binary data, images, multimedia files, or any other data that does not fit neatly into traditional data types.
- Raw data is often used in data warehousing and big data applications, where flexibility in data storage is essential.
- Raw data type is highly versatile and can handle a wide variety of data formats.
- While it provides flexibility, it may require additional processing to interpret and utilize the stored data effectively.
- In some databases, raw data may be stored in BLOB (Binary Large Object) columns.
- Careful consideration is needed when choosing to use raw data types, as they can complicate data management and querying.
DBMS Question 3:
In MS Access, form dialog may be created using ______ menu.
Answer (Detailed Solution Below)
DBMS Question 3 Detailed Solution
The correct answer is Create > More Forms > Modal Dialog.
Key Points
- Form Dialog Creation: In MS Access, creating a form dialog specifically involves the option under More Forms called Modal Dialog.
- Create Menu: The Create menu in Access is where you find options for creating different types of database objects, including forms.
- More Forms: Within the Create menu, the More Forms option provides additional form creation options that are not immediately visible in the main form section.
- Modal Dialog: Selecting Modal Dialog allows you to create a dialog box that requires the user to interact with it before they can return to the main application window, suitable for capturing user input or displaying important messages.
- User Interface: This method helps in creating a more interactive and user-friendly interface for database applications by guiding users through specific tasks or workflows.
Additional Information
- Form Wizard: The Form Wizard is a tool that guides you through the process of creating a form based on your data.
- Data Sheet: The Data Sheet view is used for displaying and editing data in a tabular format.
- Blank Form: Creating a Blank Form gives you a starting point to design your form from scratch.
DBMS Question 4:
Before the usage of _______ table command to add a primary key, one needs to make sure that the field is ________.
Answer (Detailed Solution Below)
DBMS Question 4 Detailed Solution
The correct answer is ALTER, NOT NULL.
Key Points
- The ALTER table command is used to modify the structure of an existing table in a database.
- When adding a primary key to a table, it is essential to ensure that the field designated as the primary key is set to NOT NULL because a primary key requires unique and non-null values.
- The syntax for adding a primary key using the ALTER table command is as follows:
ALTER TABLE table_name ADD CONSTRAINT constraint_name PRIMARY KEY (column_name);
- If the field is not set to NOT NULL, the database will throw an error when attempting to add the primary key constraint.
- Ensuring that the field is NOT NULL is a fundamental step before designating it as the primary key to maintain data integrity.
Additional Information
- Primary keys uniquely identify each record in a database table and help establish and enforce entity integrity.
- Besides ensuring that the primary key field is NOT NULL, it is also important that the values in the primary key field are unique to prevent duplicate records.
- The ALTER table command can also be used to add, delete, or modify columns and constraints other than primary keys, providing great flexibility in managing database schemas.
- Database management systems (DBMS) that support the ALTER table command include MySQL, PostgreSQL, SQL Server, Oracle, and many others.
DBMS Question 5:
The criteria for selecting a primary key for a table:
A. It must uniquely identify the row.
B. It cannot have NULL value.
C. It can have NULL value.
D. It can have duplicate values.
E. It never uniquely identifies the row.
Choose the correct answer from the options given below:
Answer (Detailed Solution Below)
DBMS Question 5 Detailed Solution
The correct answer is Option 1.
Key Points
- A primary key is a unique identifier for a row in a database table.
- It must uniquely identify the row (Option A).
- It cannot have NULL value (Option B).
- These criteria ensure that each row can be uniquely identified and referenced, which is essential for maintaining data integrity.
Additional Information
- A primary key's uniqueness constraint ensures that no two rows can have the same primary key value, preventing duplicates.
- Primary keys are typically implemented using unique indexes, which speed up database operations involving key lookups.
- In SQL, you define a primary key using the
PRIMARY KEY
constraint when creating or altering a table. - Primary keys can be single-column or composite (multi-column) keys.
Top DBMS MCQ Objective Questions
In a DBMS, the content and location of data is identified by:
Answer (Detailed Solution Below)
DBMS Question 6 Detailed Solution
Download Solution PDFThe correct option is (2)
Metadata
Key Points
- The Metadata in a Database Management System (DBMS) determines the structure and location of the data.
- If you are unsure of where your DBMS is, you can locate it by going to More Options Open folder DBMS.
- Depending on the initial Desktop version you installed and the version you used to construct the DBMS, the folder may be in a different position.
- Data context, information, storage methods, and numerous relationships between data are all described. A relational DBMS's metadata contains information about constraints, table relationships, data types, columns, tables, and other topics.
Additional Information Sequence data:- Data Sequence. Any data that has elements that are arranged in sequences is referred to as sequential data.
Subdata:- A portion of a database that is used by one particular application only. the database kind. an ordered collection of information.
A collection of interrelated files and a set of programs that allow users to access and modify these files is known as ______________.
Answer (Detailed Solution Below)
DBMS Question 7 Detailed Solution
Download Solution PDFThe correct answer is Database management system.
Key Points
- A Database Management System (DBMS) is software designed to store, modify, and manage data in a database.
- Examples of DBMS are SQL Server, My SQL, Oracle, MS Access, File Maker, Bigtable.
- A database is a data structure that stores organized information.
- The telephone directory is a good example of a database.
Which of the following is NOT an example of DBMS?
Answer (Detailed Solution Below)
DBMS Question 8 Detailed Solution
Download Solution PDFThe correct answer is Microsoft Outlook.
Key Points:
- Microsoft SQL Server is a relational database management system developed by Microsoft.
- MySQL Database Service is a fully managed database service to deploy cloud-native applications.
- Microsoft Outlook is the email service provided by Microsoft.
- Hence this is the answer.
- Microsoft Access is the only application software you need to create apps, utilize databases, and store data in SQL Server and Microsoft Azure SQL.
The _______ is a simple query language used for accessing, handling and managing data in a relational database.
Answer (Detailed Solution Below)
DBMS Question 9 Detailed Solution
Download Solution PDFThe correct answer SQL.
Key Points
- SQL stands for Structured Query Language.
- It is a standardized programming language that's used to manage relational databases and perform various operations on the data in them.
- SQL became the de facto standard programming language for relational databases after they emerged in the late 1970s and early 1980s.
- SQL is regularly used not only by database administrators but also by developers writing data integration scripts and data analysts looking to set up and run analytical queries.
- The uses of SQL include modifying database table and index structures; adding, updating, and deleting rows of data; and retrieving subsets of information from within a database for transaction processing and analytics applications.
Additional Information
- SQL is widely popular because it offers the following advantages -
- Allows users to access data in the relational database management systems.
- Allows users to describe the data.
- Allows users to define the data in a database and manipulate that data.
- Allows embedding within other languages using SQL modules, libraries & pre-compilers.
- Allows users to create and drop databases and tables.
- Allows users to create a view, stored procedure, functions in a database.
- Allows users to set permissions on tables, procedures, and views.
Preet wants to use object-oriented programming language for her application. Which among the following languages should she pick?
Answer (Detailed Solution Below)
DBMS Question 10 Detailed Solution
Download Solution PDFCorrect Answer Java
Key PointsPython:
- A very user-friendly language for beginners that supports multiple programming paradigms, including object-oriented programming (OOP).
- It's commonly used in data analysis, machine learning, web development, and many other fields.
Java:
- One of the most popular object-oriented languages used globally.
- It is widely used in enterprise environments and for building large-scale applications.
C++:
- A highly efficient and flexible language that supports OOP.
- It's typically used for system/software development, game development, and other performance-critical areas.
C#:
- Developed by Microsoft, this language is primarily used for Windows desktop applications and game development (with the Unity engine), but it's versatile enough for just about anything.
JavaScript:
- Though primarily a prototype-based language, JavaScript also supports object-oriented programming.
- It is the main language for web development.
Which is the database management system (DBMS) from Microsoft which is part of the Microsoft Office Suite?
Answer (Detailed Solution Below)
DBMS Question 11 Detailed Solution
Download Solution PDFThe correct answer is MS Access.
Key Points
- MS Access: MS Access is a product of Microsoft Office Suite. MS Access is designed for working as a database management system. MS Access is a combination of a relational database management system and a graphical user interface. MS Access uses its own database engine.
- My SQL: MySQL is a relational database management system. MySQL is available for free and open source. Data in the database can be modified, and edited by running the queries by SQL.
- SQL Server: The SQL Server is responsible for the connectivity, and communication between the elements in the database management system by running the queries.
Thus the correct answer is MS Access.
In MS-DOS, which command displays all the files having the same name but different extensions?
Answer (Detailed Solution Below)
DBMS Question 12 Detailed Solution
Download Solution PDFThe correct answer is Dir filename.*
Key Points
- In MS-DOS, the Dir filename.* command displays all the files having the same name but different extensions.
Additional Information
- * is a wild card character that stands for any character.
- When we specify a filename.* it means that the filename should be the same but the extension can be any.
- Dir filename.ext, this shows the specified file with the specified extension.
- Dir *.sys lists all the files with system extensions.
- Dir *.ext lists all the files with a specified extension.
Which of the following is used to manage Data Base ?
Answer (Detailed Solution Below)
DBMS Question 13 Detailed Solution
Download Solution PDFThe correct answer is DBMS.
Key Points
- A Database is an organized collection of data so that it can be easily accessed and managed.
- DBMS stands for Database Management System.
- A Database Management System (DBMS) is software designed to store, retrieve, define, and manage data in a database.
- Database Management System removes redundancy and Integrity.
- Database Management System reduces Application Development Time.
- DBMS follows the concepts of Atomicity, Consistency, Isolation, and Durability (normally shortened as ACID).
- DBMS supports a multi-user environment and allows them to access and manipulate data in parallel.
- Types of DBMS Systems are:
- Hierarchical Database
- Network Database
- Relational Database
- Object-Oriented Database
- The three-schema architecture of DBMS:
- Some popular DBMS systems:
- MySQL
- Microsoft Access
- Oracle
- LibreOffice Base
- Microsoft SQL Server
Important Points
- In 1960, Charles Bachman designed the first DBMS system.
- In 1970, Codd introduced IBM'S Information Management System (IMS)
- In 1976, Peter Chen coined and defined the Entity-relationship model also know as the ER model.
- In 1991, Microsoft ships MS Access, a personal DBMS and that displaces all other personal DBMS products.
Additional Information
- Operating System
- An operating system acts as an intermediary between the user of a computer and computer hardware.
- Operating systems were first developed in the late 1950s to manage tape storage.
- The General Motors Research Lab implemented the first OS in the early 1950s for their IBM 701.
- Operating System allows disk access and file systems Device drivers Networking Security.
- Operating System Handling I/O operations.
- Operating System has error detection and handling technic.
- An Operating System is concerned with the allocation of resources and services, such as memory, processors, devices, and information.
- The Kernel is the central component of a computer operating system.
- Compiler
- The compiler translates source code written in a high-level language into a set of machine-language.
- Compilers are very large programs, with error-checking and other abilities.
- The object code is machine code that the processor can perform one instruction at a time.
- The first Autocode and compiler in the modern sense were developed by Alick Glennie in 1952.
- John W. Backus at IBM introduced the first commercially available compiler, in 1957.
What is the full form of RPG?
Answer (Detailed Solution Below)
DBMS Question 14 Detailed Solution
Download Solution PDFCorrect Answer Report Program Generator
Key PointsRPG is a high-level programming language:
- Originally developed by IBM in the late 1950s, RPG (Report Program Generator) was designed specifically for business applications and report writing.
RPG has evolved significantly over the years:
- Starting with procedural and simple languages (RPG I and RPG II), it has incorporated more structure and features with RPG III, and has modernized further with RPG IV, also known as RPGLE or ILE RPG.
RPG IV supports modern programming concepts:
- This includes free-format code, subprocedures, and other advanced features, making it more comparable to contemporary programming languages.
RPG is predominantly used in IBM's iSeries systems:
- These systems were previously known as AS/400 systems. RPG remains integral to these systems' operation and the businesses that rely on them.
RPG is considered a legacy language, but is still in use:
- While new business software development often uses languages like Java, Python, C#, JavaScript, etc., a significant amount of software written in RPG is still operational, particularly in industries that have invested heavily in IBM's iSeries systems.
MS-Access database is saved as ______ extension.
Answer (Detailed Solution Below)
DBMS Question 15 Detailed Solution
Download Solution PDF- MS Access is a relational database management system (RDBMS) developed by Microsoft.
- It allows users to create and manage databases using a graphical user interface (GUI) and SQL (Structured Query Language).
- When a database is created or saved in MS Access, it is given the file extension ".mdb" which stands for "Microsoft Database".
- This extension is used to identify the file as an MS-Access database and can be opened and edited using the MS-Access program.
- .msa .dbm .mss are not the extension for MS-Access.