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.

  • Table: OTA_QUESTIONS 12.1.1

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_QUESTIONS,  object_name:OTA_QUESTIONS,  status:VALID,  product: OTA - Learning Management ,  description: This table contains the question definitions. Questions can be reused in different tests. At present there is support for Five Types of Questions. The data model is designed to support hybrid questions e.g Support Multiple Choice Single Cor ,  implementation_dba_data: OTA.OTA_QUESTIONS , 

  • Table: OTA_QUESTIONS 12.2.2

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_QUESTIONS,  object_name:OTA_QUESTIONS,  status:VALID,  product: OTA - Learning Management ,  description: This table contains the question definitions. Questions can be reused in different tests. At present there is support for Five Types of Questions. The data model is designed to support hybrid questions e.g Support Multiple Choice Single Cor ,  implementation_dba_data: OTA.OTA_QUESTIONS , 

  • Table: OTA_QBANK_QUESTIONS 12.2.2

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_QBANK_QUESTIONS,  object_name:OTA_QBANK_QUESTIONS,  status:VALID,  product: OTA - Learning Management ,  description: This table acts as a bridge table between OTA_QUESTION_BANKS and OTA_QUESTIONS because of the N:N relation that could be specified between the two entities. ,  implementation_dba_data: OTA.OTA_QBANK_QUESTIONS , 

  • Table: OTA_RESPONSE_TYPES 12.2.2

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_RESPONSE_TYPES,  object_name:OTA_RESPONSE_TYPES,  status:VALID,  product: OTA - Learning Management ,  description: This table holds additional details regarding the question. At present there is a 1:1 relation between the OTA_QUESTIONS and OTA_RESPONSE_TYPES. The data model however is designed so that we can support hybrid question types. That functiona ,  implementation_dba_data: OTA.OTA_RESPONSE_TYPES , 

  • Table: OTA_QBANK_QUESTIONS 12.1.1

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_QBANK_QUESTIONS,  object_name:OTA_QBANK_QUESTIONS,  status:VALID,  product: OTA - Learning Management ,  description: This table acts as a bridge table between OTA_QUESTION_BANKS and OTA_QUESTIONS because of the N:N relation that could be specified between the two entities. ,  implementation_dba_data: OTA.OTA_QBANK_QUESTIONS , 

  • Table: OTA_RESPONSE_TYPES 12.1.1

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_RESPONSE_TYPES,  object_name:OTA_RESPONSE_TYPES,  status:VALID,  product: OTA - Learning Management ,  description: This table holds additional details regarding the question. At present there is a 1:1 relation between the OTA_QUESTIONS and OTA_RESPONSE_TYPES. The data model however is designed so that we can support hybrid question types. That functiona ,  implementation_dba_data: OTA.OTA_RESPONSE_TYPES , 

  • Table: OTA_TEST_QUESTIONS 12.2.2

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_TEST_QUESTIONS,  object_name:OTA_TEST_QUESTIONS,  status:VALID,  product: OTA - Learning Management ,  description: This table stores acts as a bridge table between the OTA_TEST_SECTIONS and OTA_QUESTIONS table for test which have a type_flag set to S( Pre Selected)test. This stores which questions will be displayed under which test sections. ,  implementation_dba_data: OTA.OTA_TEST_QUESTIONS , 

  • Table: OTA_TEST_QUESTIONS 12.1.1

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_TEST_QUESTIONS,  object_name:OTA_TEST_QUESTIONS,  status:VALID,  product: OTA - Learning Management ,  description: This table stores acts as a bridge table between the OTA_TEST_SECTIONS and OTA_QUESTIONS table for test which have a type_flag set to S( Pre Selected)test. This stores which questions will be displayed under which test sections. ,  implementation_dba_data: OTA.OTA_TEST_QUESTIONS , 

  • Table: OTA_UTEST_RESPONSES 12.1.1

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_UTEST_RESPONSES,  object_name:OTA_UTEST_RESPONSES,  status:VALID,  product: OTA - Learning Management ,  description: When the test is assembled for the user, each response to all questions are created in this table. The table is updated as per the response by the user. ,  implementation_dba_data: OTA.OTA_UTEST_RESPONSES , 

  • Table: OTA_QUESTION_BANKS 12.1.1

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_QUESTION_BANKS,  object_name:OTA_QUESTION_BANKS,  status:VALID,  product: OTA - Learning Management ,  description: This table acts as a container for the questions so they can be grouped appropriately. A Question Bank can contain one of more questions. Presently we support at 1:N relation between OTA_QUESTION_BANKS and OTA_QUESTIONS but the design is in ,  implementation_dba_data: OTA.OTA_QUESTION_BANKS , 

  • Table: OTA_UTEST_RESPONSES 12.2.2

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_UTEST_RESPONSES,  object_name:OTA_UTEST_RESPONSES,  status:VALID,  product: OTA - Learning Management ,  description: When the test is assembled for the user, each response to all questions are created in this table. The table is updated as per the response by the user. ,  implementation_dba_data: OTA.OTA_UTEST_RESPONSES , 

  • Table: OTA_QUESTION_BANKS 12.2.2

    owner:OTA,  object_type:TABLE,  fnd_design_data:OTA.OTA_QUESTION_BANKS,  object_name:OTA_QUESTION_BANKS,  status:VALID,  product: OTA - Learning Management ,  description: This table acts as a container for the questions so they can be grouped appropriately. A Question Bank can contain one of more questions. Presently we support at 1:N relation between OTA_QUESTION_BANKS and OTA_QUESTIONS but the design is in ,  implementation_dba_data: OTA.OTA_QUESTION_BANKS , 

  • View: OTA_UTEST_QUESTIONS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OTA.OTA_UTEST_QUESTIONS_V,  object_name:OTA_UTEST_QUESTIONS_V,  status:VALID,  product: OTA - Learning Management ,  implementation_dba_data: APPS.OTA_UTEST_QUESTIONS_V , 

  • View: OTA_UTEST_QUESTIONS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OTA.OTA_UTEST_QUESTIONS_V,  object_name:OTA_UTEST_QUESTIONS_V,  status:VALID,  product: OTA - Learning Management ,  implementation_dba_data: APPS.OTA_UTEST_QUESTIONS_V ,