What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?1
When using oracle export/import what character set concerns might come up? How do you handle them?1
What kinds of responsibilities does a dba have in a database environment?
If you see contention for library caches how you can fix it?
How to uncatalog backup?
How do I become a dba?
What skills do you need to be an administrator?
What is oracle partial backup?
What is pct free/pct used/pct increase parameter in segment? What is growth factor?
What do you understand by a control file?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
Do you need a commit after ddl statements?
What are the steps involved in instance recovery in oracle?
You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?
What is the full form of dba?
What are functions of dba?