Explain Data Only Page Locking in Sybase
Explain Data Only Page Locking in Sybase.
Expert
Data Only Locking:
This locking scheme locks a page at a time yet, including all of the rows comprised within such page, but utilizes a new mechanism, termed as latches, to lock index pages for the shortest amount of instant. One of the consequences of given scheme is that this does not update index pages. So as to support this Sybase has introduced a new idea, forwarded rows. Such are rows which have had to move since they have grown beyond space permitted for them upon the page they were created as 2002 bytes per page.
Assume when a session fails subsequent to loading of 10,000 records in to target. How can we load the records from 10001 the record when we run session next time?
Explain the group by in select statement? Answer: Group by clause is utilized in Teradata to eliminate repetitive values in a column or group of columns, while we se
Explain how the Chasm trap is solved?
Name the Applications of tree data-structure?
Explain the types of the Containers?
Explain the uses of stored procedure?
Illustrates the way to assign an address to an element of a pointer array? Answer: We can assign a memory address to an element of an array of pointers by usin
Explain the term folder?
Specify some of the different @ Functions?
Explain the stored procedure in the Teradata?
18,76,764
1953191 Asked
3,689
Active Tutors
1449899
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!