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 27094

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

13 19044

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 13675

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 10288

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 19748

What is materialised View?

2 5690

Give an example of Full Outer Join?

1 5433

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

3529

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 14174

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 10569

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 3004

Post New IBM SQL PLSQL Interview Questions

IBM SQL PLSQL Interview Questions

IBM SQL PLSQL Interview Questions (41)

Un-Answered Questions

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1638

What is an index associated with a constraint?

996

When we write a= load …, what does 'a' called?

499

How are these services essential for a company?

1072

What is transactional in java?

963

How do I open outlook in safe mode?

What is resource bundling in jsf?

How to save space when inserting rows monotonically?

864

What is unboundlocalerror in python?

861

How can you write a comment in swift?

742

Flower position, stem length, and seed shape were three traits that were studied by Mendel. Each is controlled by an independently assorting gene. If a plant that is heterozygous for all three traits was allowed to self- fertilize, what proportion of the offspring would be expected to show all three dominant phenotypes?

3078

Why am I getting the 9582s and what is vm fragmentation?

980

How to know the information about a file?

921

in the account there is 10,000 rupees and i entered 20000, in this case how will you test the application

1662

Define the term GDP? What is the current GDP of the country?

1148