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

What is Referential Integrity?

3 12989

what is the difference between union and union all

14 46459

What are nested triggers ?

6 33722

how to check the 3rd max salary from an employee table?

23 37741

how to retrive only second row from table?

31 53042

what is a cursor

9 15943

which will fire first ? Trigger or Constraint

24 51136

How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?

12 29207

how to find the second highest salary from emp table?

211 367136

wht is the difference between sqlaserver2000 and 2005

1 5950

what is the difference between the query and corelated query

8 20615

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 8860

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 13736

What does “select count(*) from tab” result?

15 28925

What does “select count(1) from tab” result?

10 21047

Post New IBM SQL PLSQL Interview Questions

IBM SQL PLSQL Interview Questions

IBM SQL PLSQL Interview Questions (41)

Un-Answered Questions

Illustrate the concept of experiential learning in Mathematics.

1141

Can tongue piercings wreck teeth?

750

What is polymorphism and types?

1096

What are examples of markup languages?

530

What is action chaining ?

1078

What statement marks the beginning of an in-stream or cataloged procedure in jcl and assigns default values to parameters defined in the procedure?

1304

what are aggregate and scalar functions? : Sql dba

1051

Why the usage of pointers in C++ is not recommended ?

1438

Tell me what is the difference between xrange and range?

799

How can you find the list of objects that have been repaired in the system?

1257

What is the importance of authentication?

976

what are the direct expense of loan department in banks.

1465

With reference to construction of state highways, please let me know the total Bill Of Quantities as per the following details:- 1) Subgrade - 500 mm 2) Granular Sub-Base (GSB) - 200 mm 3) Wet Mix Macadam I (WMM I) - 150 mm 4) Wet Mix Macadam II (WMM II) - 100 mm 5) Dense Bituminous Macadam (DBM) - 60 mm 6) Bituminous Crust (BC) - 40 mm Road Length is 44 Kms. Road Width is 7 mtrs. Please provide the BOQ of each layer as per Compacted Factor & Loose Factor both. Also, if possible please provide me the approximate details of total material required (all categories viz. soil, gravel, stone aggregrate, sand, bitumen etc.) as per general mix design prevailing in India. Thanks & Regards -- Rokr

2445

Modal vs Modaless in VB??

1950

What are the ways to expose data item?

423