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
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What is dcl? : sql server DBA
what is the use of ocr?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
what is the role of dip user in our database?
how can you record information about current session?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What are the operating modes in which database mirroring runs? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What are the different sql server versions you have worked on? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
what do you understand by flashback feature of oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.