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 2980

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

 12 15341

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 9998

what is the Default Libraries for Oracle Report 6i

 1840

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

 2 7831

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 11151

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 9156

what is Difference between Having and Where clause?

 5 9285

select top 3 sal from each dept?

 17 22944

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

 3 8622

What are Global Temporary tables

 3 9635

What are Anti joins

 1 9055

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

 3 9026

How to call the function and Procedure in trigger?

 3 10306

What is the difference between SQL and PLSQL

 4 8618

Post New IBM SQL PLSQL Interview Questions


IBM SQL PLSQL Interview Questions


Un-Answered Questions

What are the key benefits of sap integrated business planning?

515

How we define validity of any Reagent , Indicator and Volumetric Solutions

1333

How to connect with firebird database in delphi using tsqlconnection?

1

Is xml a programming language?

469

which domain is of high demand for software testing, Right now i am working in Education domain .How about demand for Education domain and which companies are recruiting in education domain

3216




hai, i completed my B.Tech.i planning to join in testing tools.can anybody suggest me good institute.I heard about Nageshwara Rao sir institute for testing tools.Now which one is good so i can get job in testing tools. please help me.....where to join in hyd.

1616

Can we use views in stored procedure?

515

How to enable clean urls in drupal ?

95

In case you receive a story at the last day of the sprint to test and you find there are defects, what will you do? Will you mark the story to done?

1

1 *2 1*3 *2*4 1*3*5 *2*4*6

1370

How to disable caching on back button of the browser?

531

What do you understand by ensemble learning?

97

How many versions of rss language standards?

836

Do you know what is the purpose of t3 in weblogic server?

463

Tell me any 5 best scm practices?

527