How do you troubleshoot errors in a sql server agent job? : sql server DBA
No Answer is Posted For this Question
Be the First to Post Answer
What column differentiates the V$ views to the GV$ views and how?
what do you understand by fine-grained auditing?
What is the recommended interval at which to run statspack snapshots, and why?
Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?
11 Answers FA, GE, Wipro,
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
how can you connect from 10g user to 11g user??
what is a user-defined lock?
Describe what redo logs are.
What is the difference between clustered and non-clustered index? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
What is the default fill factor value? : sql server DBA
How do you find out from the RMAN catalog if a particular archive log has been backed-up?