SELECT and PROJECT Multiple Choice Questions with Answers – PDF Download

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

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

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

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

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