Multiple choice technology databases

Select the DDL statements suppoerted by Mload

  1. Drop

  2. Create

  3. Alter

  4. Rename
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Teradata MLOAD supports the DROP DDL statement, allowing users to drop tables as part of the MLOAD script. However, MLOAD does not support CREATE, ALTER, or RENAME DDL statements - these must be executed separately outside of MLOAD. MLOAD is optimized for high-volume data loading with limited DDL support, focusing on DELETE and INSERT operations along with DROP for target table management.

Keep practicing — related questions