SELECT and PROJECT Multiple Choice Questions with Answers – 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