I am planning to do TeraData Basic Certifications. I need correct of some questions with reason on secondary Index. Hope I will get help from this forum.
What is a reason to use a USI over a NUSI when creating a table?
a.They ensure data uniqueness.
b.They are a oneAMP operation.
c.They are needed for journaling.
d.They are supported by the batch load utilities.
Why would a USI be chosen instead of a NUSI?
a.It is a single AMP operation.
b.It does not add overhead to the table.
c.It ensures that unique data is inserted into the table.
d.It accesses all AMPs but is more efficient than a Full Table Scan (FTS).