SAP Sybase Replication Server Assessment Test

Topics Covered

Primary Database, Replication Server, Replicate Database, Data Integration, LTI (Log Transfer Interface), LTL (Log Transfer Language), Replication Agent, Primary as well as Replicate Data Server, Database Gateway, ECDA (Enterprise Connect Data Access), DSI Executer, Replication Server Memory

Useful for hiring

Sybase Database Admin
Sybase Administrator

View Sample Report

Start hiring job-fit candidates using this assessment

GET A DEMO

"Our recruitment team loves Interview Mocha especially for their skill assessments, simulators, and friendly support. Since using Interview Mocha, we interview only relevant candidates, and this has reduced our time to hire. Recruitment is no longer an hassle for us."

Christoph, e-Zest GmbH

View Test Details

View Sample Questions

The admin sqm command is executed at the Replication Server and displays the following output:
Info First Seg.Block Last Seg.Block Next Read
133:0 ReplicateDS.RDB 4.3 4.3 4.4

Which of the following are correct?

Note: There can be multiple correct answers to this question.

- The queue is empty and is ready for new transactions.
- The queue is behind and contains lots of transactions that need to be processed.
- The queue is full and the stable device should be enlarged.
- The queue is an inbound queue.
- The queue is an outbound queue.

Given the following table and stored procedure:
create table t (a int)
create procedure p
@param int
as
insert t values (@param)

A Replication Definition exists for table 't'. Table 't' and stored procedure 'p' are both marked for replication. What will be replicated when the following code is executed without errors?
begin transaction
insert t values (100)
execute p 101
commit
execute p 102

- One 'execute' operation is replicated
- One 'insert' and one 'execute' operations are replicated
- One 'insert' and two 'execute' operations are replicated
- Three 'insert' and two 'execute' operations are replicated

Good News! You can customize this test as per your requirement

Choose and add questions from Interview Mocha question libraries
Add your own set of questions
Customize test settings like duration, number of questions, passing score, web proctoring and much more
Mail us at support@interviewmocha.com to create a custom test