Multiple choice technology mainframe

What is auxillary table.

  1. It contains only numeric data

  2. It contains only character data

  3. It contains data like image, voice and doc’s.

  4. None of these

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Auxiliary tables store large object (LOB) data types - images, audio, video, and documents - separately from the main table. The main table contains pointers/locators to the auxiliary table which holds the actual binary data.

AI explanation

An auxiliary table is used to store content that doesn't fit neatly into ordinary numeric or character columns — things like images, audio clips, and document files (BLOB/CLOB-style data). Because that kind of content is large and unstructured compared to a normal row of numbers or text, it's kept in a separate supporting (auxiliary) table rather than the main relational table. The other options describe ordinary data tables, not the special-purpose role an auxiliary table plays.