Explain All Pages Locking in Sybase
Explain All Pages Locking in Sybase.
Expert
All pages locking:
This is the scheme which is implemented in all servers previous to 11.9. Now there are locks taken out at the page level that may include many rows. The name considers to the fact that all of the pages in any type of data manipulation statement are locked, data and index both.
Give a brief note on the term degenerate dimension table?
Briefly describe the foreign key columns in dimension table and fact table?
Specify the types of connections we use while connecting with the database?
What is meant by the Surrogate key?
Illustrates the term data structure?
Illustrate the five SQL built-in functions.
Specify the several Business Objects products?
Explain the linked universes?
What is cmaxpktsz good for in Sybase?
Illustrates the various extensions for stored procedures?
18,76,764
1954275 Asked
3,689
Active Tutors
1439694
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!