Which statement is FALSE about Informix Automatic checkpoint Feature?
A. Automatic checkpoints cause less logical log activity.
B. Automatic checkpoints cause the database server to trigger more frequent checkpoints.
C. Automatic checkpoints can be dynamically enabled or disabled by using onmode -wm or onmode -wf.
D. Automatic checkpoints try to avoid transaction blocking.
正解:A
質問 2:
Which two statements are true about archecker utility? (Choose two.)
A. Archecker can help developers team to debug procedures.
B. Archecker can copy data from different servers, even restoring from a remote device.
C. Archecker can do backup testing, fully integrated with onbar and ontape utilities.
D. Archecker can use all kind of connections protocols, including shared memory connections.
E. Archecker can do data restore (physical or logical) of database portions, table portions, or even a set of tables.
正解:C,E
質問 3:
"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. Clears the log position of the SDS servers and restarts replication.
B. Stops replication to the shared disk secondary servers and converts the primary server to a standard server.
C. Converts the shared disk secondary server to a standard server and shuts down the primary server.
D. Shuts down the primary server and converts the secondary server to be the primary.
正解:B
質問 4:
Which two actions can you perform with ontape? (Choose two.)
A. Parallel backup of storage spaces
B. Restartable restore
C. Restore specific storage spaces
D. Backup to cloud
E. Backup specific storage spaces
正解:C,D
質問 5:
Given the following:
How many locks will be used on tab1 to run the query?
A. 0
B. 1
C. Depends on the number of index pages accessed
D. 2
正解:A
質問 6:
Which objects can be compressed?
A. blobspace BLOBs
B. smart BLOBs
C. partition BLOBs
D. CLOBs
正解:C
芳贺** -
早速勉強していきたいと思います!とても有用なC2090-619参考書になります。