What are the data management skills?
No Answer is Posted For this Question
Be the First to Post Answer
Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
Discuss row chaining, how does it happen?
Are database administrators in demand?
What operator tests column for the absence of data?
How can you determine the number of sqlnet users logged in to the unix system?
What is tkprof and how is it used?
What is oracle dba role?
If you have an example table, what is the best way to get sizing data for the production table implementation?
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?)
What is different type of rman backup?