IBM C2090-619 - IBM Informix 12.10 System Administrator Exam
Page: 1 / 27
Total 130 questions
Question #1 (Topic: )
Which ONCONFIG parameter would you use to disable the automatic creation or extension
of chunks?
of chunks?
A. SP_WAITTIME
B. SP_THRESHOLD
C. SP_AUTOEXPAND
D. SP_CHUNKEXTEND
Answer: C
Question #2 (Topic: )
Which statement is valid about Data consolidation using send-only replicates?
A. You can have more than one target server.
B. You cannot modify a server to change its mode to send-only.
C. You cannot use this replicate for tables that include TimeSeries columns.
D. You need to define a different replicate for each send-only primary server.
Answer: C
Question #3 (Topic: )
What is the earliest version you can migrate / upgrade directly to Informix 12.10?
A. 7.30
B. 8.0
C. 9.40
D. 10.0
Answer: D
Question #4 (Topic: )
Which object can be compressed?
A. dictionary table
B. temporary table
C. attached b-tree index
D. detached b-tree index
Answer: D
Question #5 (Topic: )
Which two statements are true about Enterprise Replication of TimeSeries data types?
(Choose two.)
(Choose two.)
A. ATS and RIS files must be in XML format.
B. The replicate must be a mastered replicate.
C. The conflict resolution rule must be always-apply.
D. The WHERE clause in the participant definition must include a TimeSeries column.
E. CDR_TSINSTANCEID configuration parameter must be set to the same value for every replication server.
Answer: B,C
