Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 2288

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 12377

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 8731

what is the Default Libraries for Oracle Report 6i

1514

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

2 6863





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 9843

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 7880

what is Difference between Having and Where clause?

5 8060

select top 3 sal from each dept?

17 19367

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

3 7575

What are Global Temporary tables

3 8414

What are Anti joins

1 8269

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

3 7730

How to call the function and Procedure in trigger?

3 9324

What is the difference between SQL and PLSQL

4 7598

Post New IBM SQL PLSQL Interview Questions




IBM SQL PLSQL Interview Questions


Un-Answered Questions

What happens when you post to year 2006 when you are in 2007?

291


What happened to toplevelnavigationservice, it is not there on april ctp refresh?

255


Explain how adwords work?

1


What are filegroups in sql server?

216


What are the events done by the Kernel after a process is being swapped out from the main memory?

1615






How do I merge cells in excel for mac?

85


What is pagination in bootstrap?

1


How do I secure my blog?

26


What is oracle apps (erp)?

243


Why is the main method declared static?

224


What is conduction?

287


What is html explain?

172


What is entity reference?

237


What is #include iostream h in c++?

262


How is string represented in objective-c?

1