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.
Specify the types of join that are available?
Briefly describe the term dimension tables and fact tables?
Explain the way to audit the SQL sent to the server.
Illustrates the purposes of a key component in SQL Server Integration Services (SSIS)?
Write down the level of Granularity of a fact table?
Briefly describe the differentiation between the EXCEPT and INTERSECT operators?
Explain the term DataStage and Informatica?
Briefly describe the new features of SQL Server 2005 Analysis Services (or SSAS)?
Describe in brief about the Sybase group?
Explain All Pages Locking in Sybase.
18,76,764
1926265 Asked
3,689
Active Tutors
1443470
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!