Open App

IT & Software Exam > IT & Software Notes > MCQ with Answer- Database Management System (DBMS)

MCQ with Answer- Database Management System (DBMS) - IT & Software PDF Download

Q: 2. What are the advantages of using a DBMS?

Ans. Some advantages of using a DBMS include:- Data sharing: DBMS allows multiple users to access and share data simultaneously, ensuring data consistency and reducing data duplication.- Data security: DBMS provides built-in security measures to protect data from unauthorized access and ensure data integrity.- Data integrity: DBMS enforces data integrity constraints, such as primary key and foreign key constraints, to maintain the accuracy and reliability of data.- Data independence: DBMS separates the logical view of data from the physical storage, allowing changes in the database structure without affecting the applications that use the data.- Data consistency: DBMS ensures that data remains consistent and valid by enforcing integrity constraints and providing mechanisms for concurrent access and transaction management.

Q: 3. What are the different types of DBMS models?

Ans. There are several types of DBMS models, including:- Relational model: This model organizes data into tables with rows and columns, where relationships between tables are established using primary and foreign keys.- Hierarchical model: This model represents data in a tree-like structure, where each record has a parent-child relationship.- Network model: This model also represents data with a network-like structure, allowing multiple records to have multiple parent and child relationships.- Object-oriented model: This model organizes data into objects, which can have attributes and methods, providing more flexibility in data representation.- NoSQL model: This model is designed for handling large volumes of unstructured and semi-structured data, providing high scalability and performance.

Q: 5. What are the common database languages used in a DBMS?

Ans. The common database languages used in a DBMS are:- Structured Query Language (SQL): SQL is a standard language used for managing relational databases. It provides syntax and commands for creating, querying, updating, and deleting data in a database.- Data Definition Language (DDL): DDL is a subset of SQL used for defining and managing database objects, such as tables, views, indexes, and constraints.- Data Manipulation Language (DML): DML is another subset of SQL used for manipulating data in a database, including inserting, updating, and deleting records.- Data Control Language (DCL): DCL is used for managing user permissions and access control in a database, allowing DBAs to grant or revoke privileges to users.- Transaction Control Language (TCL): TCL is used for managing database transactions, providing commands to commit or rollback changes made to the data.

Download, print and study this document offline

Please wait while the PDF view is loading

 Page 1


Data Base Management Systems 
(DBMS) 
Study Material (Objective Type questions with Answers) 
Shared by Akhil Arora 
 
 
 
 
 
 
 
 
Powered by 
www.Gr8AmbitionZ.com 
your A to Z competitive exam guide 
Page 2


Data Base Management Systems 
(DBMS) 
Study Material (Objective Type questions with Answers) 
Shared by Akhil Arora 
 
 
 
 
 
 
 
 
Powered by 
www.Gr8AmbitionZ.com 
your A to Z competitive exam guide 
Gr8AmbitionZ.com
Database Objective type questions 
 
Q.1 In the relational modes, cardinality is termed as: 
(A) Number of tuples.    (B) Number of attributes. 
(C) Number of tables.    (D) Number of constraints. 
Ans: A 
Q.2 Relational calculus is a 
(A) Procedural language.   (B) Non- Procedural language. 
(C) Data definition language.   (D) High level language. 
Ans: B 
Q.3 The view of total database content is 
(A) Conceptual view.    (B) Internal view. 
(C) External view.    (D) Physical View. 
Ans: A 
Q.4 Cartesian product in relational algebra is 
(A) a Unary operator.    (B) a Binary operator. 
(C) a Ternary operator.    (D) not defined. 
Ans: B Cartesian product in relational algebra is a binary operator. 
(It requires two operands. e.g., P X Q) 
Q.5 DML is provided for 
(A) Description of logical structure of database. 
(B) Addition of new structures in the database system. 
(C) Manipulation & processing of database. 
(D) Definition of physical structure of database system. 
DMBS Ojbective Type Questions - Akhil Arora
for more materials visit us at www.Gr8AmbitionZ.com
Page 3


