Answer Posted / narmada kumari
1/3 of physical memory, can be 2/4k depending on bit of 32 or 64
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
how can you initialize log miner?
how can you implement fine-grained auditing?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How do you trace the traffic hitting a sql server? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Why would you use sql agent? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
what is a user-defined lock?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What the different components in replication and what is their use? : sql server DBA
How do you open a cluster administrator? : sql server DBA