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 28298

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

13 19846

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 14026

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 10698

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 20065

What is materialised View?

2 5861

Give an example of Full Outer Join?

1 5585

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

3619

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 14718

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 10777

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 3184

Post New IBM SQL PLSQL Interview Questions

IBM SQL PLSQL Interview Questions

IBM SQL PLSQL Interview Questions (41)

Un-Answered Questions

in multiple branching construct "default" case is a) optional b) compulsarily c) it is not include in this construct d) none of the above

1118

Which of the following is true? A. Discounted cash flow analysis is the least precise of the cash flow techniques as it does not consider the time value of money. B. NPV is the least precise of the cash flow analysis techniques as it assumes reinvestment at the discount rate. C. Payback period is the least precise of the cash flow analysis techniques as it does not consider the time value of money. D. IRR is the least precise of the cash flow analysis techniques because it assumes reinvestment at the cost of capital.

980

What is difference between odbc and jdbc?

1073

What are the causes of having an rmu explode after installation? And how do u treat the bushings of an rmu?

2574

Can java program run without jdk?

972

What is the difference between the alpha helix and the beta-sheet protein conformations?

1176

Any question you want to ask from us?

1246

Can you create sealed abstract class in c#?

937

How can you apply fix pack in websphere 8.5.x?

1048

You are receiving an error "application server is down at this time" but hthe application server is running. What could be the problem? How will you debug it?

924

What is compensation theorem?

3149

What are email services in salesforce and explain how we can use them in code?

483

Compare ansible vs puppet?

Explain the difference between plain-validator and field-validator in struts?

1008

What is indexing oracle sql?

1142