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



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 27573

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

5 10675

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

7 9245

How will you delete a particular row from a Table?

7 8570

What is the difference between the Primary and Foreign key?

7 9441

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

28 19565

What is nvl function?

4 6796

what is 'force view'?

3 9766

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 11061

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

1 6366

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 10911

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

5 11607

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

4 9998

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 5233

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

2 3474

Post New Cap Gemini SQL PLSQL Interview Questions




Un-Answered Questions

How will format the HDFS ?

47


I am requiering interview questions regarding Close Ferro Crome Furnaces

568


Explain customer Independent requirement .

154


Hi Please tell me about ERP Project how do describe in interview Please tell me details about this project my id is chiku_69@yahoo.in

2192


How we write a java script using RFT for the below scenario iam having dropdown list COUNTRY(it contains india,us,uk...) once we select the india in that list it will open the corresponding states in STATES dropdown list. i would like to change those values dynamically... can u pls send me the coding....

1579


can any body body expalin best definitions & best real time exaples for opps concepts.

894


I am experienced with house and industrial wiring but I don't have any licence how can I apply an licence and which type of licence i can get i didn't complete deee just only experience

327


explain the ISO standard ( more explanation about the ISO

799


Explain the working of 3 bit sliding window protocol with suitable example.

331


From peak purity spectrum, where or at which point peak purity angle & purity threshold is checked?

1071


If not into production, how far did you follow the design and why did not you see it into production?

684


300m long and 30kw inductive loade 3phase supply how many size cable required

54


In order to attract deposits, banks offer various types of products with distinguishing features. As a student of banking law do you observe any challenge/threat from money laundering for banks in this struggle? Discuss

812


Hi Friends, Can you please let me know the difference between user exist and Routines

687


on which date sail exam is held & what the criteria for this exam

605




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 (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 (9)
  • Business Objects (17)
  • Cognos (24)
  • Informatica (65)
  • 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 (107)
  • SAPScript (3)
  • SAP SD (95)
  • 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 (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)