In which dictionary table or view would you look to
determine at which time a snapshot or MVIEW last
successfully refreshed?
Answer / anuradha
USER_MVIEW_REFRESH_TIMES
This dictionary table lists the Materialized views and
their last refresh times for each master table that the
user can look at.
| Is This Answer Correct ? | 1 Yes | 0 No |
interview questions with answer for cts
How to call a stored function in oracle?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
how to use sequence and what use of sequence cache
How to connect to the server with user account: sys?
How would you change old and new values in an insert, delete and update triggers?
Please explain joins in oracle?
When do we use group by clause in a sql query?
Can multiple cursors being opened at the same time?
How to write a left outer join with the where clause in oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..