Scribd
Upload
28 views2 pages

DQL, DML, DDL Assignments for DBMS

This document contains 15 questions involving DQL, DML, and DDL statements on database tables. The questions retrieve records from tables based on conditions, arrange records in different orders, update record values, add and modify fields, count records by conditions, insert sample data, delete rows and tables, and rename tables. The tables involved are DEPOSIT, BORROW, and STUDENT.

Uploaded by

babi das
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
28 views2 pages

DQL, DML, DDL Assignments for DBMS

This document contains 15 questions involving DQL, DML, and DDL statements on database tables. The questions retrieve records from tables based on conditions, arrange records in different orders, update record values, add and modify fields, count records by conditions, insert sample data, delete rows and tables, and rename tables. The tables involved are DEPOSIT, BORROW, and STUDENT.

Uploaded by

babi das
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

DATABASE MANAGEMENT SYSTEM LAB

ASSIGNMENT – 2 BASED ON DQL,DML,DDL STATEMENTS

1. Retrieve all the records from DEPOSIT(roll number) where amount > 1000 and arrange the customer
name in ascending order(ques1) and in descending order(ques2)
2. Retrieve customer details from BORROW(roll number) table where the third character of the customer
name is either ‘A’ or ‘D’.
3. Retrieve all the records from the table BORROW(roll number) where amount is not between 2000
and 8000.
4. Find out the unique records from the table DEPOSIT(roll number).
5. Update the amount of all depositors in deposit table by giving them 10% interest (i.e. amount=amount
* 0.1) where branch is VRCE.
6. Update the amount of all depositors in deposit table by giving them 10% interest where branch is VRCE
and customer name ANIL.
7. Create table STUIDENT and insert the following data :-

FIELD DATA TYPE NAME ROLLNO BRANCH CITY


NAME VARCHAR(20) VIJAYA 150 CSE CHENNAI
ROLLNO NUMBER(10) SITA 202 ETC KOLKATA
BRANCH VARCHAR2(20) RAVI 300 EEE DELHI
CITY VARCHAR2(20) BASU 165 ETC CHENNAI
RASMI 107 ETC RKL
KARAN 111 CSE CTC
REKHA 117 BME BBSR

8. Count the number of students of each department.


9. Count the number of students of each department where the department name starts with ‘E’.
10. Add a field called MARKS to the table STUDENT which can hold a number upto 8 digit length.
11. Modify the field :”NAME” of the table STUDENT to hold a maximum of 25 character.
12. Delete all rows from the table STUDENT where branch is ETC.
13. Rename the table STUDENT to STUDINFORMATION.
14. Delete all the data part from the table STUDENT.
15. Destroy the table STUDENT.

PREPARED BY: SOMA GUPTA Page 1


DATABASE MANAGEMENT SYSTEM LAB

PREPARED BY: SOMA GUPTA Page 2

You might also like