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 8722

what is the difference between union and union all

14 34928

What are nested triggers ?

6 23515

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

22 20668

how to retrive only second row from table?

30 32902





what is a cursor

9 9089

which will fire first ? Trigger or Constraint

24 32406

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

11 17144

how to find the second highest salary from emp table?

209 250719

wht is the difference between sqlaserver2000 and 2005

1 3934

what is the difference between the query and corelated query

8 12081

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 5815

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 7770

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

14 15352

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

9 13582

Post New IBM SQL PLSQL Interview Questions



Un-Answered Questions

My vendor filled liquid oxygen in our 11000 liter capacity tank. He filled from 1400 MMWC up to 3200 MMWC. I followed the provided conversion table and found that we had been supplied 1800 MMWC liquid which is going to yield 2815 cubic meter. On the other hand, the vendor claims that he supplied as follows:- 5236 cub mtr(3200 MMWC)-2124 cub mtr(1400MMWC) = 3112 cub mtr. I fear that he wants to charge 297 cubic meters extra. He claims that my method was wrong and his was right. He says that this disparity is because of the conical shape of the base of the flask. I will be thankful if somebody can explain me the truth.

1680


How to calculate the sag on transmission Lines.

1624


can we connect qtp 8.2 version with test director 8.0 verion if how if not why 2)when test director 8.0 version released

1891


How do you make a TEXTBOX read only? Or, how do I prevent the user from changing the text in a TEXTBOX?

304


What is the table & field to identify the no of items (bottles) stored in one case?

1291






we are having yokogawa centum cs3000 dcs in our power plant. i need some of the operator guides NOT to appear in HIS0163 AND HIS 0162 but it shoul appear in HIS0164 HOW TO DO IT?

1435


What is the toughest moment you faced in your testing carrier in which everyone praised you?

1115


what are the applications of PLC?

854


8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

899


in battery charging room we find two fuses (one in positive other in negative cables ).why it is so?one fuse is ore than sufficient?

1106


what is be the overhead, if i use binary transmission. and will it be sent using xml text or how ?

1113


Describe about the Pile test methods, which are used in Industrial & Multistory Buildings in general.

911


how to take a backup of adc

1951


tell me about eletrical contractor

819


How to prevent closing of an undocked ToolBar?

886






