Search Results ota_question_banks_pk




Overview
Explore in AI Chat

Overview

The OTA_QUESTION_BANKS table is a core data structure within the Oracle E-Business Suite Learning Management (OTA) module, specifically in releases 12.1.1 and 12.2.2. It functions as a logical container or grouping mechanism for assessment questions. Its primary role is to enable the organization and reusability of questions across different tests, quizzes, and learning evaluations. By storing questions within a bank, administrators can efficiently assemble assessments by drawing from predefined pools of questions, supporting randomized testing and consistent evaluation standards. The table's design establishes a foundational one-to-many relationship with individual question records, centralizing question management within the application.

Key Information Stored

The table's structure is defined by key columns that manage identification, classification, and relationships. The primary identifier is QUESTION_BANK_ID, which is the system-generated primary key (OTA_QUESTION_BANKS_PK). A critical attribute is the NAME column, which holds the descriptive title of the question bank. This name is constrained by a unique key (OTA_QUESTIONS_BANKS_UK1) in combination with the FOLDER_ID. The FOLDER_ID is a foreign key column that links the question bank to a specific learning object folder (OTA_LO_FOLDERS), organizing it within the module's content hierarchy. This relationship ensures question banks are properly categorized and secured within the Learning Management framework.

Common Use Cases and Queries

A primary use case is the administrative setup and reporting of assessment resources. Practitioners query this table to audit available question banks, locate questions for test maintenance, or generate inventory reports. Common SQL patterns include joining with the OTA_QUESTIONS table (via the intermediary OTA_QBANK_QUESTIONS table) to list all questions within a specific bank, or joining with OTA_TEST_QUESTIONS to understand which banks are utilized in active assessments. A typical query to retrieve all question banks within a specific folder would be: SELECT question_bank_id, name FROM ota_question_banks WHERE folder_id = &folder_id ORDER BY name;. For integration or data migration scripts, the unique combination of FOLDER_ID and NAME is often used to identify a specific bank record.

Related Objects

The OTA_QUESTION_BANKS table is central to the assessment data model, with documented relationships to several other key tables. It references the OTA_LO_FOLDERS table via its FOLDER_ID column. More significantly, its primary key (QUESTION_BANK_ID) is referenced as a foreign key by multiple tables, demonstrating its role as a master container:

  • OTA_QBANK_QUESTIONS.QUESTION_BANK_ID: This is the direct association table that implements the 1:N relationship between a question bank and the individual questions (OTA_QUESTIONS) it contains.
  • OTA_SECTION_RULES.QUESTION_BANK_ID: Links question banks to assessment section rules, defining how questions are selected from the bank for a test section.
  • OTA_TEST_QUESTIONS.QUESTION_BANK_ID: Associates a question bank directly with specific questions as they are instantiated within a test, recording the source bank for each question used.
These relationships highlight that OTA_QUESTION_BANKS is a master table for reusable assessment content, integral to test construction and delivery.