pls someone explain me these questions of dbms
Attachments:
Answers
Answered by
0
You haven't put the table name so i am taking it as Company
(i) SELECT*from COMPANY;
(ii)SELECT*from COMPANY where Gender='Male';
(iii)SELECT*from COMPANY order by "DOJ" ASC;
(iv)SELECT*from COMPANY Wno>1004;
(v)I don't know
(vi)INSERT INTO "COMPANY";
(vii)DELETE from "COMPANY" where Gender=Female;
(viii)UPDATE "COMPANY" set "Dcode"=D03,"Wno"=1008 where "Worker's name"=Anil Jha;
(ix)First field could be set as primary key because if we click yes it would automatically be set as primary key
(x) SELECT*from "COMPANY" where Worker's name=Mohitesh
(i) SELECT*from COMPANY;
(ii)SELECT*from COMPANY where Gender='Male';
(iii)SELECT*from COMPANY order by "DOJ" ASC;
(iv)SELECT*from COMPANY Wno>1004;
(v)I don't know
(vi)INSERT INTO "COMPANY";
(vii)DELETE from "COMPANY" where Gender=Female;
(viii)UPDATE "COMPANY" set "Dcode"=D03,"Wno"=1008 where "Worker's name"=Anil Jha;
(ix)First field could be set as primary key because if we click yes it would automatically be set as primary key
(x) SELECT*from "COMPANY" where Worker's name=Mohitesh
Similar questions