Sybase Certification Exam Question:
Download Questions PDF

Can you explain Which two are advantages of use max_rows_per_page to reduce the row
density? (Choose 2.)
A. It may decrease the disk space used.
B. It may decrease the contention.
C. It may decrease the number of page splits.
D. It may decrease the number of page I/Os.
E. It may help to decrease row movement of frequently updated varchar columns.

Answer:

B. It may decrease the contention.
E. It may help to decrease row movement of frequently updated varchar columns.

Download Sybase Certification Interview Questions And Answers PDF

Previous QuestionNext Question
Can you explain What is the maximum row size for DOL tables?
A. 1024 bytes of data.
B. 1958 bytes of data.
C. 1962 bytes of data.
D. 2000 bytes of data.		Explain Which of the following statements describes readpast locking? (Choose 2)
A. It can be specified at the session, transaction, and table level.
B. It allows insert, update, and delete commands to read past any incompatible lock.
C. It allows readers to not block writers.
D. It allows select and readtext queries to silently skip all rows or pages locked with incompatible locks.