What does the no logging option do? Why would we be careful of using it?
- 0 Answers
- 325 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
Why are recursive relationships bad? How do you resolve them?
What is tkprof and how is it used?
What file will give you oracle instance status information? Where is it located?
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.
What are functions of dba?
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 sga and pga?
Do you need a commit after ddl statements?
What does a senior database administrator do?
Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
Discuss row chaining, how does it happen? How do you correct it?
Oracle General 
