Multiple choice

An Application was created based on the Employees Personal Information and the Department in which they work. It consists of two blocks. The first one is the Database Data block based on the Employees Personal Information like Name and Address and the other is non database data block based on the Employees Department Information. At runtime, the cursor is initially in the non database data block, the user clicks the Enter Query toolbar button and tries to search the Personal Information record of Employee whose Name is TOM. What would be the result?

  1. Query would execute and the Record providing the Department Information of the Employee matching the criteria would be displayed.

  2. Query would execute and the Record providing the Personal Information of the Employee matching the criteria would be displayed.

  3. Query would not execute as in the Enter query mode user is not allowed to navigate to other block so user can't even provide the search criteria of Employee Name in the Database data block.

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In Enter Query mode, the cursor remains in the current block and navigation to other blocks is restricted. Since the cursor starts in the non-database block, the user cannot navigate to the database block to enter query criteria (Name = TOM), so the query cannot execute.