Database management system

1. What is a view in SQL?

a) A virtual table based on the result of a SQL query b) A physical table stored in the database c) A temporary table created for a session d) A table used for storing metadata

2. Which SQL statement is used to create a view?

a) CREATE VIEW b) CREATE TABLE c) CREATE INDEX d) CREATE DATABASE

3. Which of the following is a DDL statement?

a) SELECT b) INSERT c) CREATE d) UPDATE

4. Which of the following is a DML statement?

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

5. What is the purpose of the INSERT statement in SQL?

a) To update existing records in a table b) To delete records from a table c) To add new records to a table d) To create a new table

6. Which SQL statement is used to delete records from a table?

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

7. What is the purpose of the UPDATE statement in SQL?

a) To add new records to a table b) To modify existing records in a table c) To delete records from a table d) To create a new table

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

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

9. What is the purpose of the JOIN clause in SQL?

a) To combine rows from two or more tables b) To delete rows from a table c) To update rows in a table d) To create a new table

10. Which type of JOIN returns all rows from both tables, even if there is no match?

a) INNER JOIN b) LEFT JOIN c) RIGHT JOIN d) FULL JOIN

11. Which SQL statement is used to remove a table from the database?

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

12. What is the purpose of the TRUNCATE statement in SQL?

a) To delete all rows from a table b) To delete a table from the database c) To modify the structure of a table d) To add new rows to a table

13. Which SQL statement is used to create an index on a table?

a) CREATE INDEX b) CREATE TABLE c) ALTER INDEX d) ADD INDEX

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

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

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

a) DELETE INDEX b) DROP INDEX c) REMOVE INDEX d) ALTER INDEX

SQL MCQs

Your Score: /15