What is the difference between truncate and delete? Why is one faster?
No Answer is Posted For this Question
Be the First to Post Answer
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
What are the data management skills?
Explain the wait events in statspack report 'db scattered read'?
When configuring sqlnet on the server what files must be set up?
What is the difference between raid 5 and raid 10? Which is better for oracle?
How can you find out how many users are currently logged into the database?
When should you increase copy latches? What parameters control copy latches?
When should an artificial (or derived) primary key be used?
What file will give you oracle instance status information? Where is it located?
If 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?
How many redo logs should you have and how should they be configured for maximum recoverability?