Question: Choose the correct answer for Emp table( empid , empname, salary, job, country) 1- To delete job attribute from Item table. a. Alter Table Emp

 Choose the correct answer for Emp table( empid , empname, salary,

Choose the correct answer for Emp table( empid , empname, salary, job, country) 1- To delete job attribute from Item table. a. Alter Table Emp delete Attribute job. b. Alter Table Emp drop attribute job. c. Alter Table Emp drop column job. 2 - To create the simple view Vsal for Emp: a. Create View Vsal as Select empid, empname where salary=1200. b. Create Vsal as Select empid, empname from emp where salary=1200 from Emp c. Create View Vsal as Select empid, empname from Emp where salary=1200 a. 3. To increase salary of all employees who are working as Teller a. Update Emp set salary = salary +150 where job= 'Teller'. b. Alter table Emp set salary = salary +150 where job='Teller'. c. Update Emp salary +150 where job='Teller.'. 4. Which is true for Grant statement a. Grant Select, Delete To user_XYZ b. Grant Select, Delete On Emp To user_XYZ c. Grant Select , Delete To Emp On user_XYZ 5. Which is true for set operation Union statements a. Select empid from emp Union where country='Jordan Select empid from emp where country='Iraq'. 6. Select empid from emp where country="Jordan' Union Select empid from emp where country ='Iraq? c. Select Union empid from emp where country='Jordan Select empid from emp where country ='Ira

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!