Describe the Index, Types of index, At what situation we have used? Which one s better than others?
1 3630i 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 19523There 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 11209If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?
2 8686Suppose 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 12547a. 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 10266why we go for package? what are the advantages of using instead of seperate procuderes or functions
3 10147Post New IBM SQL PLSQL Interview Questions
do you think we shall remove un wanted soil for foundation excavation even if the thickness of the soil strata is more than 8m ?
what are the main components of cassandra data model?
Explain the different types of queries created in reports?
What is uniqid php?
Is it better to learn python or java?
Why would you use a template?
What is a modular application? What does module-relative mean?
Is schema the same as database?
What is apache struts framework?
How does hdfs get a good throughput?
differentiate between planning characteristic and navigation attribute
What is the factoring problem ?
How the object properties will be recognised by the tool If the functions/ statements are written manually?
Explain what are pre defined queries?
What kind of testing should we need to perform while testing Mobile app ?