Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / b.r.reddy
We can manually set the statistical values.
We can gather statistics in parallel mode.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
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
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
how can you implement fine-grained auditing?
when does an alert gets signaled?
How would you extract DDL of a table without using a GUI tool?
how can you connect from 10g user to 11g user??
What is the default fill factor value? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is asm?
What would you do with an "in-doubt" distributed transaction?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
