What background process refreshes materialized views?
Answer Posted / mathavan
Job Queue processes
| Is This Answer Correct ? | 31 Yes | 2 No |
Post New Answer View All Answers
suppose you want to audit specific activities on sensitive data. How can you achieve that?
Why does Oracle not permit the use of PCTUSED with indexes?
What purpose does the model database server? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How to start SQL Server in minimal configuration mode?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What are the different ways you can create databases in sql server? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
What are the recovery models for a database? : sql server DBA