Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

IBM SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 1967

i 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

11 11370

There 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 8152

what is the Default Libraries for Oracle Report 6i


If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 6486

Suppose 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 9280

a. 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 7350

what is Difference between Having and Where clause?

5 7544

select top 3 sal from each dept?

17 17853

What are Nested Tables? How will u delete 5 rows from Nested Tables

3 7160

What are Global Temporary tables

3 7938

What are Anti joins

1 7964

why we go for package? what are the advantages of using instead of seperate procuderes or functions

3 7308

How to call the function and Procedure in trigger?

3 8921

What is the difference between SQL and PLSQL

4 7089

Post New IBM SQL PLSQL Interview Questions

IBM SQL PLSQL Interview Questions

Un-Answered Questions

Explain Higher-Order Functions?


What are the tools for process improvement?


Is this artificial intelligence lives over the other software programs and their flexibility?


What do you know about Log Viewer?


What are different types of cable?


What is cakephp tutorial?


Why dint delete the index.bat file in system?


Does spark require hdfs?


Consider a fixed subnet partition of a class B network number that will accommodate at least 76 networks. How many hosts can be on each network? Also mention how you calculated that.


What functions can a view be used to performed?


Explain with the help of an example the usage of a parent-child selector.


How can you bypass sanitation in angular and why would you do so?


What is blob and clob?


Explain about rpa testing?


How do you define social class?