Database management system

1. Which SQL statement is used to create a table?

a) CREATE TABLE b) INSERT INTO c) ALTER TABLE d) DROP TABLE

2. Which SQL statement is used to add new rows to a table?

a) INSERT INTO b) UPDATE c) DELETE d) CREATE

3. Which SQL statement is used to remove rows from a table?

a) DELETE b) DROP c) REMOVE d) TRUNCATE

4. Which SQL statement is used to modify existing data in a table?

a) UPDATE b) ALTER c) MODIFY d) CHANGE

5. Which SQL statement is used to delete a table?

a) DROP TABLE b) DELETE TABLE c) REMOVE TABLE d) TRUNCATE TABLE

6. Which SQL statement is used to add a new column to an existing table?

a) ALTER TABLE b) ADD COLUMN c) MODIFY TABLE d) UPDATE TABLE

7. Which SQL statement is used to remove all rows from a table without deleting the table?

a) TRUNCATE TABLE b) DELETE TABLE c) DROP TABLE d) REMOVE TABLE

8. Which SQL statement is used to change the structure of an existing table?

a) ALTER TABLE b) MODIFY TABLE c) UPDATE TABLE d) CHANGE TABLE

9. Which SQL statement is used to delete a database?

a) DROP DATABASE b) DELETE DATABASE c) REMOVE DATABASE d) TRUNCATE DATABASE

10. Which SQL statement is used to insert multiple rows into a table?

a) INSERT INTO ... VALUES b) INSERT ALL c) INSERT MULTIPLE d) INSERT BULK

11. Which SQL statement is used to delete specific rows from a table?

a) DELETE FROM ... WHERE b) REMOVE FROM ... WHERE c) DROP FROM ... WHERE d) TRUNCATE FROM ... WHERE

12. Which SQL statement is used to update specific rows in a table?

a) UPDATE ... SET ... WHERE b) MODIFY ... SET ... WHERE c) CHANGE ... SET ... WHERE d) ALTER ... SET ... WHERE

13. Which SQL statement is used to create a new database?

a) CREATE DATABASE b) ADD DATABASE c) NEW DATABASE d) MAKE DATABASE

14. Which SQL statement is used to rename a table?

a) ALTER TABLE ... RENAME TO b) RENAME TABLE c) CHANGE TABLE d) MODIFY TABLE

15. Which SQL statement is used to delete a column from a table?

a) ALTER TABLE ... DROP COLUMN b) DELETE COLUMN c) REMOVE COLUMN d) DROP COLUMN

SQL MCQs