Interested to Buy Any Domain ? << Click Here >> for more details...
How do you generate file output from sql?
- 0 Answers
- 665 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)
Do you need a commit after ddl statements?
You see a wait on lms process in statspack, what does that mean?
Tell me about standby database? What are some of the configurations of it? What should we watch out for?
What is end user in database?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
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 is the difference between truncate and delete? How would a full table scan behave after?
What is the difference between raid 5 and raid 10? Which is better for oracle?
How should a many-to-many relationship be handled?
What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?
Oracle General 
