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



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 28914

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

5 11125

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

7 9809

How will you delete a particular row from a Table?

7 9087

What is the difference between the Primary and Foreign key?

7 9859





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

29 20119

What is nvl function?

4 7194

what is 'force view'?

3 10198

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 11642

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

1 6757

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 11388

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

6 12066

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

4 10571

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 5597

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

2 3882

Post New Cap Gemini SQL PLSQL Interview Questions




Un-Answered Questions

how is the examination pattern?

784


what is cohensive testing and span control?

1075


What are the limitations of Kirchoff's laws?

206


Hai friends, Can someone guide me..Am a postgraduate(m.tech) in biotechnology and am thinking of doing pg diploma course through distance mode. are they worth doing? if so which is better pg diploma in bioinfo or pg diploma in Intellectual property rights..am awaiting ur suggestions

858


How can we expand Parameter Form Canvas on Reports 6i?

1174






Hello seniors m an engineering student in 3rd yr..i want to know what are the software course in electrical field?i wanted to do certification course but i dont know much about the course?..Regards

813


Explain reference cursor?

942


hi i am electronics & telecomm engg & appling 4 the AAI jr executive (electronics/ATC) written test. pls forward me the syllabus & old question papers.I will be very much thankful to you. pis inform to mpnisi@gmail.com

667


Is there any Electrical supervisor license which gives permit to work whole India rather than individual state??

545


what is your experience with focus groups?

866


Have you used the sort in your project?for this type of questions any working on real time project give the eg. with real time scenario.

1130


can any one know is sbi interview based on merit or based on roll number

621


A man is travelling with the speed of 10m/min across the river to the opposite bank.The river water flows at the speed of 1m/s.Since the water flows at the speed higher than the boatsman, he would definitley reach the opposite river bank in a slant path.What is the length of the path he travelled?. The river is 10m wide. Please give me solution to tha above probelm. Thanks in advance

825


plz explain abt refrigeration r22 bitzer comprassors trouble shooting and maintenance

542


What is the circulation of I.O. pump of diesel engine?

701






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 (3)
  • QTP (40)
  • Test Director (1)
  • Selenium (1)
  • Automation Testing AllOther (1)
  • Manual Testing (83)
  • 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 (17)
  • Cognos (24)
  • Informatica (67)
  • Ab Initio (2)
  • Data Stage (19)
  • SAS (3)
  • ETL (4)
  • Data Warehouse General (2)
  • HR Questions (5)
  • WiFi Security (1)
  • SAP Basis (27)
  • SAP ABAP (108)
  • SAPScript (3)
  • SAP SD (96)
  • SAP MM (16)
  • SAP PP (2)
  • SAP FI CO (63)
  • 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 (18)
  • 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 (14)
  • 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)