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 (1111)
  • Cap Gemini placement papers (1)
  • Cap Gemini technical test questions (47)



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 31122

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

5 11807

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

7 10681

How will you delete a particular row from a Table?

7 9872

What is the difference between the Primary and Foreign key?

7 10556





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

29 21167

What is nvl function?

4 7905

what is 'force view'?

3 11127

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 12531

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

1 7284

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 12196

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

6 12988

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

4 11387

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 6183

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

2 4457

Post New Cap Gemini SQL PLSQL Interview Questions



Un-Answered Questions

Can u describe what kind of testing are for OTC derivates by banks.

883


___ VB constant make the menu item in centre.

553


what is sil (safety integrity level

1041


What is overflow and how it's happen

789


what is the meaning of neutral displacement ???

1435






how to write test cases in interview exam like one website it contain a/c # text box, current bill amount text box,sms offer,calling offer,internet these 3 are list boxes and remindmelater,continue these 2 are buttons. and qu is like 1.user doesn't have any dues from past 90 days,2.whose bill amount >= rs2000 from past 6 months. use this 2qu write testcases.

1283


What are all present producing cost of Per KWH of various Fuel?

1323


Describe a marketing plan you developed. What was the result of implementing that plan?

410


Could somone help to get the detailed notes for telecom testing.please contact me on ani.bhardwaj@rediffmail.com

961


what is the physical connection of a analog i/p to a analog i/p module (ab plc)and through a analog o/p module(ab plc) to a analog o/p . and how all the process control by scada

744


Where does Parallel flow heat exchanger use?

861


Your grandfather is 75 years old. He has total savings of Rs.80,000. He expects that he live for another 10 years and will like to spend his savings by then. He places his savings into a bank account earning 10 per cent annually. He will draw equal amount each year- the first withdrawal occurring one year from now in such a way that his account balance becomes zero at the end of 10 years. How much will be his annual withdrawal?

704


how sales invoices adjusted against advance received from Debtor?

740


witch is the best insistute in sharpoint course.what abt future of share point course.

1242


What is Merge Conflicts?

320






Cap Gemini SQL PLSQL Interview Questions
  • Software (1)
  • 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 (2)
  • Solaris AllOther (3)
  • Operating Systems General Concepts (1)
  • WinRunner (1)
  • Load Runner (3)
  • QTP (40)
  • Test Director (1)
  • Selenium (1)
  • Automation Testing AllOther (1)
  • Manual Testing (84)
  • QA Concepts (15)
  • Mobile Testing (1)
  • Test Cases (7)
  • Test Documents Reporting (1)
  • Testing AllOther (19)
  • COBOL (21)
  • JCL (16)
  • CICS (14)
  • DB2 (31)
  • 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 (9)
  • Business Objects (18)
  • Cognos (24)
  • Informatica (67)
  • Ab Initio (2)
  • Data Stage (20)
  • SAS (3)
  • ETL (4)
  • Data Warehouse General (2)
  • HR Questions (5)
  • WiFi Security (1)
  • SAP Basis (27)
  • SAP ABAP (110)
  • SAPScript (3)
  • SAP SD (96)
  • SAP MM (21)
  • SAP PP (2)
  • SAP FI CO (66)
  • SAP HR (27)
  • SAP CRM (55)
  • SAP APO (1)
  • SAP Business Warehouse (9)
  • SAP Security (24)
  • SAP Netweaver (1)
  • 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 (19)
  • Oracle Apps Manufacturing (1)
  • Oracle Apps HRMS (1)
  • Oracle Apps SCM (6)
  • WebMethods (10)
  • TIBCO (1)
  • Mechanical Engineering (2)
  • Electrical Engineering (4)
  • Electronics Communications (2)
  • Engineering AllOther (3)
  • Marketing Sales (2)
  • Banking Finance (3)
  • Audit (2)
  • Taxation (3)
  • Accounting General (15)
  • Accounting AllOther (15)
  • Call Centre AllOther (3)
  • BSRB AllOther (1)
  • Law AllOther (1)
  • Everything Else AllOther (1)
  • English (2)
  • General Aptitude (24)
  • Placement Papers (1)
  • CCNA (1)
  • Sun Certifications (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)