Regarding the Secondary Index

General
N/A

Regarding the Secondary Index

Hey,

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).

1 REPLY
Enthusiast

Re: Regarding the Secondary Index

a

c