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.
Write about the term metadata in brief.
Describe briefly perform recovery?
In Sybase does table Partitioning needs user-defined segments?
Consider a MOVIEdatabase in which data is recorded about the movie industry. The data requirement an u will given me this solution
Give a brief introduction of the term BUS Schema?
Explain an unsupported method to shrink a database.
State various types of the input links within the data stage?
Explain the master/detail reports?
What accurately is SQL Server 2005 Service Broker?
Why recursive relationships are not good? How do you solve them?
18,76,764
1922275 Asked
3,689
Active Tutors
1457629
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!