Explain the way of transactions in Sybase
Explain the way of transactions in Sybase. How it relates with partition assignment.
Expert
Single user is assigned to a partition for the period of a transaction. Assignment of partitions resumes along with the first insert within a new transaction. The user holds the lock, and thus partition, till the transaction ends.
For this purpose, if you are inserting a great deal of data, you must batch it in separate jobs, each in its own transaction.
Define the term DataStage?
Write down the differentiation between view and materialized view?
Describe briefly the difference between pessimistic locking and optimistic locking?
Explain the difference between ARRAY and STACK in Data Structures?
What are the causes of Monopoly? Explain in brief.
Explain how one source columns or the rows may be loaded within the two different tables?
What are the catches?
State various types of the input links within the data stage?
Write a short on the six database functions which occur during the systems development life cycle?
What do you understand by the term ACID transaction in DBMS? Describe briefly?
18,76,764
1922424 Asked
3,689
Active Tutors
1448541
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!