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 11463

what is the difference between union and union all

 14 42025

What are nested triggers ?

 6 30876

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

 23 29536

how to retrive only second row from table?

 31 45097

what is a cursor

 9 13354

which will fire first ? Trigger or Constraint

 24 44569

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

 12 23759

how to find the second highest salary from emp table?

 211 320687

wht is the difference between sqlaserver2000 and 2005

 1 5119

what is the difference between the query and corelated query

 8 17787

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 7736

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 11560

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

15 24180

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

 10 18276

Post New IBM SQL PLSQL Interview Questions


IBM SQL PLSQL Interview Questions


Un-Answered Questions

Write a query to get product details with id in magento?

3

Why we use break in c?

536

What is the usage of continue statement in go programming language?

1

What is the pricing model for sap s/4hana?

103

How do we convert unix time into string and string back to unix time format?

144




What is the difference between bash and dos?

419

What do you understand by the project in talend?

1

What is the typical log file size per 10k requests in an apache web server?

858

Is http patch idempotent?

460

Explain the differences between the nmi and intr

634

We are preparing another project which involves Waste heat recovery from a 1 MW GE Engine. The Engine in particular gives out flue gas at 487Deg C with a flow rate of 5650 kg/hour and this can be cooled to 180 Deg C. This gives a thermal output of ~ 594 KW that is available for input to VAM via heat exchanger / boiler. Additionally 581 KW will be available from engine jacket water (temperature profile 80/ 80 Deg C and a flow rate of 50m3/hr) Our estimation is that 300 TR of cooling is possible with a suitable VAM machine(s). Please advise what is the most suitable arrangement with maximum TR and min Capital expenditure. plz reply me as early as possible

1490

What causes bad system config info?

475

What are the basic differences between UiPath and Automation Anywhere?

189

What is a regex command?

146

What is spritekit and what is scenekit?

439