Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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, 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started