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 (1053)
  • 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 23322

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

5 9479

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

7 7833

How will you delete a particular row from a Table?

7 7210

What is the difference between the Primary and Foreign key?

7 8224

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

28 17305

What is nvl function?

4 5659

what is 'force view'?

3 8567

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 9382

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

1 5435

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 9157

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

5 9904

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

4 8464

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 4209

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

2 2480

Post New Cap Gemini SQL PLSQL Interview Questions




Un-Answered Questions

can anybody send the rrb chennai &rrb bopal question papers of 2006&2007.My exam is on 12 oct 2008.Its urgent

544


wow to calculate the transformer rating(KVA)

450


What happens when water mixed with cowdung is used for priming instead of water for lifting water in pumps?

505


in control scheme dc logic wiring commonly using negative loop,what is the reason?if we use positive looping what will happen?

551


how to make and keep a human liver culture?

487


what is payment medium program ? how to config advance payment in app ? payment suplymentary in app?

1012


Can anyone post the SAP-Project systems interview questions.

1926


Write a VLSI program that implements a toll booth controller?

2434


In any Hyderabd institute you can find these word commomly used by faculties ... Yes or no / Right or wrong so funny...

549


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

1068


what is balance sheet, capital budgeting, financial statements, current ratio, profit maximization?

492


why do u think u r suitable for the field of marketing....????

808


57. Calculate the volume of a truck loaded with stone chips whose data are as follows– 5 Top Length - 13-9, 13-10, 13-09 Bottom Length - 13-11, 13-10.5, 13-10 Top width - 8-7.5, 8-8, 8-7 Bottom width - 8-7, 8-8, 8-7.5 Depth - 2-0, 1-11.5, 1-10, 1-11, 1 -10.5, 1-11.75, 1-11

3773


Where are log and trace files located?

315


what are the w3c specifications for xml?

863




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 (58)
  • 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)