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?
614A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?
555You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
580If 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?
1186How many redo logs should you have and how should they be configured for maximum recoverability?
563Describe 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?
587Post New Oracle DBA (Database Administration) Questions
How do you set up your tablespace on installation level: low?
When should an artificial (or derived) primary key be used?
What are types of data model?
Which database is best to learn?
System tablespace cant be exported from one database and imported into another why?
How should a many-to-many relationship be handled?
How do you install statspack?
When should the default values for oracle initialization parameters be used as is?
Which process writes data from data files to database buffer cache?
What kinds of responsibilities does a dba have in a database environment?
List five most important parameter in 9i affecting performance?
What happens if the constraint name is left out of a constraint clause?
Discuss row chaining, how does it happen? How can you reduce it?
If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?
How do you set up tablespaces during an oracle installation?
