Multiple choice technology programming languages

Which two statements are true regarding views?

  1. A subquery that defines a view cannot include the GROUP BY clause

  2. A view is created with the subquery having the DISTINCT keyword can be updated

  3. A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated

  4. A Data Manipulation Language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table
Reveal answer Fill a bubble to check yourself
C,D Correct answer
Explanation

Views using ROWNUM cannot be updated because the row numbers are generated dynamically, preventing direct row identification. Performing DML on a view with all NOT NULL columns from the base table is allowed because it satisfies the constraint integrity rules of the underlying table.

Keep practicing — related questions