What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
No Answer is Posted For this Question
Be the First to Post Answer
Who is a database user?
What is main function of database administrator?
You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?
What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
what does the no logging option do? Why would we use it?
What do you understand by the oracle?
What are the five main functions of a database administrator?
While taking hot backup (begin end backup) what will happens back end?
You are getting busy buffer waits. Is this bad? How can you find what is causing it?
What is your favorite tool for day-to-day oracle operation?
What are the possible ways to gain information regarding the control file?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.