Data Base Management Systems 
(DBMS) 
Study Material (Objective Type questions with Answers) 
Shared by Akhil Arora 
 
 
 
 
 
 
 
 
Powered by 
www.Gr8AmbitionZ.com 
your A to Z competitive exam guide 
Gr8AmbitionZ.com
Database Objective type questions 
 
Q.1 In the relational modes, cardinality is termed as: 
(A) Number of tuples.    (B) Number of attributes. 
(C) Number of tables.    (D) Number of constraints. 
Ans: A 
Q.2 Relational calculus is a 
(A) Procedural language.   (B) Non- Procedural language. 
(C) Data definition language.   (D) High level language. 
Ans: B 
Q.3 The view of total database content is 
(A) Conceptual view.    (B) Internal view. 
(C) External view.    (D) Physical View. 
Ans: A 
Q.4 Cartesian product in relational algebra is 
(A) a Unary operator.    (B) a Binary operator. 
(C) a Ternary operator.    (D) not defined. 
Ans: B Cartesian product in relational algebra is a binary operator. 
(It requires two operands. e.g., P X Q) 
Q.5 DML is provided for 
(A) Description of logical structure of database. 
(B) Addition of new structures in the database system. 
(C) Manipulation & processing of database. 
(D) Definition of physical structure of database system. 
DMBS Ojbective Type Questions - Akhil Arora
for more materials visit us at www.Gr8AmbitionZ.com
Gr8AmbitionZ.com
Ans: C DML is provided for manipulation & processing of database. 
(Data stored in the database is processed or manipulated using data manipulation 
language commands as its name) 
Q.6 ‘AS’ clause is used in SQL for 
(A) Selection operation.   (B) Rename operation. 
(C) Join operation.   (D) Projection operation. 
Ans: B ‘AS’ clause is used in SQL for rename operation. 
(e.g., SELECT ENO AS EMPLOYEE_NO FROM EMP) 
Q.7 ODBC stands for 
(A) Object Database Connectivity. 
(B) Oral Database Connectivity. 
(C) Oracle Database Connectivity. 
(D) Open Database Connectivity. 
Ans: D 
Q.8 Architecture of the database can be viewed as 
(A) two levels.    (B) four levels. 
(C) three levels.    (D) one level. 
Ans: C 
Q.9 In a relational model, relations are termed as 
(A) Tuples.   (B) Attributes 
(C) Tables.   (D) Rows. 
Ans:c 
Q.10 The database schema is written in 
(A) HLL    (B) DML 
(C) DDL    (D) DCL 
DMBS Ojbective Type Questions - Akhil Arora
for more materials visit us at www.Gr8AmbitionZ.com
Page 4


Data Base Management Systems 
(DBMS) 
Study Material (Objective Type questions with Answers) 
Shared by Akhil Arora 
 
 
 
 
 
 
 
 
Powered by 
www.Gr8AmbitionZ.com 
your A to Z competitive exam guide 
Gr8AmbitionZ.com
Database Objective type questions 
 
