Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
What is the main function of database?
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 the difference between a database and instance?
What does a dba stand for?
How many redo logs should you have and how should they be configured for maximum recoverability?
When using oracle export/import what character set concerns might come up? How do you handle them?
Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
What does dba stand for database?
While taking hot backup (begin end backup) what will happens back end?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
Discuss row chaining, how does it happen? How can you reduce it?