MCQs
Total Questions : 6
Answer: Option B. -> View
ViewAny such relation that is not part of the logical model, but is made visible to a
user as a virtual relation, is called a view.
Answer: Option A. -> Will affect the relation from which it is defined
Will affect the relation from which it is defined
Answer: Option D. -> All of the mentioned
All of the mentionedAll of the conditions must be satisfied to update the view in sql.
Answer: Option B. -> Create query expression" as view;
Create view v as "query expression;is any legal query expression. The view name is represented by v
Answer: Option B. -> View definition is kept up-to-date
View definition is kept up-to-date
Answer: Option C. -> With check
With checkViews can be defined with a with check option clause at the end of the view definition; then, if a tuple inserted into the view does not satisfy the view's where clause condition, the insertion is rejected by the database system.