PyQdeck LogoPyQdeckSubjectsSyllabusBlog
Back to the 2021 paper

Unit 2: Relational Query Languages

20212m

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?

  • (i) With
    (ii) Check
    (iii) With check
    (iv) All of the above
Search GoogleAsk AI
Worked SolutionAI Assisted

Answer: (iii) With check

Explanation: WITH CHECK OPTION at end of CREATE VIEW ensures that any INSERT/UPDATE through the view must satisfy the WHERE condition of the view, otherwise rejected. Example: CREATE VIEW v AS SELECT * FROM emp WHERE dept='CS' WITH CHECK OPTION; then INSERT dept='EE' via view fails. "With" alone or "Check" alone incomplete.

Similar questions

DATABASE MANAGEMENT SYSTEMWhich of the following operations is used if we are interested in only certain columns of a table? - (i) PROJECTION (ii) SELECTION (ii) UNION (iv) JOIN20212mDATABASE MANAGEMENT SYSTEMWhich join refers to join records from the right table that have no matching key in the left table and are included in the result set? - (i) Left outer join (i) Right outer join (iii) Full outer join (iv) Half outer join20212mDatabase Management SystemWhich of the following is not an integrity constraint? (i) Not null (ii) Positive (iii) Unique (iv) Check 'predicate'20182mDesign and Analysis of Algorithms Which one of the following statement is correct? (i) If A \le_p B and B \in P then A \in P (ii) If A \le_p B and $A otin P then B otin P$ (iii) If A \le_p B and B \le_p C then A \le_p C (iv) All of these20222m
PreviousTransaction processing is associated with everything below, except - (i) conforming an action or triggering a response (ii) producing detailed summary or exception report (iii) recording a business activity (iv) maintaining a dataNextMany applications use where two independent factors are used to identify a user. - (i) Two-factor authentication (ii) Cross-site request forgery (iii) Cross-site scripting (iv) Cross-site scoring scripting
Free AppAndroid App

Coursify Android App

Generate AI courses, take quick quizzes between classes, and master complex engineering concepts on the go.

Install Coursify