Search Results question_bank_id




Overview
Explore in AI Chat

Overview

The OTA_TEST_QUESTIONS table is a core data object within the Oracle E-Business Suite (EBS) Learning Management (OTA) module, specifically in versions 12.1.1 and 12.2.2. It functions as a bridge or association table, defining the relationship between test sections, questions, and question banks. Its primary role is to store the specific questions that will be presented within defined sections of a test, but only for tests configured with a type_flag of 'S' (Pre-Selected). This table is essential for assembling the precise structure and content of a predefined assessment, ensuring the correct questions are delivered in the intended order during a testing session.

Key Information Stored

The table's columns capture the relationships, ordering, and audit details for test questions. The system-generated surrogate key, TEST_QUESTION_ID, uniquely identifies each record. The foreign keys—TEST_ID, SECTION_ID, QUESTION_ID, and QUESTION_BANK_ID—are critical, as they link this junction record to the parent test, the specific section within that test, the individual question, and the source question bank, respectively. The SEQUENCE column dictates the display order of questions within a section, a feature utilized when the parent test section's display_order_flag is set to 'S'. Standard Oracle EBS columns (OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, etc.) provide audit trails and concurrency control.

Common Use Cases and Queries

A primary use case is generating a report of all questions for a specific test, ordered by section and sequence, which is vital for test validation and review. Another common scenario involves troubleshooting or analyzing the composition of a test section. A sample query leveraging the provided metadata to list questions for a test (ID 1000) would be:

  • SELECT tq.SEQUENCE, q.QUESTION_TEXT
  • FROM ota.ota_test_questions tq,
  • ota.ota_questions q
  • WHERE tq.question_id = q.question_id
  • AND tq.test_id = 1000
  • AND tq.section_id = 5000 -- Optional, for a specific section
  • ORDER BY tq.section_id, tq.sequence;

Developers may also query this table when building integrations or custom logic to manipulate test content programmatically, ensuring any data manipulation respects the unique constraint (OTA_TEST_QUESTIONS_UK1) on TEST_ID, QUESTION_BANK_ID, and QUESTION_ID.

Related Objects

OTA_TEST_QUESTIONS is centrally connected to several key tables in the OTA schema via foreign key relationships, as documented in the provided metadata. These relationships are fundamental to maintaining referential integrity:

  • OTA_TESTS (via TEST_ID): The parent test definition.
  • OTA_TEST_SECTIONS (via SECTION_ID): The specific section within the parent test where the question appears.
  • OTA_QUESTIONS (via QUESTION_ID): The master record containing the question text, type, and answer options.
  • OTA_QUESTION_BANKS (via QUESTION_BANK_ID): The repository or category from which the question is sourced.

These relationships form a complete data model for constructing a pre-selected test, where OTA_TEST_QUESTIONS serves as the critical junction linking these four primary entities.