Sql View Is Said To Be Updatable That Is Inserts Updates Or #327
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?
This multiple choice question (MCQ) is related to the book/course
gs gs117 Database Management System.
It can also be found in
gs gs117 SQL: Queries, Constraints and Triggers - Views - Quiz No.1.
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
Similar question(s) are as followings:
Online Quizzes of gs117 Database Management System
Indexing and Hashing - Bitmap Indices - Quiz No.1
gs gs117 Database Management System
Online Quizzes
