What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
- 0 Answers
- 320 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How do you prevent output from coming to the screen?
What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?
If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?
What are the skills required for oracle dba?
Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
How can you find dead processes?
You see a wait on lms process in statspack, what does that mean?
How can you determine if an index needs to be dropped and rebuilt?
What are the functions of administration?
What is dba in sound level?
You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?
What is main function of database administrator?
Oracle General 
