Search Results ota_test_questions_uk1

Overview

The OTA_TEST_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 functions as a bridge or intersection table, establishing the relationship between test sections, questions, and their parent tests. Its primary role is to store the specific questions that are pre-selected to appear within defined sections of a test. This mapping is critical for tests where the administrator explicitly chooses the questions, as indicated by the test's type_flag being set to 'S' (Pre-Selected). The table is essential for rendering the correct question set during test delivery and for maintaining the structural integrity of predefined assessments.

Key Information Stored

The table's structure is designed to enforce unique relationships through its primary and unique keys. The primary identifier is TEST_QUESTION_ID. The most significant columns for establishing relationships are the foreign keys: TEST_ID links to the parent test in OTA_TESTS, SECTION_ID links to the specific test section in OTA_TEST_SECTIONS, and the combination of QUESTION_BANK_ID and QUESTION_ID uniquely identifies the pre-selected question from the OTA_QUESTIONS table (via the OTA_QUESTION_BANKS table). A unique key constraint (OTA_TEST_QUESTIONS_UK1) on TEST_ID, QUESTION_BANK_ID, and QUESTION_ID ensures a question cannot be assigned to the same test more than once, though it may appear in different tests.

Common Use Cases and Queries

The primary use case is the administration and delivery of pre-selected tests. Common operational and reporting queries involve listing all questions for a specific test or section, or validating test composition. For instance, to retrieve all pre-selected questions for a given test, including their section assignment, a typical SQL pattern would join the relevant tables:

• SELECT ts.name SECTION_NAME, q.question_text FROM ota_test_questions tq, ota_test_sections ts, ota_questions q WHERE tq.test_id = :p_test_id AND tq.section_id = ts.section_id AND tq.question_id = q.question_id ORDER BY ts.sequence, tq.question_id;

Another critical scenario is data validation or migration scripts, where one might check for orphaned records or ensure the type_flag on the parent OTA_TESTS table is consistent with the existence of records in OTA_TEST_QUESTIONS.

Related Objects

OTA_TEST_QUESTIONS is centrally connected to several key tables via foreign key constraints, forming the backbone of the test definition model.

• OTA_TESTS: The master table for test definitions. The type_flag='S' on a record here dictates the use of OTA_TEST_QUESTIONS.
• OTA_TEST_SECTIONS: Stores the sections that organize questions within a test.
• OTA_QUESTIONS and OTA_QUESTION_BANKS: Contain the master question data and their grouping into banks, from which pre-selected questions are drawn.
• Dependent views or APIs, such as those supporting the Learning Management user interface for test authoring and the assessment engine for test delivery, will inherently reference this table to determine the question-set for a pre-selected test.