Interested to Buy Any Domain ? << Click Here >> for more details...
You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?
568A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?
516You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
548If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?
1155How many redo logs should you have and how should they be configured for maximum recoverability?
533Describe 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?
551Post New Oracle DBA (Database Administration) Questions
What is the difference between sga and pga?
What does >> do?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
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?
Why do we need a database?
How much money does a dba make?
How do you install statspack?
What do you understand by recovery catalog?
While taking hot backup (begin end backup) what will happens back end?
What do you mean by oracle dba?
What happens if the constraint name is left out of a constraint clause?
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?
What happens when the default and temp tablespace clauses are left out from create user statements?
How can you find out how many users are currently logged into the database?
How do you put database is archivelog mode, explain procedure?
