MS SQL Server - 30 - TRUNCATE MERGE OUTPUT MCQ

30 – TRUNCATE MERGE OUTPUT MCQ

Best of luck!

1 / 25

1. What is the primary purpose of the TRUNCATE TABLE statement in SQL Server?

To delete all rows from a table

To update rows in a table

To insert new rows into a table

To delete specific rows from a table

2 / 25

2. In SQL Server, how does the TRUNCATE TABLE statement differ from the DELETE statement?

TRUNCATE TABLE can be used with a WHERE clause.

DELETE can be used to remove table columns.

TRUNCATE TABLE is faster and does not generate individual row delete statements.

DELETE is faster and does not generate individual row delete statements.

3 / 25

3. Which SQL statement is used to delete specific rows from a table in SQL Server?

REMOVE

TRUNCATE

ERASE

DELETE

4 / 25

4. What is the primary purpose of the MERGE statement in SQL Server?

To update existing rows in a table or insert new rows if they don't exist

To insert new rows into a table

To delete rows from a table

To create a new table

5 / 25

5. In SQL Server, which clause is used to specify the conditions for updating data in a MERGE statement?

WHEN MATCHED

WHEN NOT MATCHED

MATCH

UPDATE

6 / 25

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

The first record in the table is deleted.

All records in the table are deleted.

An error is thrown.

No records are deleted.

7 / 25

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

To delete the last n records from a table

To delete a random set of records from a table

To delete all records from a table

To delete the first n records from a table

8 / 25

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

To specify the data source

To specify the target table

To retrieve the deleted values

To create a new table

9 / 25

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

DELETE TABLE

REMOVE TABLE

ERASE TABLE

DROP TABLE

10 / 25

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

To create a new table

To specify the data source

To retrieve the inserted, updated, or deleted values

To specify the target table

11 / 25

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

MERGE is faster than UPDATE.

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

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

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

12 / 25

12. 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 retrieve the inserted values

To specify the target table

13 / 25

13. What happens if you try to use the TRUNCATE TABLE statement on a table with a foreign key constraint?

The TRUNCATE TABLE statement will fail.

The foreign key constraint is automatically removed.

The table is automatically dropped.

The foreign key constraint is temporarily disabled.

14 / 25

14. In SQL Server, which clause is used to specify the source table(s) in a MERGE statement?

JOIN

USING

FROM

SOURCE

15 / 25

15. What is the primary advantage of using the TRUNCATE TABLE statement over the DELETE statement in SQL Server?

TRUNCATE TABLE can be used with a WHERE clause.

TRUNCATE TABLE is faster and uses less transaction log space.

DELETE allows for the retrieval of deleted values.

DELETE provides better control over which rows to delete.

16 / 25

16. In SQL Server, which statement is used to delete all rows from a table and reset identity columns?

TRUNCATE TABLE

DELETE ALL

DROP TABLE

ERASE TABLE

17 / 25

17. What is the primary use case for the OUTPUT clause in a DELETE statement in SQL Server?

To create a new table

To retrieve the deleted values for auditing purposes

To specify the target table

To specify the data source

18 / 25

18. In SQL Server, which clause is used to specify the target table in a MERGE statement?

TARGET

INTO

19 / 25

19. What is the result of a DELETE statement if the WHERE clause specifies no matching rows?

No rows are deleted.

All rows in the table are deleted.

The first row in the table is deleted.

An error is thrown.

20 / 25

20. In SQL Server, which clause is used to specify the target table in an INSERT SELECT statement with the OUTPUT clause?

INTO

TARGET

21 / 25

21. What is the primary purpose of the OUTPUT INTO clause in SQL Server?

To create a new table

To specify the source table for the merged rows

To specify the target table for the deleted rows

To specify the target table for the updated rows

22 / 25

22. In SQL Server, what is the primary use of the WHEN NOT MATCHED clause in a MERGE statement?

To delete rows that don't match the conditions

To insert rows that don't match the conditions

To update rows that match the conditions

To specify the target table

23 / 25

23. What is the purpose of the OUTPUT clause in a MERGE statement in SQL Server?

To specify the target table

To retrieve the values of columns being modified

To specify the data source

To create a new table

24 / 25

24. In SQL Server, what is the main benefit of using the MERGE statement over separate INSERT, UPDATE, and DELETE statements?

MERGE provides better performance.

MERGE ensures data consistency by combining multiple operations into one statement.

MERGE allows for the retrieval of inserted values.

MERGE can be used with a WHERE clause.

25 / 25

25. Which SQL statement is used to specify the columns to be retrieved in the OUTPUT clause of a DELETE statement in SQL Server?

OUTPUT SELECT

OUTPUT COLUMNS

SELECT

OUTPUT INTO

Your score is

MS SQL Server – 30 – TRUNCATE MERGE OUTPUT MCQ