Q.1 In the relational modes, cardinality is termed as: 
(A) Number of tuples.    (B) Number of attributes. 
(C) Number of tables.    (D) Number of constraints. 
Ans: A 
Q.2 Relational calculus is a 
(A) Procedural language.   (B) Non- Procedural language. 
(C) Data definition language.   (D) High level language. 
Ans: B 
Q.3 The view of total database content is 
(A) Conceptual view.    (B) Internal view. 
(C) External view.    (D) Physical View. 
Ans: A 
Q.4 Cartesian product in relational algebra is 
(A) a Unary operator.    (B) a Binary operator. 
(C) a Ternary operator.    (D) not defined. 
Ans: B Cartesian product in relational algebra is a binary operator. 
(It requires two operands. e.g., P X Q) 
Q.5 DML is provided for 
(A) Description of logical structure of database. 
(B) Addition of new structures in the database system. 
(C) Manipulation & processing of database. 
(D) Definition of physical structure of database system. 
DMBS Ojbective Type Questions - Akhil Arora
for more materials visit us at www.Gr8AmbitionZ.com
Gr8AmbitionZ.com
Ans: C DML is provided for manipulation & processing of database. 
(Data stored in the database is processed or manipulated using data manipulation 
language commands as its name) 
Q.6 ‘AS’ clause is used in SQL for 
(A) Selection operation.   (B) Rename operation. 
(C) Join operation.   (D) Projection operation. 
Ans: B ‘AS’ clause is used in SQL for rename operation. 
(e.g., SELECT ENO AS EMPLOYEE_NO FROM EMP) 
Q.7 ODBC stands for 
(A) Object Database Connectivity. 
(B) Oral Database Connectivity. 
(C) Oracle Database Connectivity. 
(D) Open Database Connectivity. 
Ans: D 
Q.8 Architecture of the database can be viewed as 
(A) two levels.    (B) four levels. 
(C) three levels.    (D) one level. 
Ans: C 
Q.9 In a relational model, relations are termed as 
(A) Tuples.   (B) Attributes 
(C) Tables.   (D) Rows. 
Ans:c 
Q.10 The database schema is written in 
(A) HLL    (B) DML 
(C) DDL    (D) DCL 
DMBS Ojbective Type Questions - Akhil Arora
for more materials visit us at www.Gr8AmbitionZ.com
Gr8AmbitionZ.com
Ans: C 
Q.11 In the architecture of a database system external level is the 
(A) physical level.  (B) logical level. 
(C) conceptual level  (D) view level. 
Ans: D 
Q.12 An entity set that does not have sufficient attributes to form a primary key is a 
(A) strong entity set.   (B) weak entity set. 
(C) simple entity set.   (D) primary entity set. 
Ans: B 
Q.13 In a Hierarchical model records are organized as 
(A) Graph.    (B) List. 
(C) Links.    (D) Tree. 
Ans: D 
Q.14 In an E-R diagram attributes are represented by 
(A) rectangle.    (B) square. 
(C) ellipse.    (D) triangle. 
Ans: C 
Q.15 In case of entity integrity, the primary key may be 
(A) not Null    (B) Null 
(C) both Null & not Null.   (D) any value. 
Ans: A 
Q.16 In tuple relational calculus P1 ®P2 is equivalent to 
(A) ¬P1 Ú P2   (B) P1 Ú P2 
(C) P1 Ù P2   (D) P1 Ù¬P2 
Ans: A In tuple relational calculus P1  P2 is equivalent to ¬P1 Ú P2. 
DMBS Ojbective Type Questions - Akhil Arora
for more materials visit us at www.Gr8AmbitionZ.com
Page 5


Data Base Management Systems 
(DBMS) 
Study Material (Objective Type questions with Answers) 
Shared by Akhil Arora 
 
 
 
 
 
 
 
 
Powered by 
www.Gr8AmbitionZ.com 
your A to Z competitive exam guide 
Gr8AmbitionZ.com
Database Objective type questions 
 
