Q:

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?

mhmadesk

Save to bookmark

|

2022-07-14

|

483

Very Easy

0

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?

The from clause has only one database relation.
The query does not have a group by or having clause.
The select clause contains only attribute names of the relation, and does not have any expressions, aggregates, or distinct specification.
All of the mentioned

Database, MCQ Questions, Database MCQ-questions,

login and add your own answer to this question

All Answers

mhmadesk

2022-07-14

need an explanation for this answer? contact us directly to get an explanation for this answer

(d).All of the mentioned

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)