If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
576using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
1 1023What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
570What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
593Post New Oracle DBA (Database Administration) Questions
How can you tell if an index on particular table is used or not used in 9i?
Who is dba in dbms?
What os user should be used for the first part of an oracle installation (on unix)?
Can you remove an open file under unix?
What are the skills required for oracle dba?
What is the full form of dba?
When should you increase copy latches?
How do you prevent oracle from giving you informational messages during and after a sql statement execution?
How can you determine the number of sqlnet users logged in to the unix system?
How do I become a dba?
When using oracle export/import what character set concerns might come up? How do you handle them?
What are functions of dba?
What are the types of locks in database?
What do you mean by oracle dba and what is its role?
What does database administrator do?