what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,1096
How to display the hierarchy of employee and managers without using connect by prior.1 2261
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
how to know the tables in database having foreign key?2 2466
find the second highest salary of the emp table6 4336
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?7 4752
what is an sql server?1 2472
cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..2 2602
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
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?
what is normalization? types of normalization? example of each form? how do u implement normalization in ur project?
How would you best determine why your MVIEW couldn't FAST REFRESH?
which one is currently in used software cmpanies.
1) Does oracle have any table which contain all the exceptions and it's code internally?
How to synchronize 2 schema's objects?
what is normalisation?what are its uses?
How to do Data size testing? Who does this testing (Developer or tester)?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
Which is better Oracle or MS SQL? Why?
key flexfield structure
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?