C2090-619 Free Practice Test

Which statement is true for starting Connection Manager?

1. A. Only user root and informix.
2. B. Any user of the DBSA group.
3. C. Any user who is granted privileges to connect to the sysadmin database.
4. D. Only a user of the DBSA group with privilege to connect to the sysadmin database.

Correct Answer: D

Which communication protocol needs additional configuration besides onconfig and sqlhosts?

1. A. TLITCP
2. B. IPCSTR
3. C. IPCSHM
4. D. SOCSSL

Correct Answer: D

Which option is available through ifx_grid_connect()?

1. A. Rename a replicated database.
2. B. Enable use of TimeSeries columns in tables.
3. C. Enable automatic creation of templates in a grid.
4. D. Defer propagation of DDL statements to other servers in the grid.

Correct Answer: D

Which Informix utility can be used to display contents of logical-log files, either from disk or from backup?

1. A. onlog
2. B. onclean
3. C. ondblog
4. D. onspaces

Correct Answer: A

Which configuration parameter can toggle the automatic expansion of storage spaces?

1. A. SP_AUTOGROW
2. B. SP_AUTO_SPACE
3. C. SP_AUTOEXPAND
4. D. SP_EXPAND_ENABLE

Correct Answer: C