What happens when the default and temp tablespace clauses are left out from create user statements?
No Answer is Posted For this Question
Be the First to Post Answer
What is a production dba?
How much money does a dba make?
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?
Discuss row chaining, how does it happen?
Describe 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?
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?
How do you put database is archivelog mode, explain procedure?
If you see statistics that deal with "undo" what are they really talking about?
What does dba stand for in technology?
What is explain plan and how is it used?
What is the most common database language that a db administrator needs to know?
What is end user in database?