DBMS Question Bank
● Module 1 5 MARKS
1. Explain DBMS architecture with diagram
2. Write a short note on responsibilities of DBA.
3. Describe the concept of data Abstraction in detail.
4. Describe the concept of data Independence in detail.
5. List and explain all the components of ER-Model
6. Explain the steps to convert Entity Relational Model to Tables.
7. Provide Example and Scenarios where using a database system would
be advantageous over a file system and vice versa
8. Describe how the characteristics of databases (such as scalability, data
integrity, and concurrency control) would benefit the company
compared to using traditional file systems."
9. Explain Data Independence at Logical and Physical level.
10.Explain Data abstraction at all three levels
11.Compare and contrast the concepts of one-to-one, one-to-many, and
many-to-many relationships in the context of the Entity Relationship
Model. Provide examples of each.
12.Design an E-R diagram for a library management system. Include
entities like books, borrowers, and authors, and define relationships
such as borrowing and writing.
13.Create an E-R diagram for an online shopping system. Define entities
such as customers, products, and orders, and establish relationships
like purchasing and reviewing.
14.Design a relational schema for the ER Diagram of Railway
Management System.
● Module 2
15.Explain Selection Operation, Projection Operation with Example
16.Why is Selection Operation, Projection Operation used in relational
Algebra explain it with suitable examples.
17.Explain Union Operation, Intersection Operation with Example.
18.Why is Union Operation, Intersection Operation used in relational
Algebra explain it with suitable example.
19.Explain Cartesian Operation, Join Operation With Example.
20.Why is Cartesian Operation, Set difference Operation used in
relational Algebra explain it with suitable examples.
21.Suppose there is a banking database which comprises following tables
Customer(Cust_name, Cust_street, Cust_city)
Branch(Branch_name, Branch_city, Assets)Account (Branch_name,
Account_number, Balance)
Loan(Branch_name, Loan_number, Amount)
Depositor(Cust_name, Account_number)
Borrower(Cust_name, Loan_number)
Question - Find the names of all the customers who have taken a loan
from the bank and also have an account at the bank.
22.Consider the following schema
Employee
(fname,minit,Iname,SSN,bdate,address,sex,salary,superSSN,DNO)
Department(dname,dnumber,mgrSSN,mgrStartDate)
Department_loc(dnumber,dlocation)
Project(pname,pnumber,ploction,dnum)
Works_on(ESSN,pno,hours)
Dependent(ESSN,dep_name,sex,bdate,relationship)
Question - Find the fname and lname of all employees that earn >
50000
23.Consider the following schema
Employee
(fname,minit,Iname,SSN,bdate,address,sex,salary,superSSN,DNO)
Department(dname,dnumber,mgrSSN,mgrStartDate)
Department_loc(dnumber,dlocation)
Project(pname,pnumber,ploction,dnum)
Works_on(ESSN,pno,hours)
Dependent(ESSN,dep_name,sex,bdate,relationship)
Question - Find the fname and lname of employees in department 4
that earn > 50000
24.Consider the following schema
Employee
(fname,minit,Iname,SSN,bdate,address,sex,salary,superSSN,DNO)
Department(dname,dnumber,mgrSSN,mgrStartDate)
Department_loc(dnumber,dlocation)
Project(pname,pnumber,ploction,dnum)
Works_on(ESSN,pno,hours)
Dependent(ESSN,dep_name,sex,bdate,relationship)
Question - Find project name for all projects worked on by John Smith
25.Consider a relational database schema consisting of 4 relational
schema
Passenger (pid,pname,pgender,pcity)
Agency (aid,aname,acity)
Flight (fid,fdate,time,src,dest)
Booking (pid,aid,fid,fdate)
Question - Get details about all flights from Chennai to New Delhi
26.Given a relation Employee(EmpID, Name, Dept, Gender, Salary), write
relational algebra expressions to: 1) Find all employees in the 'HR' and
'Finance' departement, 2) Find Emplyees whose salary is greater than
50000 , 3) Display only the employee names and their department, 4)
Find the names of employees who work in IT department and their
salary is greater than 95000, 5) Display all Female emplyees who
works in IT department.
27.Given a relation Movie(MID, Title, Genre, Year), Write following relation
algebra expressions to: 1) Find the names of movies released in 2005,
2) Find the names and Year of Comedy movies, 3) Display all the
information of Horror movies released in 2020, 4) Rename the relation
name and attributes, 5) List names of Action movies and rename it as
'ActionMovies'
● Module 3
28.What are set operations in SQL, and which commands are used to
perform them?
29.Explain all the Data Definition Commands with examples.
30.What are aggregate functions in SQL, and what is their primary
purpose? Explain with examples
31.Explain all the Data Manipulation Language Commands with examples.
32.Explain all the Data Control Commands with examples.
33.List all Aggregate function and Set operations and construct there
examples.
34.How does the ALTER TABLE command modify an existing table
structure? Provide an example of adding a new column to a table.
35.Explain the difference between DROP TABLE and TRUNCATE TABLE.
What are the consequences of using each command?
36.How does the UPDATE command work in SQL, and what precautions
should be taken to avoid unintended modifications? Provide an
example of updating specific rows in a table.
37.Explain the difference between IS NULL and IS NOT NULL. Provide
examples of SQL queries using these operators.
38.Explain the GRANT command in SQL. How is it used to provide
permissions to users or roles? Provide an example of granting
SELECT and INSERT permissions.
39.Construct an example for each Aggregate function.
1. List the types of DBMS Architecture
2. List the characteristics of database management
system.
3. What are the three levels of Three tier Architecture
4. What is an attribute?
5. List 3 components of ER-Model
6. What is a ternary relationship?
7. List types of Relationship.
8. List the steps required to convert ER-diagram into table
9. Explain working of Two Tier Architecture in short.
10.Explain working of One Tier Architecture in short.
11.What is ER-Model?
12."In E-R notations relationship reprinted as
Option A:eclipse
Option B:diamond
Option C:triangle
Option D:circle"
13.What is Data Abstraction?
14.What is attributes? Give one example.
15.What are the steps needed to convert ER-diagram into
table
16.List any 3 types of operations in Relational Algebra.
17.What is the symbol for Selection and Projection
operations ?
18.What is the symbol for Union operations ?
19.What is the symbol for Intersection operations ?
20.What is the symbol for Join operations ?
21.What is the symbol for Set difference operations ?
22.What is the work of Projection operation.
23.What is the work of Selection operation.
24.What is the work of Union operation.
25.What is the work of Intersection operation.
26.What is the work of Join operation.
27.What is the work of Difference operation.
28.Name two widely recognized SQL standards
29.Name the basic set operations supported in SQL
30.List Data manipulation commands
31.What is the significance of NULL values in databases?
32.What is the purpose of the GROUP BY clause in SQL
queries.
33.What are nested queries?
34.Explain any two Data defination commands
35.What is set operations
36.Differentiate between data manipulation language
(DML) and data definition language (DDL) commands
in SQL.
37.What are data control commands in SQL.
38.Provide a scenario where you would use GROUP BY to
retrieve summarised data from a database table.
39.what is Recursive Queries?
40.State the significance of check constraint in SQL.