Pessimistic locking and optimistic locking
Describe briefly the difference between pessimistic locking and optimistic locking?
Expert
Optimistic locking supposes no transaction conflict will happen and deals with the consequences when it does. Pessimistic locking supposes that conflict will happen and so prevents it ahead of time with locks. Basically, optimistic locking is preferred for the Internet and for many intranet applications.
Illustrates the properties of Cursors in brief?
Specify the enhancements which are made within datastage 7.5 and also compare with the 7.0?
Describe briefly the term maximum and minimum cardinality?
Describe briefly the ‘paradigm mismatch’ among SQL and application programming languages.
List out the various schemas which are supported by the BO Designer?
Explain about the Database.
Explain the term optimization and performance tuning and its work in practical projects?
Explain Triggers and Rules?
Give a brief differentiation between Dimensional Modeling and ER Modeling?
Specify different types of transformations available in the Informatica?
18,76,764
1924989 Asked
3,689
Active Tutors
1426452
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!