Describe the Index, Types of index, At what situation we have used? Which one s better than others?
1 3710i 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 19955There 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 11422If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?
2 8844Suppose 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 12757a. 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 10444why we go for package? what are the advantages of using instead of seperate procuderes or functions
3 10322Post New IBM SQL PLSQL Interview Questions
How do I download a podcast from patreon?
What is c++ used for in games?
What happens if time-only values are provided as date and time literals?
Is swift pass by reference?
What does each individual site collection offers?
Explain mutant in operating system (os)?
What is media query?
What do you know about mongodb?
What are your major strengths?
What is the importance of javascript? Expalin
How will you convince a prospect who has knowledge of a better product than what you have to offer?
Who is a authorised Dealer?
what is smtp routing ?
What is sap script?
How many rows and columns 2019 excel?