Notes

Bilal Khan (0187CS171049) CSE5th-B
Question - 1
Answer - 1:

create table Employee(Employee_ID NUMBER(20) primary key,Employee_Name VARCHAR(20), Employee_dept VARCHAR(4),Employee_Salary NUMBER(10));

//Table created successfully

insert into Employee(Employee_ID,Employee_Name,Employee_dept,Employee_Salary) values(1,'Arvind Kejriwal','ECE',20000);

insert into Employee(Employee_ID,Employee_Name,Employee_dept,Employee_Salary) values(1,'Harish Chandra','ME',34000);

insert into Employee(Employee_ID,Employee_Name,Employee_dept,Employee_Salary) values(1,'Raja Bhoj','CSE',56000);

select* form Employee where Employee_dept='CSE';

select* from Employee where Employee_name LIKE 'J+';

count(Employee_dept) as count from Employee group by Employee_dept;

//Multiple Rows Date inserted Successfully

Question - 2
Answer - 2:

select* from student NATURAL JOIN result

select* from student LEFT OUTER JOIN result

select* from student RIGHT OUTER JOIN result

select* from student FULL OUTER JOIN result

//Tasks will be performed

Question - 3
Answer - 3:

Trigger points in a database in a process by which when ever any query like INSERT, UPDATE, DELETE is performed it literaaly
trigger action in the Table with respected permission.
It can also through back errors if proper permission is not associated to the user.