Loading

Quipoin Menu

Learn • Practice • Grow

Direction: Choose the correct option

Q1.

Which SQL statement modifies existing records?
A. ALTER
B. MODIFY
C. UPDATE
D. CHANGE
Direction: Choose the correct option

Q2.

UPDATE students SET age = 20;
What will this query do?
A. Update one student
B. Error
C. Update age to 20 for all students
D. Update all students
Direction: Choose the correct option

Q3.

UPDATE products SET price = price * 1.10 WHERE category = 'Electronics';
What does this query do?
A. Increases all prices by 10%
B. Updates category column
C. Increases electronics prices by 10%
D. Decreases electronics prices
Direction: Choose the correct option

Q4.

What happens if you omit the WHERE clause in UPDATE?
A. All rows updated
B. No rows updated
C. Error occurs
D. First row updated
Direction: Choose the correct option

Q5.

UPDATE employees SET salary = 50000, department = 'IT' WHERE id = 101;
How many columns are being updated?
A. All columns
B. 3 columns
C. 1 column
D. 2 columns