Interested to Buy Any Domain ? << Click Here >> for more details...
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 1017What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
563What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
586Post New Oracle DBA (Database Administration) Questions
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?
When should you increase copy latches?
what does the no logging option do? Why would we use it?
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?
What are the main functions of dba?
What do you mean by oracle database?
Discuss row chaining, how does it happen? How do you correct it?
The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?
What is the use of the drop option in the alter table command?
How can you determine if an index needs to be dropped and rebuilt?
How can you tell if an index on particular table is used or not used in 9i?
What is the finger command?
What do you understand by the term 'system change number (scn)'?
How to drop an oracle database?
How do you set up tablespaces during an oracle installation?
