Which three areas should be considered when writing update applications? (Choose three.)

Answer(s): A,B,C

How do secondary indexes support real-time data requirements?

Answer(s): C

Which three statements are true about the creation and use of indexes? (Choose three.)

Hash indexes are created in order to allow the Optimizer to choose hash joins.
A Unique Secondary Index entry might not reside on the same AMP as the base table row.
All secondary, hash, and join indexes are stored in subtables, so they require additionalstorage space.
Index subtables are updated each time an indexed column value in the base table isupdated or deleted.

Answer(s): B,C,D