SELECT and PROJECT Multiple Choice Questions (MCQ) PDF Download

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

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

MCQ 2: The operators in SELECT operation statement such as 'and' , 'or' and 'not' are classified as

1. Boolean operators
2. tuple operators
3. string operators
4. insertion operators

MCQ 3: The Boolean expression used in the SELECT operation consists of clauses such as

1. attribute name
2. constant value
3. comparison operators
4. all of above

MCQ 4: In unary relational operations, the symbols such as equal to, less than and greater than are classified as

1. tuple operators
2. column operators
3. comparison operators
4. row operators

MCQ 5: The operation which is used to select the subset of tuples by satisfying the selection constraint and the selection is made from relation is classified as

1. CHOOSE operation
2. SELECT operation
3. NON-SELECT operation
4. SUBSET operation