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?
617A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?
558You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
590If 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?
1193How many redo logs should you have and how should they be configured for maximum recoverability?
567Describe 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?
589Post New Oracle DBA (Database Administration) Questions
What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?
What is the difference between raid 5 and raid 10? Which is better for oracle?
If you have an example table, what is the best way to get sizing data for the production table implementation?
Discuss row chaining, how does it happen?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
What do you mean by oracle dba and what is its role?
What are types of data model?
Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?
How many dba can you have?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
How do you put database is archivelog mode, explain procedure?
Are database administrators in demand?
How can you determine the number of sqlnet users logged in to the unix system?