Q.1 In the relational modes, cardinality is termed as: 
(A) Number of tuples.    (B) Number of attributes. 
(C) Number of tables.    (D) Number of constraints. 
Ans: A 
Q.2 Relational calculus is a 
(A) Procedural language.   (B) Non- Procedural language. 
(C) Data definition language.   (D) High level language. 
Ans: B 
Q.3 The view of total database content is 
(A) Conceptual view.    (B) Internal view. 
(C) External view.    (D) Physical View. 
Ans: A 
Q.4 Cartesian product in relational algebra is 
(A) a Unary operator.    (B) a Binary operator. 
(C) a Ternary operator.    (D) not defined. 
Ans: B Cartesian product in relational algebra is a binary operator. 
(It requires two operands. e.g., P X Q) 
Q.5 DML is provided for 
(A) Description of logical structure of database. 
(B) Addition of new structures in the database system. 
(C) Manipulation & processing of database. 
(D) Definition of physical structure of database system. 
DMBS Ojbective Type Questions - Akhil Arora
for more materials visit us at www.Gr8AmbitionZ.com
Gr8AmbitionZ.com
Ans: C DML is provided for manipulation & processing of database. 
(Data stored in the database is processed or manipulated using data manipulation 
language commands as its name) 
Q.6 ‘AS’ clause is used in SQL for 
(A) Selection operation.   (B) Rename operation. 
(C) Join operation.   (D) Projection operation. 
Ans: B ‘AS’ clause is used in SQL for rename operation. 
(e.g., SELECT ENO AS EMPLOYEE_NO FROM EMP) 
Q.7 ODBC stands for 
(A) Object Database Connectivity. 
(B) Oral Database Connectivity. 
(C) Oracle Database Connectivity. 
(D) Open Database Connectivity. 
Ans: D 
Q.8 Architecture of the database can be viewed as 
(A) two levels.    (B) four levels. 
(C) three levels.    (D) one level. 
Ans: C 
Q.9 In a relational model, relations are termed as 
(A) Tuples.   (B) Attributes 
(C) Tables.   (D) Rows. 
Ans:c 
Q.10 The database schema is written in 
(A) HLL    (B) DML 
(C) DDL    (D) DCL 
DMBS Ojbective Type Questions - Akhil Arora
for more materials visit us at www.Gr8AmbitionZ.com
Gr8AmbitionZ.com
Ans: C 
Q.11 In the architecture of a database system external level is the 
(A) physical level.  (B) logical level. 
(C) conceptual level  (D) view level. 
Ans: D 
Q.12 An entity set that does not have sufficient attributes to form a primary key is a 
(A) strong entity set.   (B) weak entity set. 
(C) simple entity set.   (D) primary entity set. 
Ans: B 
Q.13 In a Hierarchical model records are organized as 
(A) Graph.    (B) List. 
(C) Links.    (D) Tree. 
Ans: D 
Q.14 In an E-R diagram attributes are represented by 
(A) rectangle.    (B) square. 
(C) ellipse.    (D) triangle. 
Ans: C 
Q.15 In case of entity integrity, the primary key may be 
(A) not Null    (B) Null 
(C) both Null & not Null.   (D) any value. 
Ans: A 
Q.16 In tuple relational calculus P1 ®P2 is equivalent to 
(A) ¬P1 Ú P2   (B) P1 Ú P2 
(C) P1 Ù P2   (D) P1 Ù¬P2 
Ans: A In tuple relational calculus P1  P2 is equivalent to ¬P1 Ú P2. 
DMBS Ojbective Type Questions - Akhil Arora
for more materials visit us at www.Gr8AmbitionZ.com
Gr8AmbitionZ.com
(The logical implication expression A  B, meaning if A then B,is equivalent to ¬A Ú B) 
Q.17 The language used in application programs to request data from the DBMS is referred 
to as the 
(A) DML     (B) DDL 
(C) VDL      (D) SDL 
Ans: A 
Q.18 A logical schema 
(A) is the entire database. 
(B) is a standard way of organizing information into accessible parts. 
(C) describes how data is actually stored on disk. 
(D) both (A) and (C) 
Ans: A 
Q.19 Related fields in a database are grouped to form a 
(A) data file. (B) data record. 
(C) menu. (D) bank. 
Ans: B Related data fields in a database are grouped to form a data record. 
(A record is a collection of related fields) 
Q.20 The database environment has all of the following components except: 
(A) users.   (B) separate files. 
(C) database.   (D) database administrator. 
Ans: A 
Q.21 The language which has recently become the defacto standard for interfacing application 
programs with relational database system is 
(A) Oracle.   (B) SQL. 
(C) DBase.   (D) 4GL. 
DMBS Ojbective Type Questions - Akhil Arora
for more materials visit us at www.Gr8AmbitionZ.com

FAQs on MCQ with Answer- Database Management System (DBMS) - IT & Software

1. What is a Database Management System (DBMS)?

Ans. A Database Management System (DBMS) is a software application that allows users to manage, manipulate, and organize data in a database. It provides an interface for users to interact with the database, allowing them to create, retrieve, update, and delete data.

