Discussion Forum

  1. Home
  2. »
  3. Computer Science Mcqs
  4. »
  5. DBMS Mcqs
  6. »
  7. Data Storage and Querying Mcqs
  8. »
  9. SQL view is said to...

Computer MCQS

Sciences MCQS

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

Answer: D . All of the mentioned
0Shares
0 0

If you think the posted answer is wrong or Confused About the Answer? Ask for Details Here

Know Explanation? Add it Here
we’ll review your comment and contact you soon….

Leave a Reply

Your email address will not be published. Required fields are marked *

Computer MCQS

Sciences MCQS

0Shares
0
Scroll to Top