DATABASE MANAGEMENT SYSTEM PRACTICAL SAMPLES
This document contains practical Database Management System (DBMS) sample questions and detailed answers.
The practicals are designed to help students understand how to create, manipulate, test, and secure databases using
SQL and DBMS concepts.
Practical 1: Creating a Database
Question:
Create a database called SchoolDB. SQL Command:
CREATE DATABASE SchoolDB; Explanation:
This command creates a new database named SchoolDB where tables and records can be stored.
Practical 2: Creating a Table
Question:
Create a table named Students with the following fields: StudentID Name Course Age SQL Command:
CREATE TABLE Students ( StudentID INT PRIMARY KEY, Name VARCHAR(50), Course
VARCHAR(50), Age INT ); Explanation:
The CREATE TABLE command is used to define table structure. PRIMARY KEY uniquely identifies each student.
Practical 3: Inserting Data into a Table
Question:
Insert records into the Students table. SQL Command:
INSERT INTO Students (StudentID, Name, Course, Age) VALUES (1, 'John', 'Computer
Science', 20), (2, 'Mary', 'Business IT', 22); Explanation:
The INSERT command adds new records into the table.
Practical 4: Retrieving Data
Question:
Display all records from the Students table. SQL Command:
SELECT * FROM Students; Explanation:
SELECT retrieves data from the database. The asterisk (*) means all columns.
Practical 5: Updating Records
Question:
Update Mary's course to Information Technology. SQL Command:
UPDATE Students SET Course = 'Information Technology' WHERE StudentID = 2; Explanation:
UPDATE modifies existing records in a table.
Practical 6: Deleting Records
Question:
Delete the student with StudentID 1. SQL Command:
DELETE FROM Students WHERE StudentID = 1; Explanation:
