Scribd
Upload
28 views1 page

Oracle SQL Practice 1 - DDL & DML

Uploaded by

kumaranmca1521
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 views1 page

Oracle SQL Practice 1 - DDL & DML

Uploaded by

kumaranmca1521
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/ 1

Oracle SQL Practice 1

DDL & DML


1) Create the following tables
a) studentprofile(rollno,name,dob,department,city)
b) marks (rollno,name,mark1,mark2)
2) insert 5 different records to the above tables.
3) add a column total to marks table.
4) change the column name dob to dateofbirth.
5) display the structure of the above tables.
6) List the tables which you have created.
7) Calculate total marks for each student and update in marks table.
8) remove the 4 th rollno from studentprofile table.
9) Display all the records of both the tables.
10) save your changes.
11) add two more columns average and grade to marks table.
12) calculate the average for all the students.
13) Calculate the grade (if both the marks are above 40 then grade should be pass if less
than 40 grade should be fail).
14) Remove the column average .
15) Remove all the records from the table.
16) confirm your changes

You might also like