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 (1067)
  • 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 25496

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

5 10125

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

7 8681

How will you delete a particular row from a Table?

7 8002

What is the difference between the Primary and Foreign key?

7 8970

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

28 18711

What is nvl function?

4 6223

what is 'force view'?

3 9198

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 10384

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

1 5937

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 10116

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

5 10689

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

4 9282

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 4868

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

2 3089

Post New Cap Gemini SQL PLSQL Interview Questions




Un-Answered Questions

How to conduct Literature Survey for Generics Development for European Market

729


What is the procedure to take loan

548


how to check which item is sold by the sundry debtors in tally?

493


What are Common values of digital image parameters?

234


What Are The Characteristics Of Modern Accounting?

2496


Why you quite your job in six months??

896


*) Internal review defect gets detected… 1) During peer review. 2) By the own stuff member onsite/offshore. 3) During Informal review process. 4) None of these 5) All of these

830


sir, i am 3 years diploma course pass out candidate.what type of certificate can i got in marine service.

512


who or what in your life would you say influenced you most with regard to your career objectives?

764


explain step by step role design process in sap security

325


Pressure tx shows 1 mbar but we need 1000 mbar at this process condition .. how can we sort it out .

213


Userdone tasks with ffid n system send log reports to controller in his work inbox but whenever its open its showing blank screen, why?

351


details description on this mantis? who is founder of this mantis?

616


i am completed my b.tech EEE in 2009,,,iam trying the job 3+ for AUTO CAD (ELECTRICAL),, what is the market for autocad electrical in hyderabad... how to handle the intervws give some suggestions ?

454


How to find beam R/F cutting length

15




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 (40)
  • 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 (64)
  • 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 (60)
  • SAP HR (27)
  • SAP CRM (55)
  • SAP APO (1)
  • SAP Business Warehouse (9)
  • SAP Security (19)
  • 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 (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 (3)
  • Marketing Sales (2)
  • Finance (3)
  • Audit (2)
  • Taxation (3)
  • Accounting General (10)
  • Accounting AllOther (15)
  • 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)