510-033 Online Practice Questions and Answers

Which of the following queues is used by Warm Standby to replicate data?

A. Inbound queue

B. Outbound queue

C. Dematerialization queue

D. Materialization queue

Nonatomic Bulk Materialization can NOT be used, if ____________ is set for Replication Definition for the primary table.

A. Autocorrection

B. Replicate minimal columns

C. Primary key

D. Searchable columns

In a multiple Replication Server environment, subscriptions are created on the

A. Replicate Replication Server.

B. Primary Replication Server.

C. Replicate Data Server.

D. Primary Data Server.

Function strings can be used to? Choose 3)

A. Mdify updates flowing to a RDB.

B. Gnerate syntax for data flowing to a non-Sybase database.

C. Udate publications.

D. Secify a WHERE clause in an article.

E. Call stored procedures when applying changes to a RDB.

Which option is used to start Replication Server in standalone mode?

A. -S

B. -K

C. -M

D. -C

In an existing table level replication setup, if a column is added to a primary table, then an administrator has to

A. Recreate only the subscription.

B. Recreate only the Replication Definition.

C. Recreate the Replication Definition as well as the subscription.

D. Add the same column to the replicate table and alter the Replication Definition.

Which of the following behaviors can be implemented via function strings? (Choose 2)

A. Control of the behavior of routes

B. Customization of transaction error outcomes

C. Transformation of delete operations to updates

D. Transformation of insert operations to stored procedure calls

E. Connectivity to non-Sybase replicate dataserver

RepAgent error messages are recorded in the?

A. Adaptive Server errorlog.

B. Replication Server errorlog.

C. Stderr.

D. Backup Server errorlog.