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 8935

what is the difference between union and union all

14 35458

What are nested triggers ?

6 24097

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

22 21246

how to retrive only second row from table?

31 33771





what is a cursor

9 9447

which will fire first ? Trigger or Constraint

24 33293

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

11 17620

how to find the second highest salary from emp table?

209 254856

wht is the difference between sqlaserver2000 and 2005

1 4023

what is the difference between the query and corelated query

8 12423

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 5967

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 8079

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

14 15972

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

9 13951

Post New IBM SQL PLSQL Interview Questions




IBM SQL PLSQL Interview Questions





Un-Answered Questions

What happens if you get a ‘connection refused java exception’ when you type hadoop fsck /?

1


describe the weblogic communication flow.

1472


What do you know about KPMG?

3575


Explain about few error status codes of idms.

1


can used Protected Class outside Function.?

28






What are Subscribers and Publishers in MQTT?

1


Where are sedimentary rocks found? : soil science

9


If P will increase then what will happen with PID?

4051


What is apache tomcat?

10


Explain how to create a backup and copy files in jenkins?

1


How would you go about verifying the network name that the local_listener is currently using?

2158


How the Business Process Testing is different from Robots Testing?

1


How will you calculate the number of executors required to do real-time processing using Apache Spark? What factors need to be considered for deciding on the number of nodes for real-time processing?

5


which power station plants r more efficient? which is less? which is most expensive and which is cheapest?

840


What is the meaning of refinance?

32