SQL Commands (SELECT, INSERT, UPDATE, DELETE)

1. : Which SQL command is used to retrieve data from a database?
(A) INSERT
(B) UPDATE
(C) SELECT
(D) DELETE

2. : Which SQL command is used to add new records to a table?
(A) UPDATE
(B) INSERT
(C) SELECT
(D) DELETE

3. : Which SQL command is used to remove records from a table?
(A) DROP
(B) DELETE
(C) REMOVE
(D) UPDATE

4. : Which SQL command modifies existing data in a table?
(A) INSERT
(B) SELECT
(C) UPDATE
(D) ALTER

5. : Which SQL clause is commonly used with SELECT to filter rows?
(A) FROM
(B) WHERE
(C) INTO
(D) GROUP

6. : What will the following SQL command do?
DELETE FROM Students WHERE ID = 5;
(A) Delete the entire Students table
(B) Delete the record where ID = 5
(C) Delete all records in the table

7. : Which command is correct to insert a new student with ID=10 and Name=‘Ali’ into the Students table?
(A) INSERT INTO Students (ID, Name) VALUES (10, ‘Ali’);
(B) ADD INTO Students (10, ‘Ali’);
(C) NEW INTO Students VALUES (10, ‘Ali’);
(D) PUT INTO Students VALUES (10, ‘Ali’);

8. : Which SQL statement is correct to update the Name of student with ID=2 to ‘Sara’?
(A) UPDATE Students SET Name = ‘Sara’ WHERE ID = 2;
(B) MODIFY Students Name = ‘Sara’ WHERE ID = 2;
(C) CHANGE Students SET Name = ‘Sara’ WHERE ID = 2;
(D) UPDATE Name = ‘Sara’ IN Students WHERE ID = 2;

9. : Which SQL command will display all records from a table named Employees?
(A) SELECT * FROM Employees;
(B) DISPLAY * FROM Employees;
(C) SHOW ALL Employees;
(D) VIEW * Employees;

10. : Which command deletes all rows from a table but keeps its structure?
(A) DROP TABLE
(B) DELETE FROM table_name
(C) REMOVE TABLE
(D) ERASE ALL