Search Results ota_utest_questions




Overview
Explore in AI Chat

Overview

The OTA_UTEST_QUESTIONS table is a core data object within the Oracle E-Business Suite Learning Management (OTA) module, specifically for versions 12.1.1 and 12.2.2. It serves as the transactional repository for the test definition presented to a specific user during an assessment instance. Whenever a user initiates a test, the system generates a unique test instance, and the precise set of questions that constitute that user's version of the test is stored in this table. It is critical for managing resumable tests, as it preserves the exact question set if a user pauses and later resumes a previous attempt, ensuring test integrity and continuity.

Key Information Stored

The table's primary purpose is to link a specific test attempt to the questions presented. Its key columns, as inferred from the provided metadata, include the primary key USER_TEST_QUESTION_ID, which uniquely identifies each question instance within a user's test. The ATTEMPT_ID is a crucial foreign key column that ties the question set to a specific user test session recorded in the OTA_ATTEMPTS table. Other typical columns in this context, though not explicitly listed in the excerpt, would logically store the question order, a reference to the master question from the question bank (OTA_QUESTIONS), and potentially the points assigned for that question in the context of this specific test instance.

Common Use Cases and Queries

This table is central to reporting on test attempts and analyzing question performance. Common use cases include auditing the exact questions a user was presented, troubleshooting issues with resumable tests, and generating detailed test transcripts. A typical reporting query would join this table to OTA_ATTEMPTS and the master question tables to list all questions for a user's test attempt.

SELECT a.attempt_number, uq.user_test_question_id, q.question_text
FROM ota_utest_questions uq,
     ota_attempts a,
     ota_questions q
WHERE uq.attempt_id = a.attempt_id
AND uq.question_id = q.question_id -- Assumed column relationship
AND a.person_id = :person_id
AND a.test_id = :test_id;

Related Objects

The OTA_UTEST_QUESTIONS table sits at the center of the test attempt data model, with documented foreign key relationships to two primary objects:

  • OTA_ATTEMPTS: This is the parent table for a test session. Each row in OTA_UTEST_QUESTIONS is linked to a specific attempt via the ATTEMPT_ID column. This relationship defines which user's test instance the questions belong to.
  • OTA_UTEST_RESPONSES: This is a critical child table. It stores the user's actual answers for each question presented. The relationship is established through the USER_TEST_QUESTION_ID column in OTA_UTEST_RESPONSES, which references the primary key of OTA_UTEST_QUESTIONS. This creates a one-to-many relationship where one test question instance can have multiple stored responses (e.g., for multiple-choice questions).