You see multiple fragments in the system tablespace, what should you check first?
No Answer is Posted For this Question
Be the First to Post Answer
You see multiple extents in the temporary tablespace. Is this a problem?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
What is the full form of dba?
What happens when the default and temp tablespace clauses are left out from create user statements?
What are the various ingredients of sga?
What are types of data model?
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?
What skills do you need to be an administrator?
You see a wait on lms process in statspack, what does that mean?
If you are not sure what command does a particular unix function what is the best way to determine the command?
How many control files should you have? Where should they be located?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?