Multiple choice technology databases

All DML's are supported by which utility?

  1. Mload

  2. Fload

  3. Bteq

  4. Tpump
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

BTEQ (Basic Teradata Query) is the only utility that supports all DML operations (SELECT, INSERT, UPDATE, DELETE) with full SQL capabilities. MultiLoad and FastLoad are specialized load utilities optimized for high-volume data loading with limited DML support. TPump supports streaming updates but has restricted DML functionality. BTEQ's interactive SQL nature makes it the most comprehensive for complete DML operations.

Keep practicing — related questions