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
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
how can you enable flashback feature?
What are the steps you will take to improve performance of a poor performing query?
how can you create a user-defined lock?
What is the importance of a recovery model? : sql server DBA
how does an oracle clusterware manage crs resources?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What are the different types of upgrades that can be performed in sql server? : sql server DBA
what is the use of recording information about current session?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
what is asm?
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
Why would you use sql agent? : sql server DBA