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 (80)
  • Cap Gemini interview questions (1128)
  • 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 32803

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

5 12314

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

7 11229

How will you delete a particular row from a Table?

7 10330

What is the difference between the Primary and Foreign key?

7 10951





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

29 22191

What is nvl function?

4 8445

what is 'force view'?

3 11852

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 13182

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

1 7740

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 12821

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

6 13679

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

4 12101

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 6578

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

2 4840

Post New Cap Gemini SQL PLSQL Interview Questions



Un-Answered Questions

how water proof chemicals act in concrete to avoid leek?

1066


Can we use a absolute encoder to show rpm of a motor ? what about the condition when power is off ? what is difference if a incremental one is used ?abanirout@gmail.com

941


i have chines vehicle Grand Tiger now its AC compressor become jam what should i do i have not found new in market

1323


I want to JCL sort for Non-COMP and COMP-3 fields SORT FIELDS=(1,5,A,6,11,A,12,11,A,19,1,A,20,1,A),FORMAT=BI,EQUALS Length of comp bytes is 11 bytes which start at 6byte and 12 byte considering 11 bytes in comp-3 is 6 bytes. Can anyone tell if the above sort work SORT FIELDS=(1,5,A,6,6,A,12,6,A,19,1,A,20,1,A),FORMAT=BI,EQUALS does not works OK

789


according to the painting co efficient, we should take the one side of doors (or) windows or both sides?

653






What errors and types of errors you faced in Cognos ReportNet?

2488


our industries ht line so power fluctation(once drop of power please rectify causes

871


How to explain Software Bank Loan descriptions

1298


What are the major Challenges being faced in the Banking sector?

2


Which ‘meta box’ is not hidden by default on Post and Page screens?

1


Why we use duplex coil and hook switch in telephone system?

3510


What are the services in RMI ?

1256


What is a decision tree? When would you want to use one? What are its performance characteristics? How can you generate a decision tree automatically from a pre-existing data set? Is it feasible to do this at runtime, and has it been done in a commercial game before? When and why would you want to do this, and how would the data need to be organized to make this possible?

477


How do WinMain look like ?

1404


what will happen if dc is supplied in acb or mccb or other circuit breakers?

425






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 (2)
  • Visual Basic (1)
  • C Sharp (1)
  • ASP.NET (9)
  • ADO.NET (1)
  • 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 (19)
  • 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 (68)
  • Ab Initio (2)
  • Data Stage (20)
  • SAS (3)
  • ETL (4)
  • Data Warehouse General (2)
  • HR Questions (10)
  • WiFi Security (1)
  • SAP Basis (27)
  • SAP ABAP (110)
  • SAPScript (3)
  • SAP SD (97)
  • SAP MM (22)
  • SAP PP (2)
  • SAP FI CO (67)
  • 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 (4)
  • BSRB AllOther (1)
  • Law AllOther (1)
  • Everything Else AllOther (1)
  • English (2)
  • General Aptitude (73)
  • 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)