Question

Deptno-deptname-name-city
S101-sales-pranjal sharma-Delhi
HR404-HR-Preet 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. Department name char(50)

B. SELECT "Table Name";

C. INSERT INTO "Table Name"

    VALUES ( 'S106', 'Sales', 'Kritika Tuteja', 'Delhi');

NOTE: PLEASE INSERT THE NAME OF THE TABLE INSTEAD OF

"Table Name" WITHOUT QUOTES.

GAURAVg91

Answer 2

Answer:

A. department name char(50)

B. select Table Manager

C. insert into manager(...)