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

Answer 1

a) varchar(15).
b) select *from table (manager);.
c) insert into table (manager) values ('s106', 'sales', "kritika ",Delhi ",);.

your question is incomplete.

Answer 2

a. The suitable data type for the Deptname field will be varchar

b. To display all the records of the table we use the query statement:

Selcet * from Manager;

c. you can enter the given records in the table by executing the following SQL commands:

INSERT INTO Manager VALUES(‘S101’, ‘Sales’, ‘Pranjal Sharma’, ‘Delhi’);

INSERT INTO Manager VALUES(‘HR404’, ‘HR’, ‘Preeti Arora’, ‘Chennai’);

INSERT INTO Manager VALUES(‘P204’, ‘Purchase’, ‘Sukhmen Singh’, ‘Bangalore’);

INSERT INTO Manager VALUES(‘AD990’, ‘Admin’, ‘Sukanya Kumar’, ‘Mumbai’);