Microsoft
DP-900 · Question #164
You need to modify a view in a relational database by adding a new column. Which statement should you use?
The correct answer is B. ALTER. To add a column in a view Alter. https://docs.microsoft.com/en-us/sql/relational-databases/tables/add-columns-to-a-table- database-engine?view=sql-server-ver15 Insert adds one or more rows to a table…
Submitted by ravi_2018· Mar 30, 2026Identify considerations for relational data on Azure
Question
You need to modify a view in a relational database by adding a new column. Which statement should you use?
Options
- AMERGE
- BALTER
- CINSERT
- DUPDATE
How the community answered
(16 responses)- B94% (15)
- D6% (1)
Explanation
To add a column in a view Alter. https://docs.microsoft.com/en-us/sql/relational-databases/tables/add-columns-to-a-table- database-engine?view=sql-server-ver15 Insert adds one or more rows to a table. https://docs.microsoft.com/en-us/sql/t-sql/statements/insert-transact-sql?view=sql-server-ver15
Topics
#DDL#ALTER statement#views#relational database
Community Discussion
No community discussion yet for this question.