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 11477

what is the difference between union and union all

14 42046

What are nested triggers ?

6 30892

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

23 29645

how to retrive only second row from table?

31 45145

what is a cursor

9 13372

which will fire first ? Trigger or Constraint

24 44601

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

12 23829

how to find the second highest salary from emp table?

211 320833

wht is the difference between sqlaserver2000 and 2005

1 5133

what is the difference between the query and corelated query

8 17818

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 7750

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 11565

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

15 24231

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

10 18289

Post New IBM SQL PLSQL Interview Questions


IBM SQL PLSQL Interview Questions


Un-Answered Questions

what are the characteristics of Class Members in C++?

585


How do I generate a list of all .html files in a directory?

525


What is icm instruction?

635


What do you mean by platform independence? What is an interface?

558


Explain when can one deviate from any flight rules and regulations?

633






How do you measure the moment of inertia?

636


what is start center in maximo?

5


Define shrinking?

1


Give some examples of web applications that are used in our day to day life.

529


What is the difference between while and do while loop?

550


What is the difference between constructor injection and setter injection?

168


I am a newbie to QTP / Automation testing. I want to develop a script that creates a data file automatically with proper headings using VBScript in QTP.

1571


Kindly specify the pic clause for the data type of length option field type of data fields?

635


What laptops come with word and excel?

308


Why to use char instead of varchar in the database?

563