You cannot modify data in a view if it contains: Group functions such as SUM, MIN, MAX, AVG, … A GROUP BY clause. The DISTINCT keyword. Columns defined by expressions (i.e, SAL * 12). The ROWNUM pseudo column.

Keep practicing — related questions

• We can not modify data in view
• Which statements are true regarding views?
• Which two statements are true regarding views?
• We can not remove a row from view, if it contains
• We can not remove a row from view, if it contains
• One can NOT delete a row from the VIEW if view definition contains ... Choose all that apply
• You can not add data through a view if the view includes:
• We can update the value of the columns that is selected on view list