Scribd
Upload
15 views2 pages

Model Question - 04.04.2025

The document outlines a series of tasks related to database management systems, including the creation and alteration of various tables such as stu_details, mark_details, book, customer, and emp_details. It includes specific operations like adding columns, truncating tables, and writing PL/SQL programs for calculations. Additionally, it requires displaying data based on certain conditions and creating views for data retrieval.

Uploaded by

emailofaditya0
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 views2 pages

Model Question - 04.04.2025

The document outlines a series of tasks related to database management systems, including the creation and alteration of various tables such as stu_details, mark_details, book, customer, and emp_details. It includes specific operations like adding columns, truncating tables, and writing PL/SQL programs for calculations. Additionally, it requires displaying data based on certain conditions and creating views for data retrieval.

Uploaded by

emailofaditya0
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
You are on page 1/ 2

SCHOOL OF COMPUTING SCIENCE AND ENGINEERING (SCOPE)

CSE3001 - DATABASE MANAGEMENT SYSTEMS


04.04.2025
1. Create the following tables with the mapping given below.
a. stu_details (reg_no, stu_name, DOB, address, city)
b. mark_details (reg_no, mark1, mark2, mark3, total)
i. Alter the table mark_details to add a column average with data type as long.
ii. Display the months between the DOB and till date.
iii. Using alter command drop the column address from the table stu_details.
iv. Write a pl/sql program to find the sum &avg marks of all the student using procedures.

2. Create the following tables with the mapping given below.


a. book (book_name,author,price,quantity).
b. customer (Cust_id, Cust_name, Addr, ph_no,pan_no)
i. Truncate the table customer.
ii. List the author of the book which one have the price of 200.
iii. List the price of the book which one is between the price of 175 & 250.
iv. Retrieve all the details from the table book whose author name start with K.
v. Write a pl/sql program to find the largest of two numbers.

3. Create the following tables with the mapping given below.


a. Customer (Cust_id, Cust_name, Addr, ph_no,pan_no)
b. Loan (Loan_id, Amount, Interest, Cust_id)
(i)Display the Cust_name having both Loan and Account .
(ii) Display number of Loans, the sum of Loan Amount of a ParticularCustname(“LEENA”)
(iii)Display the Custname doesn’t hold any Account nor taken any Loan
(iv)Add a column nol(number of loans)

1
4. Create the following tables with the mapping given below.
Phone_book(ph_no,name,door_no,street,place).
(i)List the price of the book which one is between the price of 400 & 500.
(ii)Create an updatable view for the above table.
(iii)Display distinct names.

5. Create the following tables with the mapping given below.


a. emp_details (emp_no, emp_name, DOB, address, doj, mobile_no, dept_no, salary).
b. dept_details (dept_no, dept_name, location).
i. Display the months between the doj and till date.
ii. Alter the table emp_details to add a primary key constraint on emp_no.
iii. Write a pl/sql program to find odd or even number using procedures.

You might also like