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 13036

what is the difference between union and union all

14 46570

What are nested triggers ?

6 33794

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

23 37893

how to retrive only second row from table?

31 53202

what is a cursor

9 16014

which will fire first ? Trigger or Constraint

24 51356

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

12 29270

how to find the second highest salary from emp table?

211 368401

wht is the difference between sqlaserver2000 and 2005

1 5968

what is the difference between the query and corelated query

8 20707

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 8887

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 13778

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

15 29044

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

10 21129

Post New IBM SQL PLSQL Interview Questions

IBM SQL PLSQL Interview Questions

IBM SQL PLSQL Interview Questions (41)

Un-Answered Questions

what is raid and what are different types of raid configurations? : Sql server database administration

1047

How will you create a striped progress bar using bootstrap?

Why efficiency in thermal power plant is low?

1119

What does the following query do? Insert overwrite table employees partition (country, state) select ..., Se.cnty, se.st from staged_employees se;

921

What is iselignored in jsp?

973

What is spring boot in java? : Spring Boot

480

Is sql harder than python?

1110

Does inner join remove duplicates?

945

Define adabas?

991

What are the types of script?

1179

What are semaphores in linux?

937

How to write test case for this scenario. The First Name data entry field shall be removed from the existing Contact Information screen

2204

Explain how do you override a defined macro?

1083

Describe different types of networks.

406

What accomplishments have given you the most satisfaction in your life?

1234