MS SQL Server - 29 - Insert Update Delete MCQ

29 – Insert Update Delete MCQ

Best of luck!

1 / 26

1. What SQL statement is used to insert a single row into a table in SQL Server?

INSERT ROW

ADD ROW

INSERT INTO

CREATE ROW

2 / 26

2. To insert multiple rows into a table in SQL Server, which keyword is used?

INSERT ALL

BULK INSERT

MULTIINSERT

INSERT

3 / 26

3. What is the purpose of the VALUES clause in an INSERT statement in SQL Server?

To define the conditions for inserting data

To specify the columns to insert data into

To create a new table

To provide the values to be inserted into the table

4 / 26

4. In SQL Server, how can you insert data into specific columns of a table using an INSERT statement?

By specifying the column names in the VALUES clause

By using the WHERE clause

By using the INTO clause

By using the SET clause

5 / 26

5. Which SQL statement is used to update existing records in a table in SQL Server?

MODIFY

CHANGE

UPDATE

ALTER

6 / 26

6. What happens if you don’t specify a WHERE clause in an UPDATE statement in SQL Server?

All records in the table are updated.

The first record in the table is updated.

An error is thrown.

No records are updated.

7 / 26

7. What is the purpose of the SET clause in an UPDATE statement in SQL Server?

To define the conditions for updating data

To specify the columns to be updated

To create a new table

To provide the values to be updated

8 / 26

8. In SQL Server, which keyword is used to delete records from a table?

REMOVE

DELETE

TRUNCATE

ERASE

9 / 26

9. To delete all records from a table and free the space in SQL Server, which statement is used?

DELETE ALL

TRUNCATE TABLE

ERASE TABLE

DROP TABLE

10 / 26

10. What is the purpose of the WHERE clause in a DELETE statement in SQL Server?

To specify the columns to delete data from

To provide the values to be deleted

To define the conditions for deleting data

To create a new table

11 / 26

11. Which SQL statement is used to insert multiple rows into a table in SQL Server?

INSERT BULK

INSERT VALUES

INSERT ALL

INSERT INTO

12 / 26

12. What is the purpose of the INSERT INTO statement in SQL Server?

To create a new table and insert data into it

To insert data into a temporary table

To update existing records

To insert data into an existing table

13 / 26

13. In SQL Server, what is the primary use of the OUTPUT clause in an INSERT statement?

To create a new table

To specify the data source

To specify the target table

To retrieve the inserted values

14 / 26

14. In SQL Server, which statement is used to insert data into a table based on the result of a SELECT statement?

INSERT INTO

INSERT FROM

INSERT SELECT

INSERT VALUES

15 / 26

15. What is the purpose of the RETURNING clause in an INSERT statement in SQL Server?

To specify the data source

To create a new table

To retrieve the inserted values

To specify the target table

16 / 26

16. In SQL Server, which clause is used to specify the values to be inserted in an INSERT statement?

INTO

INSERT INTO

INSERT VALUES

VALUES

17 / 26

17. To insert data into a table using a subquery in SQL Server, which keyword is commonly used?

SELECT

VALUES

INSERT

JOIN

18 / 26

18. What is the primary purpose of the TOP clause in an INSERT statement in SQL Server?

To create a new table

To join multiple tables

To filter the inserted data

To specify the number of rows to insert

19 / 26

19. In SQL Server, what is the primary purpose of the OUTPUT clause in an UPDATE statement?

To specify the target table

To create a new table

To specify the data source

To retrieve the updated values

20 / 26

20. What is the result of a DELETE statement without a WHERE clause in SQL Server?

No records are deleted.

The first record in the table is deleted.

All records in the table are deleted.

An error is thrown.

21 / 26

21. In SQL Server, what is the purpose of the DELETE TOP (n) statement?

To delete the last n records from a table

To delete the first n records from a table

To delete a random set of records from a table

To delete all records from a table

22 / 26

22. In SQL Server, what is the primary purpose of the TRUNCATE TABLE statement?

To delete specific rows from a table

To delete columns from a table

To create a new table

To delete all rows from a table

23 / 26

23. Which SQL statement is used to remove a table and its data from the database in SQL Server?

REMOVE TABLE

DELETE TABLE

DROP TABLE

ERASE TABLE

24 / 26

24. In SQL Server, what is the primary use of the OUTPUT clause in a MERGE statement?

To specify the data source

To create a new table

To specify the target table

To retrieve the inserted, updated, or deleted values

25 / 26

25. What is the primary difference between the MERGE statement and the UPDATE statement in SQL Server?

MERGE can insert new rows, while UPDATE can only update existing rows.

MERGE requires the use of a WHERE clause, while UPDATE does not.

MERGE is faster than UPDATE.

MERGE can only update rows, while UPDATE can insert new rows.

26 / 26

26. In SQL Server, what is the primary purpose of the OUTPUT clause in an INSERT SELECT statement?

To create a new table

To specify the data source

To specify the target table

To retrieve the inserted values

Your score is

MS SQL Server – 29 – Insert Update Delete MCQ