Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Securing SQL Server Protecting Your Database From Attackers

Authors: Denny Cherry

1st Edition

1597496251, 978-1597496254

More Books

Students also viewed these Databases questions