IBM Informix 12.10 System Administrator - 000-619 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

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

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

Discussion 0

Correct Answer: B Vote an answer

Question 2

Given an OLTP environment with a very large table, which configuration parameter can be set to allocate more memory for sorting when building an index on the large table?

A. DS_NONPDQ_QUERY_MEM B. DS_POOLSIZE C. DBUPSPACE D. VP_MEMORY_CACHE_KB

Discussion 0

Correct Answer: A Vote an answer

Question 3

Which statement is true about log salvaging?

A. Log salvaging allows for recovery of data up to the last available and uncorrupted logical-log file and the last complete transaction. B. Log salvaging is the act of restoring logical logs after physical restore, but before logical restore. C. ontape cannot perform salvage of logs. D. Log salvaging cannot be avoided if onbar is used for restore.

Discussion 0

Correct Answer: A Vote an answer

Question 4

What security role is required for you to create trusted-context objects?

A. DBSSO B. AAO C. DBSA D. DBSECADM

Discussion 0

Correct Answer: D Vote an answer

Question 5

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

A. sqlhosts B. /etc/services C. $ONCONFIG D. /etc/hosts.equiv

Discussion 0

Correct Answer: D Vote an answer

Question 6

Which two parameters are mandatory when running "ifxclone"? (Choose two.)

A. Target server instance size. B. Source server instance sqlhosts. C. Target server configuration parameters. D. Source server instance TCP/IP address. E. Target server instance name.

Discussion 0

Correct Answer: D,E Vote an answer