Which of the following will be a valid SOURCE for "InfoSphere Change Data Capture (CDC) for Oracle Triggers"?

A. Local Oracle databases running on any supported platform

B. Remote Oracle databases running on any supported platform

C. Both local and remote Oracle databases running on any supported platform

D. Heterogeneous databases running on any supported platform

What happens when a new CDC subscription is created while database logging is turned off at the source?

A. The CDC instance cannot be connected

B. The datastore cannot be created or connected

C. The subscription that uses the source datastore cannot be created

D. When the subscription is started using the Management Console, the replication will not succeed.

Which of the following statements about 'Create CDC instance' is TRUE?

A. CDC instance creation will fail if logging is turned off at the source.

B. CDC instance creation will fail if logging is turned off at the target.

C. CDC instance creation will succeed with a warning message, if logging is turned off.

D. CDC instance creation will fail if logging is turned off both at the source and the target.

How are the CDC subscription and DataStage job started when the "Auto start" option is not enabled?

A. Start the DataStage Job first, then start the CDC subscription

B. Start the CDC subscription first, then start the DataStage job

C. Start only the CDC subscription, and the DataStage job will be started automatically

D. It is not possible to start DataStage job, if "Auto start" option is not enabled

Which of the following statements about CDC instances is FALSE?

A. CDC instances are created using the CDC Configuration Tool.

B. CDC instances require unique TCPIP port numbers.

C. A single CDC instance can be set up to access multiple data sources.

D. Multiple CDC instances can be set up to access a single data source.

Can the port number originally assigned to a CDC instance be changed to a new value?

A. Yes, by editing the CDC instance properties.

B. Yes, by editing the Management Console properties.

C. No, it requires the CDC instance be re-created from scratch.

D. No, a port number once assigned to an instance cannot be changed.

A subscription is 'Parked' if ________________.

A. the subscription has finished executing a cycle

B. the subscription has finished the initial refresh and is waiting for new changes

C. the subscription has been copied/promoted/imported or renamed

D. the subscription has been deactivated

Which of the following capabilities are available when integrating CDC with DataStage using Direct Connect method?

A. Auto-start/stop of DataStage Job

B. Two-way communication for status updates with CDC DataStage object

C. The ability to generate a default DataStage job using CDC that can be imported into and customized using DataStage

D. All of the above.

Which DataStage connectivity object is used to integrate CDC with DataStage?

A. MQ Stage

B. CDC Transaction Stage

C. DB2 Connect Stage

D. ODBC Stage

Which of the following statements about CDC Datastores is FALSE?

A. You need to assign a user to the datastore before it can be used.

B. Multiple datastores can access a single CDC instance.

C. A single datastore can access multiple CDC instances.

D. Multiple CDC users can access a single datastore.