what the REPLACE('JACK AND JUE','J','BL') will return ?
What is Two-Phase Commit ?
8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?
Suppose database is running slow, what will you do?
Can two oracle blocks have the same address?
What do you understand by the view and mention the steps to create, update and drop a view?
What is father dbms?
Which of the packaged procedure is UNRESTRICTED ?
How to retrive a student with height marks,second height and third height from MS access database what wil be the query for this purpuse?
What is the use of ANALYSE ( Ver 7) option in EXP command ?
what is GET_BLOCK property ?
Is it good to store image in database?
What do you understand by fragmentation?