Describe the Index, Types of index, At what situation we have used? Which one s better than others?
1 3583i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75
12 19384There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?
4 11122If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?
2 8639Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?
4 12468a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.
4 10189why we go for package? what are the advantages of using instead of seperate procuderes or functions
3 10083Post New IBM SQL PLSQL Interview Questions
How do I create an aspx file?
How do I save a sql query?
What does ctrl h do?
Explain how you change favicon?
Define orm and its working in j2ee?
Explain implementation of deletion from a binary tree.
Why delegates are required?
How do you use the len function in excel?
What are the archenteron and the blastopore? What is the stage of the embryonic development in which these structures are formed? What are the destinations of the archenteron and of the blastopore?
what is the process of p.f.sub code
Tell me what is coc in rails?
Explain the ionic chiton
What are the different classification of the timing control?
Is it possible that changing one module can also effect other modules of your sap implementation? How?
What are the uses of bynets in multi-node systems?