Bissoy.com
Doctors Medicines MCQs Q&A

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?

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? Correct Answer With check

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.

Related Questions

Which of the following statements are TRUE about an SQL query? P: An SQL query can contain a HAVING clause even if it does not have a GROUP BY clause Q: An SQL query can contain a HAVING clause only if it has a GROUP BY clause R: All attributes used in the GROUP BY clause must appear in the SELECT clause S: Not all attributes used in the GROUP BY clause need to appear in the SELECT clause
Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
Consider two database relations R and S having 3 tuples in R and 2 tuples in S. what is the maximum number of tuples that could appear in the natural join of R and S?
Which of the following Relational Algebra operations can be used when you want to keep all the tuples of the first relation irrespective of whether or not they have matching tuples in the second relation?
Consider the following statements and choose the correct answer:
1. Sieve cells are present in all groups of plants
2. Transverse position of end walls of sieve tubes is a primitive feature whereas their oblique or inclined position is an advanced condition
3. Restriction of sieve areas on the end wall is a primitive condition whereas their presence on end wall as well as radial wall is an advanced condition
4. The sieve plates with larger sieve pores are advanced
The ___ algorithm scans each index for pointers to tuples that satisfy an individual condition.
If access paths are available on all the conditions of a disjunctive selection, each index is scanned for pointers to tuples that satisfy the individual condition. This is satisfied by
In a _____________ operations do not wait for requests to produce tuples, but instead generate the tuples eagerly.
Consider two relations R1(A, B) with the tuples (1, 5), (3, 7) and R2(A, C) = (1, 7), (4, 9). Assume that R(A, B, C) is the full natural outer join of R1 and R2. Consider the following tuples of the form (A, B, C): a = (1, 5, null), b = (1, null, 7), c = (3, null, 9), d = (4, 7, null), e = (1, 5, 7), f = (3, 7, null), g = (4, null, 9). Which one of the following statements is correct?
A clause beginning with 'notwithstanding anything contained in this Act or in some particular provisions in the Act or in some particular Acts or in any law for the time being in force', is some times appended to a section in the beginning, with a view to give the enacting part of the section in case of conflict, an overriding effect over the provision or Act mentioned in that clause. Such a clause is called: