Microsoft Azure Data Fundamentals — Question 70

You need to modify a view in a relational database by adding a new column.
Which statement should you use?

Answer options

• A. MERGE
• B. ALTER
• C. INSERT
• D. UPDATE

Correct answer: B

Explanation

The correct answer is B, ALTER, as it is specifically designed to modify the structure of database objects, including views. Options A (MERGE) and C (INSERT) are used for different purposes, like merging rows or adding data to a table, while D (UPDATE) is meant for changing existing data, not modifying the structure.