Which two statements are true?
A. Separate temporary dbspaces are required for each buffer pool.
B. DBSPACETEMP dbspaces can be temporary or standard dbspaces.
C. If rootdbs is mirrored then all the temporary spaces must be mirrored.
D. If DBSPACETEMP is not configured then temporary space will never be used.
E. Temporary dbspaces can have different page sizes.
正解:B,E
質問 2:
Which configuration parameter locks the resident and virtual segments of shared memory in operating-system physical memory?
A. RESIDENT
B. INFORMIXSHMLCK
C. SHMSEG
D. SHMBASE
正解:A
質問 3:
When executing the following command: execute function sysadmin task("table compress",
"customer") what will happen to the customer table?
A. Only newly added rows will be compressed.
B. Row data and partition blobs will be compressed and the space allocated to the table will remain.
C. Row data and partition blobs will be compressed and any free table space will be released.
D. Only existing data will be compressed, new data will remain uncompressed.
正解:C
質問 4:
To potentially return unused extent pages to the chunk free list, an Informix administrator would execute which storage optimization operation?
A. Compress
B. Shrink
C. Defragment
D. Repack
正解:B
質問 5:
Which statement about DataBlade modules is true?
A. All DataBlades located in the $INFORMIXDIR/extend are automatically registered.
B. All built-in extensions are automatically registered when the database server is first initialized.
C. All built-in extensions are automatically registered when the extension is first accessed.
D. All built-in extensions are automatically registered each time the database sever is started.
正解:C
質問 6:
Which statement is true for starting Connection Manager?
A. Only user root and informix.
B. Any user of the DBSA group.
C. Only a user of the DBSA group with privilege to connect to the sysadmin database.
D. Any user who is granted privileges to connect to the sysadmin database.
正解:C
質問 7:
The following message is received: Lock table overflow - user id user32, session id 54.
What action should be taken to prevent this problem in the future?
A. Run onclean utility to clear the lock table.
B. Increase the LOCKS configuration parameter.
C. Turn on the AUTO_TUNE configuration parameter.
D. Change the DEF_TABLE_LOCKMODE configuration parameter from page to row.
正解:B
質問 8:
Where must the HA_FOC_ORDER configuration parameter be set?
A. The primary server only.
B. Any server in the cluster.
C. The HDR secondary only.
D. The SDS secondary only.
正解:A