which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
2 8319I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
10 44422In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
2 5188How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
6 60594. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
3 5808if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
8 6053Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
8 22077i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 7924Post New Wipro DB2 Interview Questions
how to determine H- zone in a column? where it will occur?
why are you selecting for the controlling area same company code?
Hi,Myself Aritra Kundu,has done MBA with Finance & hRM as specialization,recently cracked the SBI Clerical exam Nov 2009.So,now I am beat tensed about the type of questions I am likely to face in the broad.Since I am a managemnt student right from my graduation,Can anyone give some light about the question I am likely to encounter?
How to Provide Column Names Using the DRAW Command ?
If you want to output the results to the log file .. How to do?
In case of a constant mesh gear box, when the left dog clutch is slid to the left by means of the selector mechanism, a) Direct gear is obtained b) First gear is obtained c) Second gear is obtained d) Reverse gear is obtained
what is the meaning of MIN MAX?
What are the different BTG rules to achieve SAP Hybris Advanced Personalization?
I am going to HAL Online test for Computer Science. Can you please mail me the model question papers ?
How will you reduce the concrete flow after mixing the concrete
WHAT IS THE LIMIT OF MLT IN FINISHED PHARMA PRODUCT LIKE TABLET CAPSULE SYRUP CREAM
I am getting the (first) page number and the remaining records displayed in another list in another page BUT the PAGE Number is not displayed? What is the code/solution?
What Are The Steps Involved In The Concreting Process, Explain?
process chain is running I have to stop the process for 1 hour after that re runn the process where it is stopped? in multiprovider can I use aggregations
What are the components of Apache Spark Ecosystem?
- C (153)
- C++ (2)
- STL (10)
- OOPS (37)
- C++ General (30)
- MFC (5)
- COM DCOM (1)
- Win32API (1)
- Delphi (4)
- PHP (13)
- Programming Languages AllOther (19)
- ASP (1)
- CGI Perl (3)
- JavaScript (5)
- VB Script (4)
- JSP (2)
- Shell Script (12)
- Tcl (1)
- AJAX (2)
- Scripts AllOther (2)
- SNMP (6)
- TCP IP (10)
- UDP (2)
- SS7 (1)
- Protocols AllOther (9)
- Networking Administration (27)
- Networking Security (5)
- Networking AllOther (14)
- Visual Basic (14)
- C Sharp (52)
- ASP.NET (63)
- VB.NET (2)
- ADO.NET (9)
- IIS (7)
- Crystal Reports (2)
- Dot Net Framework (4)
- Dot Net WindowsForms (12)
- Dot Net General (24)
- Dot Net AllOther (2)
- Exchange Server (14)
- SharePoint (14)
- WCF (1)
- Microsoft Related AllOther (6)
- Oracle General (46)
- OCI (1)
- Database Management (7)
- Forms Reports (3)
- Oracle AllOther (5)
- SQL Server (59)
- MS Access (2)
- MySQL (5)
- Postgre (1)
- DB Architecture (2)
- DB Administration (4)
- DB Development (1)
- SQL PLSQL (22)
- Databases AllOther (5)
- SDK (2)
- Windows Threads (2)
- Windows General (5)
- Windows AllOther (15)
- Linux Commands (15)
- Linux Threads (1)
- Linux System Calls (8)
- Linux General (4)
- Linux AllOther (4)
- Unix Commands (12)
- Unix Socket Programming (1)
- Unix General (2)
- Unix AllOther (3)
- Solaris Commands (24)
- Solaris System Calls (2)
- Solaris General (72)
- Solaris AllOther (13)
- Vxworks (3)
- RTOS AllOther (1)
- Operating Systems General Concepts (14)
- Data Structures (9)
- Operating Systems AllOther (4)
- WinRunner (15)
- Load Runner (19)
- QTP (144)
- Test Director (2)
- Rational TestSuite (2)
- Silk Test (1)
- Automation Testing AllOther (4)
- Manual Testing (195)
- QA Concepts (8)
- Mobile Testing (2)
- Test Cases (19)
- Test Documents Reporting (2)
- Testing AllOther (11)
- Servers AllOther (4)
- COBOL (31)
- JCL (26)
- CICS (4) DB2 (13)
- IMS (2)
- REXX (2)
- Assembler (1)
- MVS (2)
- VSAM (1)
- QSAM (1)
- IBM MainFrame AllOther (3)
- RPG400 (7)
- DB400 (1)
- COOLPLEX (1)
- IBM AS400 AllOther (7)
- Core Java (94)
- Advanced Java (20)
- Swing (4)
- EJB (8)
- Servlets (8)
- Struts (29)
- JDBC (18)
- J2EE (4)
- Weblogic (11)
- Websphere (1)
- Java Networking (3)
- Java J2EE AllOther (2)
- J2ME (4)
- Java Related AllOther (2)
- MQSeries (1)
- Middleware AllOther (4)
- HTML DHTML (1)
- XML XSLT RSS (2)
- Flash Action Scripting (1)
- Web Related AllOther (1)
- Teradata (21)
- Business Objects (40)
- Cognos (32)
- Informatica (92)
- Ab Initio (9)
- Data Stage (43)
- SAS (9)
- ETL (7)
- Data Warehouse General (4)
- HR Questions (52)
- Design Patterns (6)
- OOAD (3)
- Software Design Tools (2)
- Requirements Management (2)
- Project Planning (3)
- Project Management (4)
- Software Design AllOther (2)
- Debugging AllOther (3)
- Clear Case (2)
- Telecom Routers Switches (1)
- Telecom Protocols (2)
- Voice Gateways (1)
- Telecom Security (1)
- WiFi Protocols (1)
- BlueTooth (3)
- Telecom General (1)
- SAP Basis (31)
- SAP ABAP (108)
- SAPScript (4)
- SAP SD (112)
- SAP MM (22)
- SAP QM (1)
- SAP PP (18)
- SAP FI CO (74)
- SAP HR (30)
- SAP CRM (59)
- SAP SRM (1)
- SAP APO (2)
- SAP Business Warehouse (6)
- SAP Business Workflow (3)
- SAP Security (10)
- SAP ALE IDocs (1)
- SAP B1 (5)
- SAP AllOther (2)
- PeopleSoft HRMS (1)
- Oracle Apps Technical (28)
- Oracle Apps Financial (27)
- Oracle Apps Manufacturing (3)
- Oracle Apps HRMS (1)
- Oracle Apps SCM (3)
- ERP CRM AllOther (4)
- 86 Family (14)
- VLSI (8)
- Embedded Systems AllOther (1)
- Client Server General (5)
- Client Server AllOther (1)
- AI General (1)
- Encryption Decryption (1)
- Cryptography General (1)
- WebMethods (2)
- TIBCO (11)
- JCAPS (1)
- 3D Animation (1)
- Visual Effects (1)
- Software Integration & Delivery (1)
- Software Integration & Release (1)
- Image Processing General (1)
- Pega (6)
- Micro Biology (2)
- Bio Chemistry (1)
- Bio Informatics (50)
- Genetics (1)
- Biological Sciences AllOther (1)
- Inorganic Chemistry (2)
- Physical Chemistry (2)
- General Chemistry (2)
- Pharmacy (1)
- Dermatology (1)
- Gynaecology (1)
- Mathematics (14)
- Civil Engineering (3)
- Mechanical Engineering (16)
- Electrical Engineering (79)
- Electronics Communications (63)
- Aeronautical Engineering (1)
- Bio Engineering (2)
- Instrumentation (3)
- Engineering AllOther (26)
- Business Administration (11)
- Marketing Sales (11)
- Banking Finance (23)
- Human Resources (19)
- Personnel Management (1)
- Infrastructure Management (1)
- IT Management (3)
- Non Technical (2)
- Audit (7)
- CompanyAffairs CS (3)
- Taxation (27)
- Accounting General (44)
- Accounting AllOther (86)
- Advertising Media AllOther (1)
- Call Centre AllOther (311)
- UPSC Political Science (1)
- UPSC History (1)
- UPSC General Studies (2)
- UPSC AllOther (1)
- SSC Geography (1)
- SSC General Science (1)
- SSC General Studies (3)
- SSC AllOther (9)
- RRB (7)
- CDS (1)
- POs (5)
- BSRB Clerical (4)
- BSRB AllOther (1)
- Group I (12)
- Group II History (6)
- Group II AllOther (4)
- APPSC AllOther (13)
- General Knowledge_Current Affairs (30)
- Government AllOther (10)
- Law AllOther (1)
- Teaching (5)
- Funny Interview Questions (5)
- Everything Else AllOther (19)
- English (20)
- General Aptitude (190)
- Puzzles (21)
- Placement Papers (31)
- CCNA (47)
- Microsoft Certifications (15)
- Sun Certifications (2)
- CISA Certification (1)
- Oracle Certifications (4)
- Certifications AllOther (3)
- H1B Visa (8)
- USA Student Visa F1 Visa (2)
- L1 Visa (1)
- USA Visitor Visa B2 Visa (2)
- USA Business Visa B1 Visa (1)
- USA Dependent Visa H4 Visa (6)
- USA AllOther Visa (1)
- UK Visa (1)
- Australia Visa (2)
- Canada Visa (1)
- C Code (20)
- C++ Code (3)
- J2SE Code (1)
- ASP.NET Code (2)
- C Sharp Code (2)
- Visual Basic Code (1)
- Programming Code AllOther (1)
- PHP Code (2)
- JSP Code (1)
- JavaScript Code (1)
- VB Script Code (1)
- GATE (5)
- CAT (1)
- MAT (1)
- GMAT (3)
- AIIMS (1)
- ICET (4)
- C C++ Errors (2)
- Oracle Errors (9)
- SQLServer Errors (1)
- Scripts Errors (2)
