Oracle Application Express 5: Developing Web Applications — Question 17

Ellie has two related interactive grids on a page. Which two steps must she perform to create a master detail relationship between them? (Choose two.)

Answer options

• A. Include a join clause in the SQL Query attribute of the detail interactive grid region.
• B. Enter the name of the foreign key constraint in the Detail Region Foreign Key Relationship attribute.
• C. In the master region, select the correct region for the Detail Region attribute.
• D. Make the master interactive grid region read-only.
• E. Move the detail region below the master region.
• F. In the detail region, select the correct region for the Master Region attribute.
• G. In one of the columns of the detail region, select the related column of the master region for the Master Column attribute.

Correct answer: C, G

Explanation

The correct steps are C and G. Step C is necessary to link the detail region to the correct master region, which is essential for the master-detail relationship. Step G ensures that the detail region references the appropriate column from the master region, establishing the connection. The other options either do not contribute to creating the relationship or are not required steps in this context.