C2090-619 Free Practice Test

You are running an UPDATE statement on a table using dbaccess. What kind of lock type is expected?

1. A. Byte
2. B. Update
3. C. Shared
4. D. Exclusive

Correct Answer: D

When free memory is limited, which configuration parameter should be set to allow critical database activities to complete successfully?

1. A. LOW_MEMORY_SVR
2. B. LOW_MEMORY_MGR
3. C. LOW_MEMORY_RESERVE
4. D. LOW_MEMORY_PRESERVE

Correct Answer: C

The Rolling Window clause of the ALTER FRAGMENT MODIFY INTERVAL statement CANNOT define a purging policy on a table that has which two attributes? (Choose two.)

1. A. The table has a ROWID shadow column.
2. B. The table has a Fragment By Range index.
3. C. The table has a Unique Key being used by ER.
4. D. The Fragment Key is defined with multiple columns.
5. E. The Primary Key for the table is referenced by a foreign key constraint.

Correct Answer: AE

Assuming network connectivity between two Informix instances, which file may need additional configuration to allow distributed queries?

1. A. sqlhosts
2. B. /etc/services
3. C. $ONCONFIG
4. D. /etc/hosts.equiv

Correct Answer: D

Which statement is FALSE?

1. A. A new index can be created compressed.
2. B. Attached indexes cannot be compressed.
3. C. A compressed index can be uncompressed.
4. D. A compressed index cannot be uncompressed.

Correct Answer: C