Claims and Drains are the locks used to control the
concurrency between SQL processes and utilities.
Referring to the above statement, what is the maximum
number of concurrent Claimers for a Subsystem?
Choice 1
32
Choice 2
64
Choice 3
128
Choice 4
256
Choice 5
No limit


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB Administration Interview Questions

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  


What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  


What is a system database and what is a user database? : sql server DBA

0 Answers  


What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  


What authentication modes does sql server support? : sql server DBA

0 Answers  






what is incremental checkpoint?

1 Answers   CTS,


by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,


Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,


What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  


How would you force a log switch?

4 Answers  


What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers  


Hot backup procedure?

2 Answers  


Categories