Question

please answer my question it's very urgent​

Answer 1

Answer:

i) CREATE TABLE "Student" ( "ROLLNO" VARCHAR , "NAME" CHAR (20) , "MARKS1" NUMERIC , "MARKS2" NUMERIC, PRIMARY KEY ( "ROLLNO" ) ) ;

ii) SELECT * FROM "Student" ;

iii) INSERT INTO "Student" ("ROLLNO" , "NAME" , "MARKS1", "MARKS2") VALUES ('5' , 'SNEHA', '55' , '76') ;

iv) DELETE FROM "Student" WHERE "MARKS1" < '30' ;

v) UPDATE "Student" SET "MARKS2" = '79' WHERE "MARKS2">60 ;

PLS MARK BRAINLIEST