Name three advisory statistics you can collect.

Question Posted / guest

Name three advisory statistics you can collect...

Answer / chowdary

Buffer Cache Advice, Segment Level Statistics and Timed
Statistics

Is This Answer Correct ?

4 Yes

0 No

More DB Administration Interview Questions

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

Where do you find the default index fill factor and how to change it? : sql server DBA

How can you enable a trace for a session?

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

What the different topologies in which replication can be configured? : sql server DBA

Explain the concept of the DUAL table.

how can you find out if a table can be redefined?

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

Why does Oracle not permit the use of PCTUSED with indexes?

Name three advisory statistics you can collect.

What is dbcc? : sql server DBA

For more DB Administration Interview Questions Click Here