Constraints in SQL Quiz with Answers PDF Download – Test 69

MCQ 341: The clause used in SQL for ensuring referential integrity is classified as:

1. PRIMARY KEY clause
2. SECONDARY KEY clause
3. FOREIGN KEY clause
4. INTERVAL KEY clause

MCQ 342: In the functional dependency between two sets of attributes A and B then the set of attributes A of database is classified as:

1. top right side
2. down left side
3. left hand side
4. right hand side

MCQ 343: In unary relational operations, the PROJECT operation is partition of relation usually classified as:

1. horizontal partition
2. vertical partition
3. insert partition
4. delete partition

MCQ 344: The leaf nodes in diagrams of generalization and specialization are considered as:

1. extension classes
2. leaf classes
3. inverted classes
4. diverted classes

MCQ 345: In two-tier client ⁄ server architecture, the functions of transaction server and query server are controlled by:

1. server side
2. host side
3. modulation side
4. client side