What is explain plan and how is it used?
No Answer is Posted For this Question
Be the First to Post Answer
If you see statistics that deal with "undo" what are they really talking about?
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
Discuss row chaining, how does it happen?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
How would you find total size of database in os level?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
What file will give you oracle instance status information? Where is it located?
What does the no logging option do? Why would we be careful of using it?
A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?
What are the different types of database users?
Which database is best to learn?
Who is a database user?