Relational Operations MCQ with Answers PDF Download – Test 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