SQL view is said to be updatable (that is, inserts, updates or deletes can be applied on the view) if which of the following conditions are satisfied by the query defining the view? Options: A . &nbspThe from clause has only one database relation. B . &nbspThe query does not have a group by or having clause. C . &nbspThe select clause contains only attribute names of the relation, and does not have any expressions, aggregates, or distinct specification. D . &nbspAll of the mentioned

SQL view is said to be updatable (that is, inserts, updates or deletes can be a

Discussion Forum : Views

Question - SQL view is said to be updatable (that is, inserts, updates or deletes can be applied on the view) if which of the following conditions are satisfied by the query defining the view?

Options:

A . The from clause has only one database relation.

B . The query does not have a group by or having clause.

C . The select clause contains only attribute names of the relation, and does not have any expressions, aggregates, or distinct specification.

D . All of the mentioned

Answer: Option D

All of the mentionedAll of the conditions must be satisfied to update the view in sql.

Was this answer helpful ?

Next Question

Discussion Forum : Views

Submit Your Solution hear: