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
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?
What are the different ways of moving data or databases between servers and databases in SQL Server?
What is a system database and what is a user database? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
What authentication modes does sql server support? : sql server DBA
what is incremental checkpoint?
by issuing "alter tablespace begin backup;" what happens to tablespace?
Query processing is slow(eg select query)how will u solve that
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
How would you force a log switch?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Hot backup procedure?