DBMS: Selection Operation Notes Questions with Answers PDF Download – Test 91

MCQ 451: In case of A4 search algorithm, if the indexing field is not a key, the strategy can retrieve:

1. Single record
2. Two records
3. Multiple records
4. No records

MCQ 452: The database that allows a system administrator to associate a function with a relation is called:

1. Virtual database
2. Private database
3. Custom database
4. Virtual Private database

MCQ 453: The operation on two relations that matches tuples whose values are same on all attribute names that are common to both relations, is known to be:

1. Cartesian Product operation
2. Intersection operation
3. Join operation
4. Union operation

MCQ 454: The pivot clause by its own doesn't calculate the:

1. Subtotals
2. Attributes
3. All values
4. Subqueries

MCQ 455: When a system has enters an undesirable state, the type of error occurred is called:

1. Logical error
2. System error
3. System crash
4. Application error