What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
519When using oracle export/import what character set concerns might come up? How do you handle them?
544Post New Oracle DBA (Database Administration) Questions
What is the difference between a database and instance?
If you are not sure what command does a particular unix function what is the best way to determine the command?
What should a dba know?
What is the meaning of database backup?
What is explain plan and how is it used?
How many types of database software are there?
What is difference between co-related sub query and nested sub query?
What causes the "snapshot too old" error? How can this be prevented or mitigated?
What is oracle archived redo log?
Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
Tell me about standby database? What are some of the configurations of it?
What is da in database?
How to uncatalog backup?
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?
Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)