What are the five main functions of a database administrator?
No Answer is Posted For this Question
Be the First to Post Answer
What is dump destination? What are bdump, cdump and udump?
When should you increase copy latches?
What is the difference between raid 5 and raid 10? Which is better for oracle?
using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
What happens if a tablespace clause is left off of a primary key constraint clause?
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?
Explain the wait events in statspack report 'db sequential real'?
How can you determine if an oracle instance is up from the operating system level?
Explain the various modes of normalization?
You see multiple fragments in the system tablespace, what should you check first?
How can you find out how many users are currently logged into the database? How can you find their operating system id?
What is pct free/pct used/pct increase parameter in segment? What is growth factor?