KEMBAR78
Dbms Lab Manual Aids | PDF
Scribd
Upload
11 views2 pages

Dbms Lab Manual Aids

The document is a lab manual for a Database Management System course in the Department of Artificial Intelligence and Data Science for the academic year 2025-2026. It covers various SQL commands including DDL, DML, DCL, and TCL, along with topics like SELECT queries, aggregate functions, and PL/SQL. The first experiment focuses on DDL commands, detailing their purpose, procedure, and includes sample output and viva questions.

Uploaded by

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

Dbms Lab Manual Aids

The document is a lab manual for a Database Management System course in the Department of Artificial Intelligence and Data Science for the academic year 2025-2026. It covers various SQL commands including DDL, DML, DCL, and TCL, along with topics like SELECT queries, aggregate functions, and PL/SQL. The first experiment focuses on DDL commands, detailing their purpose, procedure, and includes sample output and viva questions.

Uploaded by

yjas22799
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

DATABASE MANAGEMENT SYSTEM LAB

MANUAL
Department of Artificial Intelligence and Data Science
Academic Year: 2025-2026

Table of Contents
1. 1. DDL Commands – CREATE, ALTER, DROP
2. 2. DML Commands – INSERT, UPDATE, DELETE
3. 3. DCL & TCL Commands – GRANT, REVOKE, COMMIT, ROLLBACK
4. 4. SELECT Queries – WHERE, ORDER BY, GROUP BY
5. 5. Aggregate Functions and Joins
6. 6. Subqueries and Nested Queries
7. 7. Views and Indexes
8. 8. PL/SQL – Procedures, Functions
9. 9. Triggers
10. 10. Mini Project – Student Management / Library DB
Experiment 1: DDL Commands – CREATE, ALTER, DROP

Aim:
To study and implement DDL commands in SQL.

Theory:
DDL (Data Definition Language) commands are used to define and modify database schema.

Procedure / SQL Commands:


 CREATE TABLE Students (ID INT, Name VARCHAR(50), Dept VARCHAR(30));
 ALTER TABLE Students ADD Email VARCHAR(50);
 DROP TABLE Students;

Sample Output:
Table created, column added, and table dropped successfully.

Viva Questions:
11. What is the use of CREATE command?
12. How does ALTER differ from UPDATE?
13. Can you undo a DROP command?

You might also like