Interview Questions Answers.ORG

Interviewer And Interviewee Guide

Sybase Certification Interview Question:

Download Interview PDF

Next ❯❮ Previous

Explain What are some ways to reduce last data page lock contention for inserts?
(Choose 3)
A. alter the table to use the Datarows locking scheme
B. alter the table to use the Datapages locking scheme
C. partition the table
D. create a clustered index on a random key
E. increase the server configuration for the number of locks
F. increase the server configuration for the deadlock checking period

Submitted by: Administrator

A. alter the table to use the Datarows locking scheme
C. partition the table
D. create a clustered index on a random key
Submitted by: Administrator

Next ❯❮ Previous

Read Online Sybase Certification Job Interview Questions And Answers

Top Sybase Certification Questions

☺	If sp_sysmon output consistently shows a high number of Voluntary Yields, which configuration parameter could be modified to improve performance? A. user log cache size B. time slice C. identity grab size D. stack size E. cpu accounting flush interval

☺	Explain Which of the following are true of the Datarows Locking Scheme? (Choose 2) A. Index pages are locked. B. No transaction locks are held on index pages. C. Server uses page locks and row locks, but not table locks. D. Server uses table locks and row locks, but not page locks.

☺	Explain When you run optdiag command on a allpages-locked table with 1000 pages, what will be value of "Forwarded row count"? A. 1000 B. 500 C. 0 D. 1

☺

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.

☺	Where are table/index level statistics stored? A. sysstatistics B. systabstats C. On the leaf level of the index D. The GAM page E. The distribution page

Top Certifications Categories

☺	CCIE Certification Interview Questions.

☺	CCSP Certification Interview Questions.

☺	AFMC Interview Questions.

☺	Sun Certification Interview Questions.

☺	CCDA Certification Interview Questions.

SHARE

Disclaimer

Interview Questions Answers .ORG is responsive and optimized web portal for individuals to get preparation for their job interviews, learning and training. Content at Interview Questions Answers .ORG might be simplified to improve our users experience. We constantly review our content to avoid errors and copyright violations, but we cannot warrant full correctness of all the content. While using this site, you agree to have read and accepted our terms of use, cookie and privacy policy. Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.