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 13390

what is the difference between union and union all

 14 47612

What are nested triggers ?

 6 34226

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

 23 39425

how to retrive only second row from table?

 31 54939

what is a cursor

 9 16590

which will fire first ? Trigger or Constraint

 24 52797

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

 12 30055

how to find the second highest salary from emp table?

 211 378223

wht is the difference between sqlaserver2000 and 2005

 1 6124

what is the difference between the query and corelated query

 8 21295

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 9138

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 14223

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

15 30024

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

 10 21722

Post New IBM SQL PLSQL Interview Questions


IBM SQL PLSQL Interview Questions


Un-Answered Questions

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

2599

what is rate of different service tax in haryana

1908

where do you see yourself in five years' time?

1200

Tell us about your hobbies.

1207

1. What ports does FTP traffic travel over? 2. What ports does mail traffic utilize? 3. What ports do HTTP and HTTPS use? 4. Why is NTP required in an NFS network? 5. Name some common mal software on the server side 6. What is CPAN? How do you access it? 7. What is PEAR? 8. What advantages does mod_perl have over a perl CGI? 9. What is required to do SSL in Apache 1.x? 10. What is Tcl? 11. What is a servlet engine/container? 12. What is BIND? 13. Name the steps to setup a slave zone in BIND 14. Name the steps to setup a primary zone in BIND 15. What commands would you use under Solaris or Linux to modify/view an LDAP tree?

2863

What are the properties of the transaction?

1114

What r the names of the reports that you prepared?

1075

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2526

What is trait in php?

1093

Question on maha cement

834

can any one know about NIC (National Informatics Centre) questions Patterns and full detail about written exam, and interview send to softshikha2005@yahoo.com.in Thank you

2195

What are your salary requirements at McDonalds?

1321

Tell me your mother daily routine

2044

Can anyone send me question papers for section engineer for railways and send me on my id- abhay_jg@yahoo.com

2147

Suppose database is running slow, what will you do?

2629