Free Mock Test : SQL : SQL INSERT & UPDATE (Test 1)

Question : Which SQL statement is used to add new records into a table?

MODIFY

INSERT INTO

UPDATE

ADD

Question : What is the correct syntax for inserting data into specific columns?

INSERT VALUES INTO table_name

INSERT INTO table_name VALUES(column1, column2)

INSERT INTO table_name(column1, column2) VALUES(value1, value2)

ADD INTO table_name VALUES(value1, value2)

Question : Which statement inserts multiple rows correctly?

INSERT INTO employee VALUES (1,'A');
INSERT INTO employee VALUES (2,'B');

INSERT INTO employee
VALUES (1,'A'), (2,'B');

MULTI INSERT employee VALUES (1,'A'), (2,'B');

INSERT MULTIPLE employee VALUES (1,'A'), (2,'B');

Question : What happens if column names are omitted in INSERT statement?

Error always occurs

Values are inserted alphabetically

Values must match all table columns in order

Database ignores missing columns

Question : Which keyword is used to modify existing records?

ALTER

UPDATE

CHANGE

MODIFY

Question : Which clause is commonly used with UPDATE to avoid changing all rows?

ORDER BY

GROUP BY

WHERE

HAVING

Question : What will happen in the following query?

UPDATE employee
SET salary = 50000;

Only one row updates

Error occurs

All rows update

Table gets deleted

Question : Which statement correctly updates a single column?

UPDATE student SET marks = 90 WHERE id = 1;

MODIFY student marks = 90;

CHANGE student SET marks = 90;

ALTER student marks = 90;

Question : Which query updates multiple columns?

UPDATE emp
SET salary = 40000, city = 'Delhi'
WHERE id = 2;

UPDATE emp
SET (salary, city);

MODIFY emp salary, city;

ALTER emp salary = 40000;

Question : SQL UPDATE JOIN is mainly used to:

Delete tables

Combine and update data using another table

Create indexes

Insert records

Question : Which query correctly uses UPDATE JOIN in MySQL?

UPDATE orders o
JOIN customers c
ON o.cust_id = c.id
SET o.city = c.city;

JOIN UPDATE orders customers;

UPDATE JOIN orders;

MODIFY JOIN orders;

Question : Which JOIN type is mostly used with UPDATE JOIN?

INNER JOIN

FULL JOIN

CROSS JOIN

SELF JOIN

Question : Which statement updates date values?

UPDATE employee
SET joining_date = '2025-01-01'
WHERE id = 1;

INSERT DATE employee;

MODIFY DATE employee;

CHANGE DATE employee;

Question : Which format is commonly used for SQL DATE datatype?

DD-MM-YYYY

YYYY-MM-DD

MM-DD-YY

YY/MM/DD

Question : Which function returns current date in MySQL?

TODAY()

GETDATE()

CURRENT_DATE()

DATE()

Question : What is the output purpose of this query?

UPDATE orders
SET order_date = CURRENT_DATE()
WHERE id = 5;

Deletes date

Inserts new table

Updates order date to current date

Creates date column

Question : Which command inserts NULL value?

INSERT INTO student(name, age)
VALUES ('Aman', NULL);

INSERT NULL INTO student;

ADD NULL student;

UPDATE NULL student;

Question : Which keyword is mandatory in UPDATE statement?

VALUES

SET

SELECT

INSERT

Question : Which query increases salary by 10%?

UPDATE emp
SET salary = salary + 10%;

UPDATE emp
SET salary = salary * 1.10;

UPDATE emp
SET salary + 10;

MODIFY emp salary;

Question : Which statement is TRUE about UPDATE?

It creates a new table

It only inserts rows

It modifies existing records

It deletes database

Free Mock Test - SQL : SQL INSERT & UPDATE (Test 1)

Cookies & Disclaimer