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

  • Cap Gemini aptitute test questions (31)
  • Cap Gemini interview questions (1055)
  • Cap Gemini placement papers (1)
  • Cap Gemini technical test questions (44)



Cap Gemini SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

22 23939

What is meant by Join? What are the different types of Joins available? Explain.

5 9681

How will you select unique values from a list of records?

7 8118

How will you delete a particular row from a Table?

7 7462

What is the difference between the Primary and Foreign key?

7 8474

From an Employee table, how will you display the record which has a maximum salary?

28 17716

What is nvl function?

4 5827

what is 'force view'?

3 8755

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

13 9675

what is global temporary tables and how use that tables in pl/sql packages

1 5581

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

3 9445

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

5 10115

What are the steps you take to tune(performance tuning) the code in plsql?

4 8717

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

3 4402

which will default fire first  statement level trigger or row level trigger

2 2649

Post New Cap Gemini SQL PLSQL Interview Questions




Un-Answered Questions

write about the transportation in plants related to vascular system?

532


Hi Friends, I worked with 8.2 not with 9.2. Please help me in this prob. I created one script and recorded some think and save as Test 1 then I opened process--open the object repository manager. Switch to file->save->give some name->save as Objectrepo1.tsr file. (This is the global repository file.) Then I went to object repository->tools-> associate repository ->click + icon ->open the previously saved Objectrepo1.tsr file. This is the global repository Now I created one more script and save as Test 2. In this script I am calling script with the Help of "Call of existing action" and I executed but QTP is not able to execute B’cos it is QTP is not able to read the Object Repository of Test 1. Please let me know why? Once I made Script 1 as a shared Obj. Repository so it would not give any Problem. Right?

510


1. What is differential relay? How it operates? 2.How to calculate the Short Circuit Impedance in Transformer? 3.What is the alternate solution for testing of polarity by using polarity tester while its milli ammeter does not works? 4. While testing the 33KV Busbar by using Hipot kit, what should be the test voltage we have to apply? 5. What is the procedure/activities to be taken to inject the current more than 2000A by using 2000A Loading Transformer? 6. Explain how you can give the overload setting to any Motor Protection Relay for a HT motors with formula and example? 7. Why restricted earth fault protection is needed? Why can’t differential Protection is sufficient? 8. What should be the minimum and maximum ohmic value for earthing? 9. Why DC Currents are not used in transformer? 10. What is the Frequency while we step up the voltage from 220V to 11KV? Is it possible? Explain it?

667


what is the difference between bussiness development and bussiness system analyst?

791


hello friend i wish to study a course related to the electrical construction, controlling and monitoring , which course i want to study? pls give me the name of institute?

369


HOW TO WORK A VFD?SAY SIMPLE METHOD

1975


what is the syllabus for mahagenco recruitment drive for the post of chemist

1584


what are your career plans upon completion of the programme and the relevance of recity generation to your professional development?

491


tell me about a time in the past where you did something to improve teamwork and motivate staff towards a common goal?

1640


When i run a programm of orphan process. Instead of getting child's parent (ppid)=1 ..i get 1400 and it varies as per system. How can i findthe right soluion??? My pgm: #include # include int main() { int pid; pid=fork(); if(pid < 0) {exit(-1);} else if(pid==0) { printf("Child Process is Sleeping ..."); sleep(10); printf("Orphan Child's Parent ID : %u ",getppid()); } else { printf("Parent Process Completed ... %u ",getpid()); exit(0); } return 0; } Output:

619


Explain how the lubricating oil circulates in a diesel engine.

368


draw vector diagram and +ve,zero sequence diagram of symmetrical three phase fault.

401


1.What is IDT? 2.What is permanent shear buckling? 3.Explain Crippling? 4.Why IRB check is imp while one design fuselage? 5.Explain Column buckling?

1679


i have applied for junior engg. signal II please send me questions papers for it

541


can anyone tell me few critical bugs in ecommerce project.

2844




