Interview Questions And Answers

Q: - When a database is created than which default buffer pool is created?

BMDEFAULTBP

Submitted By:-Jashmin            Email-ID: -kaur.jashmin@gmail.com

Q: - What are the disadvantages of PAGE level lock?

High resource utilization

Submitted By:-Jashmin            Email-ID: - kaur.jashmin@gmail.com

Q: - for Windows, What is the default buffer pool size?

250 pages or 1 MB

Submitted By:-Jashmin            Email-ID: - kaur.jashmin@gmail.com