Describe the Index, Types of index, At what situation we have used? Which one s better than others?
1 3709i 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 19943There 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 11411If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?
2 8832Suppose 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 12745a. 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 10430why we go for package? what are the advantages of using instead of seperate procuderes or functions
3 10312Post New IBM SQL PLSQL Interview Questions
What is igneous rock?
Please tell us about your work experience as HR generalist? What was your work profile in your last organization?
How pseudo-classes are different from pseudo-elements?
How do you separate hydrogen and oxygen gases in industrial electrolysis of water process?
What is MRP group?
How do I fix msvcr100 dll missing in windows 7?
What is mockito in junit?
Which one is better subquery or joins?
Explain the difference between an hdfs block and input split?
Is django good for web development?
Why was reload removed from struts (since 1.1)?
How to view stage logging?
Is angular still popular?
Is jquery code exicuted on the clientside, or serverside?
How can I recover data from undetected hard drive?