Describe the Index, Types of index, At what situation we have used? Which one s better than others?
1 3648i 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 19630There 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 11251If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?
2 8728Suppose 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 12585a. 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 10300why we go for package? what are the advantages of using instead of seperate procuderes or functions
3 10186Post New IBM SQL PLSQL Interview Questions
How do I check the health of my laptop windows 10?
Diff between IF and where ?
Which welding process uses non-consumable electrodes?
What is if in excel?
What is an update in terms of sap system?
What are the complex datatypes in pig?
Will any motor burn if voltage provided is lesser than the rated voltage???? If yes, then how is speed control possible with voltage control
How to call constructor for a parent class?
What is an immediately-invoked function expression?
Are you familiar with different rpa jobs?
mis & qis formats
What are the views in Hive?
What is persistence layer?
What are the differences between char and varchar data types?
Explain poject management