Explanation:All of the conditions must be satisfied to update the view in sql. 7. Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause ?
A. With
B. Check
C. With check
D. All of the mentioned
Answer:A
Explanation:All of the conditions must be satisfied to update the view in sql. 7. Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause ?
A. With B. Check C. With check D. All of the mentioned
Explanation:Views 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. 8. Consider the two relations instructor and department