Constraints in SQL Quiz Questions and Answers PDF - 21

MCQ 101: The constraints that are applied on individual tuples and are verified whenever any tuple is modified or new tuple is inserted are called

1. language based constraints
2. tuple based constraints
3. scale based constraints
4. precision based constraints

MCQ 102: If matching tuples are not found, the kind of OUTER JOIN operation which keeps all the tuples of first and second relation is classified as

1. LEFT OUTER JOIN
2. FULL OUTER JOIN
3. HALF OUTER JOIN
4. DOWNWARD JOIN

MCQ 103: The kind of class whose entities belongs to some other data class is called

1. concrete classes
2. abstract classes
3. leaf node classes
4. template classes

MCQ 104: The storage capacity of computer system is measured in

1. mega bytes
2. kilo bytes
3. tera bytes
4. all of above

MCQ 105: The compiler which pull out the commands written in host programming language from application program is classified as

1. graphic compiler
2. host compiler
3. precompiled
4. interface compiler