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 (1058)
  • 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 24510

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

5 9843

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

7 8317

How will you delete a particular row from a Table?

7 7661

What is the difference between the Primary and Foreign key?

7 8658

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

28 18081

What is nvl function?

4 5966

what is 'force view'?

3 8918

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 9931

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

1 5702

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 9671

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

5 10325

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

4 8920

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 4569

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

2 2803

Post New Cap Gemini SQL PLSQL Interview Questions




Un-Answered Questions

How would you finalize on testcases in estimation? Say you have 200 requirements. How would you come up how many testcases you are going to write for each requirements?

375


Describe the cell- membrane protein extraction ?

656


please please give me some banking calculations in framework manager.

664


does a b.tech civil engineer fresher supposed to know how to design rcc structure?

1816


I Have 3 Phase 10 KW AC Alternator i found one phase weak, so what will be the reason & what action shouls i take to rectify the same.

503


What changes does a control need to run in an MFC 4.2b container?

964


What should be the overcurrent, instantaneous overcurrent, short cicuit current settings (i.e. how many times of motor full load and what is the time duration) for a motor?

494


What are the objects that support variables?

612


# 4 hi friends i m from electrical branch and seeking for tech. + apti. both papers of hpcl plz get it available as soon as possible my email id is sumit_lig189@yahoo.co.in

610


In a concrete grade C35A, C & A stands for what and equalent cube strength?

316


i want to find out iffco get test paper

9429


What is expression parser in c++

702


Can you delink a payer from a bill to sold to ship to and then create a new payer on the existing bill to sold to ship to, this is where a pub or club changes licencees and we want to icolate the debt from the old owner but keep the sales history on the ship to/sold to

506


Give the coding for system reboot in C

490


what is the proper location of sample point for sphere tank?

482




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 (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 (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 (10)
  • TIBCO (1)
  • Mechanical Engineering (2)
  • Electrical Engineering (4)
  • Electronics Communications (2)
  • Engineering AllOther (2)
  • Marketing Sales (2)
  • Finance (3)
  • Audit (2)
  • Taxation (3)
  • Accounting General (8)
  • Accounting AllOther (14)
  • 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)