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 full form of dba?
What is a database instance?
How can you find dead processes?
Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?
What happens if the constraint name is left out of a constraint clause?
Does dba need to know programming?
Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?
What should a dba know?
How many databases should a dba manage?
The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?
When using oracle export/import what character set concerns might come up? How do you handle them?
What is the difference between internal & external schema?
How do I become a data manager?
How can you find your id on a system?
Does a dba have to file taxes?