Search Results ota_questions




Overview
Explore in AI Chat

Overview

The OTA_QUESTIONS table is a core data repository within the Oracle E-Business Suite Learning Management (OTA) module. It serves as the master definition table for all assessment questions, enabling a reusable question bank. Its primary role is to store the fundamental properties and text of a question, independent of any specific test. This design allows a single question definition to be associated with multiple tests and question banks, promoting consistency and reducing data redundancy. The table's structure is engineered to support multiple question types, including hybrid formats, forming the foundation for creating and administering tests, quizzes, and certifications.

Key Information Stored

The table stores the essential metadata that defines a question. The primary key, QUESTION_ID, uniquely identifies each question record. While the full column list is not detailed in the provided metadata, typical columns in such a table would include the QUESTION_TEXT or DESCRIPTION to hold the actual question prompt. It would also store attributes to manage the question type (e.g., Multiple Choice Single Correct, Multiple Choice Multiple Correct, True/False), the scoring method, difficulty level, and status. The table also contains standard Oracle EBS audit columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY to track the lifecycle of each question record.

Common Use Cases and Queries

This table is central to several learning administration and reporting processes. Common use cases include building a centralized question library for test authors, analyzing question usage across assessments, and auditing question history. Administrators often query this table to generate reports or manage data. Sample SQL patterns include listing all active questions of a specific type, finding questions not used in any test, or joining with related tables to see the full context of a test.

  • Listing questions by type: SELECT question_id, question_text FROM ota_questions WHERE question_type = 'MULTIPLE_CHOICE' AND status = 'ACTIVE';
  • Finding questions in a specific question bank: SELECT q.question_text FROM ota_questions q, ota_qbank_questions bq WHERE q.question_id = bq.question_id AND bq.qbank_id = 1001;
  • Auditing question creation: SELECT question_id, created_by, creation_date FROM ota_questions WHERE TRUNC(creation_date) = TRUNC(SYSDATE);

Related Objects

The OTA_QUESTIONS table has defined relationships with several other key tables in the OTA module, as indicated by its foreign key constraints. The OTA_TEST_QUESTIONS table links a question definition to a specific test and defines its order, weight, and other test-specific parameters. The OTA_QBANK_QUESTIONS table associates questions with various question banks for organizational purposes. The OTA_RESPONSE_TYPES table likely holds the valid answer choices (e.g., options A, B, C, D) for each question. Finally, the OTA_UTEST_RESPONSES table stores the actual responses given by users (learners) to specific instances of these questions during test attempts. These relationships illustrate the table's central position in the assessment data model.