Which statement is true when creating a table through a Grid operation with the replication option enabled?
A. A separate replicate set is created for each table.
B. ERKEY shadow columns are automatically added to the table.
C. The replication for the table is defined with the always apply conflict resolution rule.
D. All servers in the Enterprise Replication domain are included as participants in the replicate created.
How can ER onconfig parameters be modified dynamically?
A. cdr set onconfig
B. cdr tune onconfig
C. cdr define onconfig
D. cdr change onconfig
Given the following SLA definition:
SLA group_1=HDR+(inst_2+inst_3)+SDS
How will new connections be routed through the SLA?
A. Load balanced between all secondary instances.
B. Load balanced between inst_2 and inst_3, then either HDR or any SD secondary instance.
C. The HDR instance first, then inst_2, followed by inst_3, finally to any SD secondary instance.
D. The HDR instance first, load balanced between inst_2 and inst_3, then to any SD secondary instance.
Which parameter is used to configure the servers in a high-availability cluster so that transactions complete after failover?
A. SURVIVAL_TX_ENABLE
B. FAILOVER_CALLBACK
C. SURVIVAL_TX_TIMEOUT
D. FAILOVER_TX_TIMEOUT
What statement about users accessing a Flexible Grid is true?
A. Every user can execute commands on the Flexible Grid.
B. Only userinformix can execute commands on a Flexible Grid.
C. Users have to be authorized to execute Flexible Grid commands.
D. Commands can only be executed from the node on which the Flexible Grid was created.
What is a requirement for online attach/detach of fragments?
A. The table cannot have constraints.
B. The table must have a unique index.
C. The table must have a remainder fragment.
D. The table fragmentation scheme and the index fragmentation scheme must be identical.
Which statement about automatic space management is true?
A. Spaces cannot be extended manually.
B. Onlyunmirrored spaces can be extended.
C. Mirrored andunmirrored spaces can be extended.
D. The time interval for low storage space checks is not user configurable.
Which statement about temporary dbspaces is FALSE?
A. Temporarydbspaces are not backed up.
B. A raw table can be created in a temporarydbspace.
C. Tables stored in temporarydbspaces are not logged.
D. Temporarydbspaces can have non-default page sizes.
What does the following task function do?
EXECUTE FUNCTION task("storagepool add", "/region2/dbspaces", "0", "0", "20000", "1");
A. Creates a secondstoragepool.
B. Createsdbspace at /region2/dbspaces.
C. Invalid offset and total size forstoragepool add command.
D. Add the directory /region2/dbspaces to the storagepool with a beginning offset of 0, a total size of 0, initial chunk size of 20 MB, and a high priority.
How is the automatic addition of more space triggered?
A. Via the default alarm program.
B. When the instance is restarted.
C. The internalmon_low_storage task.
D. When the limit of the ADD_SPACEonconfig parameter is reached.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C2090-919 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.