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?
396Post New Oracle DBA (Database Administration) Questions
You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?
Explain the wait events in statspack report 'enqueue'?
I have applied the following commands: now what will happen, will the database will give an error / it will work?
Can you remove an open file under unix?
If you have an example table, what is the best way to get sizing data for the production table implementation?
Who is dba in dbms?
What operator tests column for the absence of data?
What does database administrator do?
What is a dba programmer?
As an oracle dba what are the entire unix file you should be familiar with?
How many redo logs should you have and how should they be configured for maximum recoverability?
What are the types of locks in database?
Which function is used to find the largest integer less than or equal to aspecific value?
How can you determine the number of sqlnet users logged in to the unix system?
what does the no logging option do? Why would we use it?
