Answer Posted / chowdary
Buffer Cache Advice, Segment Level Statistics and Timed
Statistics
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the commands used in dcl? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
how can you connect from 10g user to 11g user??
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
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What purpose does the model database server? : sql server DBA
how can you enable flashback feature?
what are the benefits of flashback feature?
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?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
what are the types of connection load-balancing?
Which autogrowth database setting is good? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?