What is concurrency transparency
Write down a short note on the term concurrency transparency?
Expert
Concurrency transparency is where each and every transaction in a distributed database is treated as when it is the only one in the system. Thus when several transactions are running at one time, the outcomes will be the same as when each and every transaction was run in sequential order. The transaction manager assists to provide concurrency control. The three methods that might be used are versioning, locking, and timestamping.
Explain the types of views within Data stage Director?
Specify the System variables?
Describe briefly perform recovery?
Describe briefly the different methods of loading Dimension tables?
Define the way of passing of variables to a SQL routine.
Give details why an information gap exists in most organizations?
Describe in brief about the Sybase group?
What are the purposes of using lookups?
What are the difficulties faced by the database developer during implementing pre compiled statements?
What do you understand by the term foreign key in DBMS, and why is it employed for?
18,76,764
1957383 Asked
3,689
Active Tutors
1432257
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!