Sybase Certification Interview Question:

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.

Submitted by: Administrator

B. It allows insert, update, and delete commands to read past any incompatible lock.
D. It allows select and readtext queries to silently skip all rows or pages locked with incompatible locks.
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.

Accounts

Analysis

Banking

Basic Job

Best Engineering

Best Multimedia

Community

New Artist

9th Class

Accounting

Civil Engineering

Engineering

General Knowledge (GK)

Information Technology (IT)

Networking

Soft Skills Quizzes MCQs

Certifications Interviews

Sybase Certification Interview Question:

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

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