READ Free Dumps For IBM- A2090-612
| Question ID 22434 | When defining a foreign key on a table, which statement is true? |
| Option A | It is not mandatory to have an index on the foreign key columns but it can help to avoid locking problems. |
| Option B | There is no need to define an index on the foreign key columns as DB2 cannot use an index for foreign key |
| Option C | It is not mandatory to have an index on the foreign key columns but it can help performance when you insert |
| Option D | You must define an index on the foreign key columns where the index columns are the same as the foreign |
| Correct Answer | A |
| Question ID 22435 | If a ROWID column is defined on a table as GENERATED BY DEFAULT, what must also be done? |
| Option A | Nothing because DB2 will control the values. |
| Option B | A unique index must be defined on the ROWID column. |
| Option C | An identity column must also be created to control uniqueness. |
| Option D | Extra space must be allocated for an overflow area in the table space. |
| Correct Answer | B |