If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
622using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
1 1083What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
609What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
658Post New Oracle DBA (Database Administration) Questions
Can you remove an open file under unix?
What happens if a tablespace clause is left off of a primary key constraint clause?
Which date function is used to find the difference between two dates?
What are the goals of dba?
You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?
What do you understand by the term 'system change number (scn)'?
Does a dba have to file taxes?
How can you find out how many users are currently logged into the database? How can you find their operating system id?
Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
If you see contention for library caches how you can fix it?
What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
What is the dba role in oracle?
What is pga_aggregate_target?
What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?
What exactly does a dba do?