Scribd
Upload
15 views1 page

SQL Exam Paper Set-1

The document outlines the external practical examination details for the Database Management System Lab for B.Tech students in the CSE(AI&ML) department. It includes course outcomes, a set of questions related to ER diagrams, SQL queries, and PL/SQL programming, along with their corresponding marks distribution. The examination is designed to assess students' understanding and application of DBMS concepts and techniques.

Uploaded by

imaman9110
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
15 views1 page

SQL Exam Paper Set-1

The document outlines the external practical examination details for the Database Management System Lab for B.Tech students in the CSE(AI&ML) department. It includes course outcomes, a set of questions related to ER diagrams, SQL queries, and PL/SQL programming, along with their corresponding marks distribution. The examination is designed to assess students' understanding and application of DBMS concepts and techniques.

Uploaded by

imaman9110
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Roll No.

KIET Group of Institutions


External Practical Examination (2025-2026)
ODD Semester

Department: CSE(AI&ML) Course: [Link].


Year: III Semester: V
Subject Name: Database Management System Lab (Set-1) Subject Code: BCS551
Duration: 30 Mins Max. Marks: 15

Note:
Course Outcomes
CO 1 Apply fundamental DBMS concepts, ER modeling techniques, and basic SQL commands to retrieve and manage data using DDL
and DML statements.
CO 2 Apply ER modeling concepts to create relational schemas and formulate queries using relational algebra, relational calculus, and
SQL with appropriate integrity constraints.
CO 3 Apply functional dependencies and normalization techniques to design efficient database schemas while enforcing data constraints
and ensuring data integrity.
CO 4 Execute advanced SQL queries with grouping and subqueries, and analyze transaction management, recovery techniques, and
distributed database concepts.
CO 5 Develop PL/SQL programs using control structures, triggers, and cursors, and evaluate concurrency control, recovery protocols, and
indexing strategies in database systems.

Questions
(5X3=15)
CO BL/ KC*
Q. 1 Draw ER Diagram for the following scenario:

A library maintains information about books, members, authors, and book issues. Each CO2 3/P
book may have multiple authors, and each author can write multiple books. Members
can issue multiple books, but a book can be issued to only one member at a time. The
system must also record issue date, return date, and fine details.
Q. 2 Assumed tables:
 EMP (empno, ename, job, mgr, hiredate, sal, comm, deptno)
 DEPT (deptno, dname, loc)

Use EMP table, DEPT table to answer following queries


CO4 3/P
a. Write an SQL query to display the second highest salary from the EMP table
b. Write an SQL query to list employees who earn more than the average salary of
their respective departments.
c. Write an SQL query to display the highest paid employee(s) in each department.
Q. 3 Write a PL/SQL block that first inserts records in the table Emp. Update the salaries
of Korth and Navathe by Rs 2000 and 1500 respectively, now calculate all the salary
CO5 3/P
in Emp Table, If Salary has been reached more than 10000 in its table, then it is
automatically rolled back, it means undo that was updated earlier by 2000.

● CO - Course Outcome generally refer to traits, knowledge, skill set that a student attains after completing the course successfully.
● Bloom’s Level (BL) - Bloom’s taxonomy framework is planning and designing of assessment of student’s learning.
● # Marks distribution and number of questions up to faculty discretion.
● * Knowledge Categories (KCs): F-Factual, C-Conceptual, P-Procedural, M-Metacognitive
● Reference to Competitive Exams (GATE, GPAT, CAT, GRE, TOFEL, NET, etc.)

You might also like