IBM SQL PLSQL Interview Questions Answers, IBM Placement Papers, IBM Technical, HR Interview Questions, IBM Aptitude Test Questions, IBM Campus Placements Exam Questions

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

A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

21 27616

Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance

13 19416

i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?

6 13870

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

6 10499

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 19909

What is materialised View?

2 5772

Give an example of Full Outer Join?

1 5499

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3569

have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.

8 14473

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 10660

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

1 3084

Post New IBM SQL PLSQL Interview Questions

IBM SQL PLSQL Interview Questions

IBM SQL PLSQL Interview Questions (41)

Un-Answered Questions

Are there still updates for windows 8?

810

Which browsers work with java?

1078

I m entering much more than 500-700 sales vouchers per month. But I m getting a problem while entering sale voucher is that If I have entered a sale voucher in the middle of a date then the voucher no is being changed. So how can enter a sale voucher in the middle of a date so that i can adjust the voucher nos from changing.

1475

How do you differentiate var and val in Kotin?

262

My application uses ajax heavily how do I use selenium rc to work with ajax operations?

901

Find the greatest and smallest number among the given 5 numbers without using ‘>’ or ‘<’ operators

2418

What is the action of task environment in artificial intelligence? a) Problem b) Solution c) Agent

2486

Does every abap/4 have a modular structure? : abap modularization

1127

Water boiling point temperature is 100 deg. In which liquid state is convert into the gas state,but in turbine which principle is use by which exhaust temperature is 50-55 deg and is in the stage of steam?

1145

Why do we use virtual methods in c#?

959

What happens when you make call 'delete this;'?

1102

what is the different between mechanical starter vs electrical starter? Solid stage starter? Soft starter?

2307

what is the reason while warning lamp is on while the engine is cranking?

2145

Which eclipse is best for java?

1004

If you suggest a certain idea to be implemented to your team, but your leader isn't convinced, how would you persuade your team and your leader to execute and consider your idea?

1140