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 |
i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent
If we issue alter database begin backup. What happens to database?
i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???
Explain the difference between a data block, an extent and a segment.
What authentication modes does sql server support? : sql server DBA
What are the recovery models for a database? : sql server DBA
How would you go about increasing the buffer cache hit ratio?
Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog
Describe what redo logs are.
what is the difference between hot backup n rman backup?
Where would you look for errors from the database engine?
Why would you use sql agent? : sql server DBA