IBM SQL PLSQL Interview Questions
  • Software (1)
  • C (84)
  • OOPS (37)
  • C++ General (9)
  • MFC (2)
  • COM DCOM (1)
  • VC++ AllOther (1)
  • Delphi (11)
  • PHP (16)
  • Programming Languages AllOther (31)
  • ASP (5)
  • CGI Perl (7)
  • JavaScript (6)
  • VB Script (15)
  • JSP (6)
  • Shell Script (6)
  • AJAX (1)
  • Ruby on Rails (1)
  • Scripts AllOther (2)
  • SNMP (1)
  • TCP IP (10)
  • UDP (1)
  • Protocols AllOther (3)
  • Networking Administration (28)
  • Networking Security (3)
  • Networking AllOther (9)
  • Visual Basic (5)
  • C Sharp (35)
  • ASP.NET (37)
  • VB.NET (3)
  • ADO.NET (11)
  • IIS (9)
  • Crystal Reports (3)
  • BizTalk (3)
  • Dot Net Framework (14)
  • Dot Net WindowsForms (2)
  • Dot Net General (3)
  • Dot Net AllOther (4)
  • Exchange Server (12)
  • Microsoft Related AllOther (2)
  • Oracle General (39)
  • Architecture (1)
  • Database Management (11)
  • Forms Reports (7)
  • Oracle AllOther (9)
  • SQL Server (61)
  • MySQL (3)
  • DB Architecture (1)
  • DB Administration (11)
  • DB Development (9)
  • SQL PLSQL (41)
  • Databases AllOther (7)
  • Windows Threads (2)
  • Windows General (6)
  • Windows AllOther (26)
  • Linux Commands (18)
  • Linux Threads (2)
  • Linux IPC (2)
  • Linux Socket Programming (1)
  • Linux System Calls (5)
  • Linux General (3)
  • Linux AllOther (20)
  • Unix Commands (33)
  • Unix IPC (2)
  • Unix Socket Programming (1)
  • Unix General (5)
  • Unix AllOther (11)
  • Solaris Commands (30)
  • Solaris Threads (3)
  • Solaris System Calls (2)
  • Solaris General (10)
  • Solaris AllOther (82)
  • Operating Systems General Concepts (17)
  • Data Structures (1)
  • Operating Systems AllOther (2)
  • WinRunner (10)
  • Load Runner (28)
  • QTP (176)
  • Test Director (3)
  • Rational TestSuite (4)
  • Silk Test (9)
  • Selenium (1)
  • Automation Testing AllOther (10)
  • Manual Testing (277)
  • QA Concepts (23)
  • Mobile Testing (3)
  • Test Cases (21)
  • Test Documents Reporting (2)
  • Testing AllOther (12)
  • Apache (1)
  • Servers AllOther (6)
  • COBOL (139)
  • JCL (132)
  • CICS (31)
  • DB2 (78)
  • IMS (11)
  • IDMS (1)
  • Natural (6)
  • Assembler (1)
  • QMF (2)
  • MVS (2)
  • OS390 (2)
  • VSAM (11)
  • Sysplex (1)
  • IBM MainFrame AllOther (39)
  • RPG400 (59)
  • DB400 (3)
  • COOLPLEX (1)
  • IBM AS400 AllOther (31)
  • IBM PL/1 (1)
  • Core Java (77)
  • Advanced Java (7)
  • Swing (2)
  • EJB (4)
  • Servlets (17)
  • Struts (16)
  • JDBC (11)
  • JMS (2)
  • SunOne (1)
  • J2EE (3)
  • Weblogic (30)
  • Websphere (7)
  • Java J2EE AllOther (6)
  • J2ME (1)
  • Java Related AllOther (4)
  • MQSeries (16)
  • Middleware AllOther (10)
  • HTML DHTML (3)
  • XML XSLT RSS (6)
  • Flash Action Scripting (1)
  • SOAP (1)
  • Web Related AllOther (2)
  • Teradata (42)
  • Business Objects (66)
  • Cognos (171)
  • Informatica (179)
  • Actuate (3)
  • Ab Initio (56)
  • Data Stage (147)
  • SAS (5)
  • Micro Strategy (3)
  • ETL (12)
  • Data Warehouse General (25)
  • HR Questions (24)
  • Design Patterns (6)
  • Requirements Management (1)
  • Project Planning (2)
  • Project Management (2)
  • Software Design AllOther (2)
  • CTC (1)
  • Debugging AllOther (3)
  • Clear Case (10)
  • Version Control AllOther (1)
  • Vi Editor (1)
  • Telecom Protocols (1)
  • ISDN (2)
  • Telecom General (2)
  • SAP Basis (145)
  • SAP ABAP (300)
  • SAPScript (13)
  • SAP SD (310)
  • SAP MM (56)
  • SAP QM (4)
  • SAP PP (34)
  • SAP PM (6)
  • SAP PS (1)
  • SAP FI CO (262)
  • SAP HR (32)
  • SAP CRM (37)
  • SAP SRM (2)
  • SAP APO (2)
  • SAP Business Warehouse (29)
  • SAP Security (159)
  • SAP Interfaces (2)
  • SAP Netweaver (22)
  • SAP ALE IDocs (8)
  • SAP B1 (16)
  • SAP GTS (1)
  • SAP AllOther (11)
  • CRM General (7)
  • Siebel (55)
  • ERP General (3)
  • Oracle Apps Technical (53)
  • Oracle Apps Financial (74)
  • Oracle Apps HRMS (6)
  • Oracle Apps CRM (1)
  • Oracle Apps SCM (10)
  • Oracle Apps AllOther (1)
  • ERP CRM AllOther (1)
  • VLSI (4)
  • Client Server General (4)
  • AI Algorithms (1)
  • AI AllOther (1)
  • Cryptography Algorithms (1)
  • WebMethods (16)
  • TIBCO (18)
  • BPM (1)
  • EAI AllOther (1)
  • Visual Effects (1)
  • Requirement Management (5)
  • Risk Analysis (6)
  • Estimation Analysis (4)
  • Planning & Integration (4)
  • Software Quality Analysis (3)
  • Software Integration & Release (1)
  • Program Management (4)
  • Apache Hadoop (1)
  • Micro Biology (1)
  • Bio Informatics (1)
  • Nuclear Physics (1)
  • Organic Chemistry (1)
  • Health Pharma AllOther (1)
  • Civil Engineering (3)
  • Mechanical Engineering (8)
  • Electrical Engineering (40)
  • Electronics Communications (26)
  • Chemical Engineering (2)
  • Instrumentation (4)
  • Engineering AllOther (17)
  • Business Administration (11)
  • Marketing Sales (14)
  • Banking Finance (16)
  • Human Resources (17)
  • Personnel Management (1)
  • IT Management (5)
  • Non Technical (3)
  • Business Management AllOther (12)
  • Audit (5)
  • CompanyAffairs CS (3)
  • Taxation (21)
  • Accounting General (58)
  • Accounting AllOther (93)
  • Call Centre AllOther (289)
  • Government (1)
  • UPSC General Studies (3)
  • UPSC AllOther (3)
  • SSC General Science (1)
  • SSC General Studies (6)
  • RRB (4)
  • POs (2)
  • BSRB Clerical (2)
  • Group I (4)
  • Group II History (3)
  • Group II AllOther (2)
  • Group II Political Science (1)
  • General Studies (2)
  • APPSC AllOther (10)
  • General Knowledge_Current Affairs (19)
  • Government AllOther (2)
  • Teaching (1)
  • Funny Interview Questions (5)
  • Everything Else AllOther (13)
  • English (12)
  • General Aptitude (67)
  • Puzzles (6)
  • Placement Papers (22)
  • CCNA (42)
  • CCDA (1)
  • Microsoft Certifications (6)
  • Sun Certifications (6)
  • CISA Certification (2)
  • Oracle Certifications (5)
  • ISTQB Certification (5)
  • Certifications AllOther (6)
  • H1B Visa (3)
  • USA Student Visa F1 Visa (5)
  • L1 Visa (4)
  • USA Immigration Visa (1)
  • USA Business Visa B1 Visa (2)
  • USA Dependent Visa H4 Visa (2)
  • USA AllOther Visa (2)
  • UK Visa (1)
  • Australia Visa (1)
  • Canada Visa (3)
  • C Code (8)
  • C++ Code (7)
  • J2SE Code (2)
  • J2EE Code (2)
  • C Sharp Code (1)
  • ADO.NET Code (1)
  • JSP Code (1)
  • GATE (3)
  • IIT JEE (1)
  • CAT (1)
  • OPENMAT (1)
  • ICET (2)
  • Oracle Errors (14)
  • SQLServer Errors (1)
  • Scripts Errors (2)