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?
629Post New Oracle DBA (Database Administration) Questions
What is the purpose of the grep command?
What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
What are the different responsibilities of a dba?
How many redo logs should you have and how should they be configured for maximum recoverability?
Who is dba in dbms?
What is the purpose of the import option ignore? What is its default setting?
Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
What happens if a tablespace clause is left off of a primary key constraint clause?
Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
What is a dba certification?
You have taken a manual backup of a datafile using os. How rman will know about it?
What are four common errors found in an alert .log?
Explain procedure to change characterset of a database.
What are functions of dba?