1. Execute DDL commands
Student(regno number,name varchar2,dob date,marks number).

2. Execute DML commands
Library(bid number,title varchar2,author varchar2,publisher varchar2,year_of_pub number, price number)

3. Execute TCL and group functions.
Consider the table employee(empno , empname , dept , salary , doj , branch).

4. Implement Nested Queries:
An Inventory database has the following table.
ITEMS(itemcode, name, price);
PURCHASE(itemcode, qty);

5. Implement join operations in sql.
The company database consists of the tables.
DEPARTMENT(dno,dname,mgrid,mgrjoindate)
EMPLOYEE(empid,name,address,gender,salary,dno)

6. Create views for a particular table the railway reservation system database consists of the following table
TRAIN(Train-No ,Train-Name , Start-place , Destination)
AVAILABALITY(Train-No , class , start-place , Destination , No.of seats)

7. Write a PL/SQL function to find the factorial of the given number using recursion

8. Given the table Employee (empno, name, salary)
Write a cursor in PL/SQL to select the five highest paid employees from the table

9. Given the table customer (cid , name , address)
Write a PL/SQL program which asks customer id , if the user enters invalid id then the exception invalid-id displayed

10. Write a function in PL/SQL to find the total number of movies in total.