In which dictionary table or view would you look to
determine at which time a snapshot or MVIEW last
successfully refreshed?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB Administration Interview Questions

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  


What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  


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

1 Answers  


mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,


Give two examples of referential integrity constraints.

2 Answers  






What column differentiates the V$ views to the GV$ views and how?

3 Answers  


what is meant by gateway

1 Answers   IBM,


What view would you use to look at the size of a data file?

3 Answers  


how can you enable flashback feature?

0 Answers   Oracle,


how do see how much space is used and free in a tablespace

2 Answers   Genpact,


what do you understand by fine-grained auditing?

0 Answers   Oracle,


what is the difference between db2start command and start database manager command?

1 Answers  


Categories