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 |
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.