Modifying Data

MCQ - 1

MCQ - 2

MCQ - 3

MCQ - 4

MCQ - 5

Ans : a,b

MCQ - 6

Ans : c

SQL Query - 1

INSERT INTO tutorials VALUE('Learn MySQL','Balachandra Raju','01-09-2021');

SELECT * FROM tutorials;

SQL Query - 2

INSERT INTO Students(Roll_no,std_name,Age) VALUE (7,'Shantnu',21);

SELECT * FROM students;

SQL Query - 3

INSERT INTO BankAccount (Id,Name,cash_balance,Age)

VALUES(1,'Ayush',500,21),(2,NULL,1000,18),(4,'Muthu',NULL,25);

select * from bankaccount;

SQL Query - 4

UPDATE bankaccount SET age =18 WHERE id=2;

UPDATE bankaccount SET cash_balance =2000 WHERE id=4;

select * from bankaccount;

SQL Query - 5

UPDATE stud_data SET fname='Neelabh', Age=22 WHERE roll_no=17;

SELECT * FROM stud_data;

SQL Query - 6 : Part 1

UPDATE Employee SET salary=150000 WHERE position ='SDE' OR position ='CA';

SELECT * FROM Employee;

SQL Query - 6 : Part 2

UPDATE Employee SET salary=salary+10000 WHERE age IN (18,21,65);

SELECT * FROM Employee;

SQL Query - 7

UPDATE Bank SET branch='Noida' WHERE branch IN ('Delhi','Bangalore');

SELECT * FROM Bank;

SQL Query - 8

DELETE FROM products WHERE product_id IN (596,700);

select * from products;

SQL Query - 9

DELETE FROM stud_data WHERE age <=20;

select * from stud_data;

SQL Query - 10

DELETE FROM Employee WHERE name LIKE '%an%' AND salary>100000;

select * from employee;

SQL Query - 11

REPLACE INTO Student(id,name,gender,admission_date)

VALUE(103,"Lawrence",'M','2008-11-27');

SELECT * FROM Student;

SQL Query - 12

REPLACE INTO Insurance (insurance_id,name,insurance_amount,premium_date)

VALUE(305,'Kev',1750000,'2014-09-08');

SELECT * FROM Insurance;

SQL Query - 13

REPLACE INTO cities(id,cname,population)

VALUE(4,'Phoenix',1768980);

SELECT * FROM cities;