Встретился такой вопрос при подготовке к сертификации. Правильно ли я думаю, что правильный ответ 3? Нет чёткого понимания.
execute DBMS_MVIEW.REFRESH (‘OBJECT_OWNER.TEST_MVIEW’,’C’,ATOMIC_REFRESH=>false);


You have recently upgraded your database from 9i to 11g. There is a materialized view in your database, and it is configured to do a complete refresh using following command in a scheduled job - execute DBMS_MVIEW.REFRESH(‘OBJECT_OWNER.TEST_MVIEW,’C’);
The command was working fine on 9i, however it results in 'dreaded snapshot too old' error. In your investigation, you realise an issue with the refresh command. Which of the following options is correct to refresh this materialized view so that the error does not occur?

execute DBMS_MVIEW.REFRESH(‘OBJECT_OWNER.TEST_MVIEW,’F’);
execute DBMS_MVIEW.REFRESH (‘OBJECT_OWNER.TEST_MVIEW’,’C’,ATOMIC_REFRESH=>true);
execute DBMS_MVIEW.REFRESH (‘OBJECT_OWNER.TEST_MVIEW’,’C’,ATOMIC_REFRESH=>false);
None of the given options