IBM C2090-619 問題集

質問 1：
Which type of device does Primary Storage Manager support?
A. Tape
B. File
C. Named pipe
D. Directory
正解：B

質問 2：
"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");
A. Shuts down the primary server and converts the secondary server to be the primary.
B. Stops replication to the shared disk secondary servers and converts the primary server to a standard server.
C. Clears the log position of the SDS servers and restarts replication.
D. Converts the shared disk secondary server to a standard server and shuts down the primary server.
正解：B

質問 3：
Which step must be performed to enable Secure Socket Layer (SSL) connections to
Informix?
A. Configure poll threads for SSL connections in the ONCONFIG file.
B. Specify the SSL connection protocol in the sqlhosts file or registry entry.
C. Specify the name of the label of the server digital certificate in the ONCONFIG file.
D. Configure encrypt virtual processors in the ONCONFIG file.
正解：B

質問 4：
Which statement is FALSE about dbspace configurable page sizes?
A. Dbspace page size can only be set for non-critical dbspaces.
B. Possible page sizes are multiples of the default page size up to 16 kb.
C. Dbspace page size should be configured to accommodate the greatest number of average row sizes with a minimum of remainder pages being used.
D. Configure page sizes as close to the backup / restore and network buffer size as possible for efficient data transfer across the wire.
正解：D

質問 5：
Which statement is FALSE regarding SBSPACES?
A. They are recoverable.
B. Smart large objects within table rows are not required to be retrieved in one statement.
C. They do not obey transaction isolation modes.
D. They have read, write, and seek properties similar to a standard UNIX file.
正解：C

質問 6：
Which two parameters are mandatory when running "ifxclone"? (Choose two.)
A. Source server instance TCP/IP address.
B. Target server configuration parameters.
C. Target server instance name.
D. Source server instance sqlhosts.
E. Target server instance size.
正解：A,C

質問 7：
Which Informix utility is used to print information about runtime statistics for all threads in the server?
A. onstat -g cpu
B. onstat -g sta
C. onstat -g act
D. onstat -g rea
正解：A

質問 8：
An Informix server is configured with multiple CPU VPs and poll threads and is experiencing NSF lock errors. What action should be taken to reduce the network shared file lock contention?
A. Increase the value of NUMFDSERVERS and increase the number of MSC VPs.
B. Increase the value of MAX_INCOMPLETE_CONNECTIONS.
C. Increase the value of NUMFDSERVERS and add more poll threads.
D. Increase the network buffer pool using the IFX_NETBUF_PVTPOOL_SIZE environment variable.
正解：C