Relational Operations Multiple Choice Questions (MCQ) PDF - 320

MCQ 1596: Languages based on the relational algebra, add a number of useful syntactic features, such as in

1. JAVA
2. XML
3. SQL
4. DB2

MCQ 1597: Secondary indices improve the performance of

1. Queries without keys
2. Queries without search keys
3. Queries with keys
4. Queries with search keys

MCQ 1598: To extract records from, and add records to the appropriate files to the database system, it needs

1. Different application programs
2. Similar application programs
3. Different application systems
4. Similar application systems

MCQ 1599: The point in the schedule where the transaction obtains its final lock, is called its

1. Shrinking point
2. Growing point
3. Lock point
4. Phase point

MCQ 1600: Implementation of the simple structures at the logical level may involve complex

1. Physical-level structures
2. Logical-level structures
3. View-level Structures
4. Virtual-level Structures