Question

6. Write the answers based on the following table:
Table: Manger
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:
Deptno Deptname Name City
S101 Sales Pranjal Sharma Delhi
HR404 HR Preeti Arora Chennai
P204 Purchase Sukhmeen Singh Bangalore
AD990 Admin Sukanya Kumar Mumbai
(‘S106’, ‘Sales’, “Kritika Tuteja”, “Delhi”).

Answer 1

where is the table mate