Explain Data Page Locking in Sybase
Explain Data Page Locking in Sybase.
Expert
Data Page Locking:
The other two locking schemes are bundled together under the title Data Page Locking, refering to the fact that only data pages are ever locked in the conventional sense. Data Page Locking is divided into two categories.
Provide a brief introduction on the term ‘cube grouping’?
Specify the use of data stage designer?
Describe the difference between the bulk-logged recovery models, full, and SQL Server 2000 simple?
States the term Global temporary.
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
What is OLAP? Briefly define it.
Provide a brief differentiation between independent and dependent data warehouse?
Explain the term Repository Tables within the Data Stage?
Define the term File Manager and Storage Manager in relational database management system.
Illustrates the term data sparsity and how this effect upon aggregation?
18,76,764
1946589 Asked
3,689
Active Tutors
1429660
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!