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

Where would you look for errors from the database engine?

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

How to start SQL Server in minimal configuration mode?

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

What is database replicaion? What are the different types of replication you can set up in SQL Server?

What would you do with an "in-doubt" distributed transaction?

1)how to Take Backup in sql server 2005 from Flash Drive

How do you switch from an init.ora file to a spfile?

How do you trace the traffic hitting a sql server? : sql server DBA

What's the benefit of "dbms_stats" over "analyze"?

Give two examples of referential integrity constraints.

Give two methods you could use to determine what DDL changes have been made.

For more DB Administration Interview Questions Click Here