Cap Gemini SQL PLSQL Interview Questions
  • C (2)
  • OOPS (2)
  • C++ General (1)
  • COM DCOM (2)
  • VC++ AllOther (1)
  • Programming Languages AllOther (2)
  • CGI Perl (1)
  • VB Script (10)
  • Shell Script (4)
  • UDP (1)
  • Networking AllOther (1)
  • Visual Basic (1)
  • C Sharp (1)
  • ASP.NET (6)
  • Crystal Reports (1)
  • BizTalk (1)
  • Dot Net Framework (3)
  • Dot Net AllOther (1)
  • Exchange Server (1)
  • Oracle General (9)
  • Database Management (2)
  • Forms Reports (1)
  • Oracle AllOther (4)
  • SQL Server (18)
  • MySQL (1)
  • DB Administration (2)
  • SQL PLSQL (15)
  • Databases AllOther (1)
  • Linux AllOther (1)
  • Unix Commands (3)
  • Unix General (4)
  • Unix AllOther (1)
  • Solaris AllOther (3)
  • Operating Systems General Concepts (1)
  • WinRunner (1)
  • Load Runner (2)
  • QTP (39)
  • Test Director (1)
  • Selenium (1)
  • Automation Testing AllOther (1)
  • Manual Testing (82)
  • QA Concepts (14)
  • Mobile Testing (1)
  • Test Cases (7)
  • Test Documents Reporting (1)
  • Testing AllOther (19)
  • COBOL (21)
  • JCL (16)
  • CICS (14)
  • DB2 (30)
  • IMS (2)
  • Natural (1)
  • MVS (1)
  • VSAM (5)
  • RPG400 (8)
  • COBOL400 (1)
  • DB400 (3)
  • Core Java (17)
  • Advanced Java (5)
  • Swing (1)
  • Struts (2)
  • JDBC (1)
  • Weblogic (2)
  • Java J2EE AllOther (4)
  • Java Related AllOther (4)
  • MQSeries (2)
  • Middleware AllOther (1)
  • SOAP (1)
  • Teradata (8)
  • Business Objects (17)
  • Cognos (24)
  • Informatica (63)
  • Ab Initio (1)
  • Data Stage (19)
  • SAS (3)
  • ETL (4)
  • Data Warehouse General (2)
  • HR Questions (4)
  • WiFi Security (1)
  • SAP Basis (27)
  • SAP ABAP (106)
  • SAPScript (3)
  • SAP SD (93)
  • SAP MM (16)
  • SAP PP (2)
  • SAP FI CO (59)
  • SAP HR (27)
  • SAP CRM (55)
  • SAP APO (1)
  • SAP Business Warehouse (9)
  • SAP Security (19)
  • SAP ALE IDocs (2)
  • SAP B1 (1)
  • SAP Business Objects BO BOBJ (1)
  • CRM General (1)
  • Siebel (14)
  • Oracle Apps Technical (11)
  • Oracle Apps Financial (15)
  • Oracle Apps Manufacturing (1)
  • Oracle Apps HRMS (1)
  • Oracle Apps SCM (6)
  • WebMethods (9)
  • TIBCO (1)
  • Mechanical Engineering (2)
  • Electrical Engineering (4)
  • Electronics Communications (2)
  • Engineering AllOther (2)
  • Marketing Sales (2)
  • Finance (3)
  • Audit (2)
  • Taxation (2)
  • Accounting General (8)
  • Accounting AllOther (13)
  • Call Centre AllOther (3)
  • BSRB AllOther (1)
  • Everything Else AllOther (1)
  • English (2)
  • General Aptitude (24)
  • Placement Papers (1)
  • CCNA (1)
  • Certifications AllOther (1)
  • H1B Visa (2)
  • USA Student Visa F1 Visa (1)
  • L1 Visa (2)
  • USA Business Visa B1 Visa (1)
  • USA Dependent Visa H4 Visa (2)
  • C Code (1)
  • Programming Code AllOther (1)
  • Oracle Errors (1)
  • MySQL Errors (1)