2. What are the advantages of using a DBMS?

Ans. Some advantages of using a DBMS include: - Data sharing: DBMS allows multiple users to access and share data simultaneously, ensuring data consistency and reducing data duplication. - Data security: DBMS provides built-in security measures to protect data from unauthorized access and ensure data integrity. - Data integrity: DBMS enforces data integrity constraints, such as primary key and foreign key constraints, to maintain the accuracy and reliability of data. - Data independence: DBMS separates the logical view of data from the physical storage, allowing changes in the database structure without affecting the applications that use the data. - Data consistency: DBMS ensures that data remains consistent and valid by enforcing integrity constraints and providing mechanisms for concurrent access and transaction management.

3. What are the different types of DBMS models?

Ans. There are several types of DBMS models, including: - Relational model: This model organizes data into tables with rows and columns, where relationships between tables are established using primary and foreign keys. - Hierarchical model: This model represents data in a tree-like structure, where each record has a parent-child relationship. - Network model: This model also represents data with a network-like structure, allowing multiple records to have multiple parent and child relationships. - Object-oriented model: This model organizes data into objects, which can have attributes and methods, providing more flexibility in data representation. - NoSQL model: This model is designed for handling large volumes of unstructured and semi-structured data, providing high scalability and performance.

4. What is the role of a Database Administrator (DBA) in a DBMS?

Ans. A Database Administrator (DBA) is responsible for managing and maintaining the database system. Their role includes tasks such as: - Database design: DBAs design the structure and organization of the database, ensuring efficient storage and retrieval of data. - Security management: DBAs implement security measures to protect the database from unauthorized access, data breaches, and data loss. - Performance tuning: DBAs optimize the performance of the database by monitoring and fine-tuning various parameters, such as indexing, query optimization, and resource allocation. - Backup and recovery: DBAs create backup strategies and implement recovery procedures to ensure data can be restored in case of system failures or data corruption. - User management: DBAs manage user accounts, permissions, and access levels, ensuring that users have appropriate privileges to access and modify the data.

5. What are the common database languages used in a DBMS?

Ans. The common database languages used in a DBMS are: - Structured Query Language (SQL): SQL is a standard language used for managing relational databases. It provides syntax and commands for creating, querying, updating, and deleting data in a database. - Data Definition Language (DDL): DDL is a subset of SQL used for defining and managing database objects, such as tables, views, indexes, and constraints. - Data Manipulation Language (DML): DML is another subset of SQL used for manipulating data in a database, including inserting, updating, and deleting records. - Data Control Language (DCL): DCL is used for managing user permissions and access control in a database, allowing DBAs to grant or revoke privileges to users. - Transaction Control Language (TCL): TCL is used for managing database transactions, providing commands to commit or rollback changes made to the data.

About this Document

4K Views

4.65/5 Rating

Sep 09, 2025 Last updated

Related Exams

IT & Software IT & Software IT & Software

Document Description: MCQ with Answer- Database Management System (DBMS) for IT & Software 2025 is part of IT & Software preparation. The notes and questions for MCQ with Answer- Database Management System (DBMS) have been prepared according to the IT & Software exam syllabus. Information about MCQ with Answer- Database Management System (DBMS) covers topics like and MCQ with Answer- Database Management System (DBMS) Example, for IT & Software 2025 Exam. Find important definitions, questions, notes, meanings, examples, exercises and tests below for MCQ with Answer- Database Management System (DBMS).

Introduction of MCQ with Answer- Database Management System (DBMS) in English is available as part of our IT & Software preparation & MCQ with Answer- Database Management System (DBMS) in Hindi for IT & Software courses. Download more important topics, notes, lectures and mock test series for IT & Software Exam by signing up for free. IT & Software: MCQ with Answer- Database Management System (DBMS) - IT & Software

Description

Full syllabus notes, lecture & questions for MCQ with Answer- Database Management System (DBMS) - IT & Software - IT & Software | Plus excerises question with solution to help you revise complete syllabus | Best notes, free PDF download

