You need to create a new role for users on stores database. Which system catalog table can be checked to ensure the uniqueness of the new role name?

1. A. stores:sysusers
2. B. sysmaster:sysroles
3. C. sysuser:sysroleauth
4. D. sysmaster:sysusers

Correct Answer: A

Which statement describes the behavior of an Informix instance when the IFX_EXTEND_ROLE configuration parameter is set to ON.

1. A. All users with the EXTEND role can grant it to other users.
2. B. All users with the default role can register external routines.
3. C. All users can create external routines in the database server.
4. D. All users with the EXTEND role can register external routines.

Correct Answer: D

Which objects can be compressed?

1. A. CLOBs
2. B. smart BLOBs
3. C. partition BLOBs
4. D. blobspace BLOBs

Correct Answer: C

"informix_stores" is an established primary server with a SDS server. What is the effect of running the following command? EXECUTE FUNCTION sysadmin:admin("ha sds clear", "informix_stores");

1. A. Shuts down the primary server and converts the secondary server to be the primary.
2. B. Clears the log position of the SDS servers and restarts replication.
3. C. Converts the shared disk secondary server to a standard server and shuts down the primary server.
4. D. Stops replication to the shared disk secondary servers and converts the primary server to a standard server.

Correct Answer: D

Which statement is true about restartable restore?

1. A. ontape can perform restartable restores if a backup is taken to disk.
2. B. Restartable restore is the ability to restart a failed restore using onbar.
3. C. Restartable restore is the ability to restart a failed restore using ontape.
4. D. Restartable restore is the ability to restart an instance using a restore from some other computer.

Correct Answer: B