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 2008

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 11552

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 8256

what is the Default Libraries for Oracle Report 6i

1412

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

2 6551





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 9361

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 7435

what is Difference between Having and Where clause?

5 7630

select top 3 sal from each dept?

17 18162

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

3 7223

What are Global Temporary tables

3 8018

What are Anti joins

1 8009

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

3 7369

How to call the function and Procedure in trigger?

3 8989

What is the difference between SQL and PLSQL

4 7175

Post New IBM SQL PLSQL Interview Questions




IBM SQL PLSQL Interview Questions


Un-Answered Questions

How to Use the WinApi GetObject to get a bitmap?

1971


What is a parallel currency?

158


How can information be put into hashes?

132


What is the function of the plant cell wall?

146


What are the advantages of c language?

164






dear friends pls explain me what is meant by positive seal in solenoid operated valve

1029


Cite an example from life to explain the aesthetic value of Mathematics

153


What is the query used to display all tables names in SQL Server (Query analyzer)?

134


Is tcp or unix socket faster?

100


Explain what are the types of messages?

121


what is the syntax for using sql_variant_property? : Transact sql

130


What are the two main integer types in swift?

98


what are the connectors used in tomcat?

129


How will you motivate your subordinates to raise their performance graph?

150


Write a program to check for prime number?

99