Information about MCQ with Answer- Database Management System (DBMS)

In this doc you can find the meaning of MCQ with Answer- Database Management System (DBMS) defined & explained in the simplest way possible. Besides explaining types of MCQ with Answer- Database Management System (DBMS) theory, EduRev gives you an ample number of questions to practice MCQ with Answer- Database Management System (DBMS) tests, examples and also practice IT & Software tests.

Download as PDF

Top Courses for IT & Software

View all courses for IT & Software

video lectures

Previous Year Questions with Solutions

Semester Notes

MCQs

pdf

MCQ with Answer- Database Management System (DBMS) - IT & Software

Sample Paper

Important questions

Viva Questions

Free

Summary

Objective type Questions

ppt

study material

practice quizzes

Extra Questions

MCQ with Answer- Database Management System (DBMS) - IT & Software

mock tests for examination

shortcuts and tricks

MCQ with Answer- Database Management System (DBMS) - IT & Software

past year papers

Exam

;

Additional Information about MCQ with Answer- Database Management System (DBMS) for IT & Software Preparation

MCQ with Answer- Database Management System (DBMS) Free PDF Download

The MCQ with Answer- Database Management System (DBMS) is an invaluable resource that delves deep into the core of the IT & Software exam. These study notes are curated by experts and cover all the essential topics and concepts, making your preparation more efficient and effective. With the help of these notes, you can grasp complex subjects quickly, revise important points easily, and reinforce your understanding of key concepts. The study notes are presented in a concise and easy-to-understand manner, allowing you to optimize your learning process. Whether you're looking for best-recommended books, sample papers, study material, or toppers' notes, this PDF has got you covered. Download the MCQ with Answer- Database Management System (DBMS) now and kickstart your journey towards success in the IT & Software exam.

Importance of MCQ with Answer- Database Management System (DBMS)

The importance of MCQ with Answer- Database Management System (DBMS) cannot be overstated, especially for IT & Software aspirants. This document holds the key to success in the IT & Software exam. It offers a detailed understanding of the concept, providing invaluable insights into the topic. By knowing the concepts well in advance, students can plan their preparation effectively. Utilize this indispensable guide for a well-rounded preparation and achieve your desired results.

MCQ with Answer- Database Management System (DBMS) Notes

MCQ with Answer- Database Management System (DBMS) Notes offer in-depth insights into the specific topic to help you master it with ease. This comprehensive document covers all aspects related to MCQ with Answer- Database Management System (DBMS). It includes detailed information about the exam syllabus, recommended books, and study materials for a well-rounded preparation. Practice papers and question papers enable you to assess your progress effectively. Additionally, the paper analysis provides valuable tips for tackling the exam strategically. Access to Toppers' notes gives you an edge in understanding complex concepts. Whether you're a beginner or aiming for advanced proficiency, MCQ with Answer- Database Management System (DBMS) Notes on EduRev are your ultimate resource for success.

MCQ with Answer- Database Management System (DBMS) IT & Software Questions

The "MCQ with Answer- Database Management System (DBMS) IT & Software Questions" guide is a valuable resource for all aspiring students preparing for the IT & Software exam. It focuses on providing a wide range of practice questions to help students gauge their understanding of the exam topics. These questions cover the entire syllabus, ensuring comprehensive preparation. The guide includes previous years' question papers for students to familiarize themselves with the exam's format and difficulty level. Additionally, it offers subject-specific question banks, allowing students to focus on weak areas and improve their performance.

Study MCQ with Answer- Database Management System (DBMS) on the App

Students of IT & Software can study MCQ with Answer- Database Management System (DBMS) alongwith tests & analysis from the EduRev app, which will help them while preparing for their exam. Apart from the MCQ with Answer- Database Management System (DBMS), students can also utilize the EduRev App for other study materials such as previous year question papers, syllabus, important questions, etc. The EduRev App will make your learning easier as you can access it from anywhere you want. The content of MCQ with Answer- Database Management System (DBMS) is prepared as per the latest IT & Software syllabus.

Education Revolution