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