Describe the Index, Types of index, At what situation we have used? Which one s better than others?
1 3774i 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 20306There 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 11567If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?
2 8944Suppose 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 12939a. 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 10586why we go for package? what are the advantages of using instead of seperate procuderes or functions
3 10453Post New IBM SQL PLSQL Interview Questions
In many arthropods, the segments of the body are grouped into 3 distinct parts. Name all three parts?
What are the different principle of OOPS?
What are sessions and cookies?
In a traditional automotive plant emphasis is on reducing cost by producing more. give points to show that this leads to behaviours that discourage stopping the line to fix problem.
Is llvm a virtual machine?
What is f4 on mac?
How do I know which version of windows?
How do I calculate/select Droop CT ratio for various capacity of generators?
What is different between thorughput and data rate?
Why we are using Isolation Power Transformer inplace of commercial power transformer? What's the difference between them?
What are the types of operator?
What happens if the list-style-type property is used on a non-list element like a paragraph?
What is the difference between emulator and simulator?
Name the various message severity levels in web logic?
What is the easiest way to extract hydrogen from water and the safest way to store it?