Practical No.
-1
1. Create a database with name”DBMS
name”DBMS-your_college_code”.
your_college_code”.
2. List various Databases available in system with the help of “Show”
command.
3. Select any database with the help of “use” command.
4. Drop database and note down the result.
Practical No.3
1. Student Info(Student ID,Sname,Course_name,City)
Course(C_code,Title,HOD
Course(C_code,Title,HOD).
2. Add two attributes to table Student_Info as “Phone_no”,Email_address”.
3. Reaname attribute Title to Course_name for Table Couse.
Practical No.-4.
1. Write the schema of Student table created in Practical
Practical-3.
2. Drop any table created in Practical-3.
Practical
Practical No.5.
1. Create table Student as follow. Make”Enrollment” attribute as primary
key. Student(Enrollment,Roll_no,Name,Branch,Percentage,DOB)
2. Change Roll_no as unique key.
3.Create following two tables to demonstrate primary key -
foreign key relationship
Author(A_id,Author_name,Number_of_Books)
Book(Book_id,Book_name,ISBN,A_id).
Practical no.7
Q1.insert any three row in table student created in earlier practical.
Q2.demonstrate use of ‘&’operator by inserting 10 records in student
table.
Q3.create new table as ‘Student_copy’having similar schema that of
student table.copy the data student table into student_copy table.
Practical no.8
Q1.update a name of student to ‘jack’ whose rollno is 3.
Q2.delete students record whose percentage is greater than 50%.
Q3.Delete all record of student_copy .
Practical no.9
Q1.Display all students name whose percentage greater than 60%.
Q2.Display all students name who have enrolled in IT branch (use logical
operator).
Practical no.10
Q1.write a sql command to display the name of student whose name has
second character as ‘a’.
Q2.write a sql command to display student details whose dob is 2001 or
2005 .
Q3.write a sql command to display name of employee whose salary is
greater than 5000 and less than 10000(create employee table with
suitable attributes, insert 5 records.
Practical No:-11
Q1.convert a string to uppercase and print length of that string.
Q2.concatenate any two text column from student table.
Q3.calculate square and cube of any integer number.
Q4.print all details of students with roundup value for percentage.
Practical No:-12.
Q1.write SQL command to display current day ,month,year separately.
Q2.write Sql command to calculate your age in term of number of month.
Q3.write a SQL command to print the date for 15 days after today’s date.
Practical No:-13
Q1.count total no of students enrol for IT branch.
Q2.Display student details with highest and lowest percentage.
Q3.Display average percentage of “DBM” course.
Practical No:-14 and 15.
Q1.display student with first class result .
Q2.calculate the average percentage for each department.
Q3.Display Rank wise student details.
Q4.list no of student in each branch sort on branch name.
Practical No-18
Q1.
Q2.
Q3.
Q4.
Practical no:
no:-19 and 20.
Q1.
Q2.
Q3.
Practical 21and22
Q1 Write prg to print odd numbers between 1to100 using while loop.
Q2 Classify the entered alphabet is vowel or consonant using case
statements.
Q3]Using nested for loop print table2,3,4and5.
Q4] Find sum of first 10 natural number.
Practical23 and 24
Q1]
Excute given sample implicit cursor and note down the output.
Q2] declare a cursor and select all student in IF course. also display total
no rows fetched.
Practical 25and 26
Q1.
Q2
Practical 27
Q1
Rohit
Rohit
Q2
Q3
