If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
529using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
1 932What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
512What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
526Post New Oracle DBA (Database Administration) Questions
What are the five functions of a database?
How can you determine the number of sqlnet users logged in to the unix system?
What is oracle full backup?
How long does it take to learn database administration?
How would you find total size of database in os level?
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
What do you understand by the oracle?
Explain the term 'oracle grid architecture'?
What parameters control copy latches?
What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
How do you set up your tablespace on installation level: low?
I have applied the following commands: now what will happen, will the database will give an error / it will work?
Which date function is used to find the difference between two dates?
Explain the wait events in statspack report 'enqueue'?
How do you prevent oracle from giving you informational messages during and after a sql statement execution?