Question

Please answer this question as fast as you can.......
It is really very urgent...

Write the answers based on the following table:

Table: Manger

Deptno - Deptname - Name - City
S101 - Sales - Pranjal Sharma - Delhi
HR404 - HR - Preeti Arora - Chennai
P204 - Purchase - Sukhmeen Singh - Bangalore
AD990 - Admin - Sukanya Kumar - Mumbai

a. Suggest a suitable data type for the Deptname field.
b. Write a query to display all the records of the table.
c. Add a new record with the following details:
(‘S106’, ‘Sales’, “Kritika Tuteja”, “Delhi”).

Answer 1

a . varchar

b. SELECT * FROM Manager;

c .INSERT INTO  Manager (Deptno, Deptname, Name, City)  VALUES  ("S106", "Sales", "Kritika Tuteja", "Delhi");

Answer 2

a)data type for deptname field is varchar

b) select * from manager;

c) insert into manager
values ( ‘S106’, ‘Sales’, “Kritika Tuteja”, “Delhi”)

i hope its help ☆☆ :)