If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
309using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
1 568What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
276What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
296Post New Oracle DBA (Database Administration) Questions
What is the finger command?
How do I become an administrator?
What is your favorite tool for day-to-day oracle operation?
Why are recursive relationships bad? How do you resolve them?
What are dba privileges?
You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?
How do you use automatic pga memory management with oracle 9i and above?
You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?
Tell me about standby database? What are some of the configurations of it?
How do you set up your tablespace on installation level: low?
What operator tests column for the absence of data?
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
What is dba training?
Explain procedure to change characterset of a database.
What do you understand by a control file?
