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




TCS SQL PLSQL Interview Questions
Questions Answers Views Company eMail

A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.

2 6069

Main diff between varray and nested tablea

3 6597

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

1423

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

6 13678

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

4 12100





we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?

3 5863

i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.

4 4898

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

1 6921

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

4 6839

Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

1 1559

How did you export data from database to excel file.

1 3314

Difference between global and parameter variables?

785

What is extent clause in table space?

1 1461

What is the use of time stamp in select statement?

1 1866

Which data type doesn't allow null data type?

6 4700

Post New TCS SQL PLSQL Interview Questions



Un-Answered Questions

Hi Friends, This is Chennamsubbaraidu.i Have 2+ Years Realtime Exp in Manual Testing.Am Looking to Shift From My Present Company.Please if u Have Any Openings in Your Company's, Please Let Me Know.Any Location Prefer.Thanks.

695


how to include timer or counting time to display next page in asp.net

1052


could u plz send me a sample placement paper for hpcl trainee engg exam..(electronics& telecommunication stream)...thnku deepikameena1@gmail.com

818


what is high cardinality tell me brief

491


What is the difference between earthing,ground&nutral?

4178






Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.

4191


what are the responsibilities for QA tester to test application on UNIX environment??? what skills required for unix???

879


Explain how the lubricating oil circulates in a diesel engine.

711


which metal is use in shunt

3331


hai i am mca 2009 fresher.please tell me which certification helps me to get an IT job faster which institute is good in hyderabad.please mail me to prasanna.1856@rediff.com

918


Why do you want to work at Accenture?

4


What are Odm Commands.

4


Can I mix wireless equipments from different vendors, elaborate on it? 

643


What is the interaction between overtime and compensatory time?

1


What will be the cause of the loose compression in a cylinder?

1617






TCS SQL PLSQL Interview Questions
  • Software (1)
  • C (274)
  • STL (1)
  • OOPS (59)
  • C++ General (41)
  • MFC (10)
  • ATL (2)
  • COM DCOM (2)
  • VC++ AllOther (3)
  • PHP (25)
  • Programming Languages AllOther (36)
  • ASP (12)
  • CGI Perl (4)
  • JavaScript (16)
  • VB Script (17)
  • JSP (9)
  • Shell Script (6)
  • Ruby on Rails (2)
  • AngularJS (1)
  • Scripts AllOther (1)
  • SNMP (2)
  • TCP IP (10)
  • Protocols AllOther (11)
  • Networking Administration (19)
  • Networking Security (1)
  • Networking AllOther (9)
  • Visual Basic (14)
  • C Sharp (67)
  • ASP.NET (106)
  • VB.NET (9)
  • ADO.NET (20)
  • IIS (13)
  • Dot Net Framework (16)
  • Dot Net Remoting (10)
  • Dot Net WindowsForms (1)
  • Dot Net General (29)
  • Dot Net AllOther (6)
  • Exchange Server (2)
  • SharePoint (10)
  • WCF (2)
  • Microsoft Related AllOther (2)
  • Oracle General (51)
  • Architecture (4)
  • Database Management (9)
  • Forms Reports (9)
  • Oracle AllOther (9)
  • SQL Server (75)
  • MySQL (5)
  • Sybase (1)
  • DB Administration (11)
  • DB Development (3)
  • SQL PLSQL (108)
  • Databases AllOther (11)
  • SDK (4)
  • Windows Threads (1)
  • Windows General (1)
  • Windows AllOther (10)
  • Linux Commands (5)
  • Linux IPC (1)
  • Linux Socket Programming (1)
  • Linux System Calls (1)
  • Linux General (5)
  • Linux AllOther (2)
  • Unix Commands (16)
  • Unix Threads (2)
  • Unix IPC (1)
  • Unix General (3)
  • Unix AllOther (15)
  • Solaris Commands (5)
  • Solaris General (3)
  • Solaris AllOther (9)
  • RTOS AllOther (2)
  • Operating Systems General Concepts (15)
  • Data Structures (16)
  • Operating Systems AllOther (5)
  • WinRunner (11)
  • Load Runner (36)
  • QTP (169)
  • Test Director (8)
  • Rational TestSuite (2)
  • Silk Test (1)
  • Automation Testing AllOther (15)
  • Manual Testing (262)
  • QA Concepts (22)
  • Mobile Testing (4)
  • Test Cases (32)
  • Test Documents Reporting (3)
  • Testing AllOther (61)
  • Tomcat (1)
  • Apache (1)
  • Servers AllOther (4)
  • COBOL (118)
  • JCL (53)
  • CICS (11)
  • DB2 (32)
  • IMS (2)
  • IDMS (1)
  • Natural (4)
  • ADABAS (2)
  • REXX (1)
  • Assembler (2)
  • QMF (1)
  • MVS (1)
  • OS390 (1)
  • VSAM (8)
  • Sysplex (1)
  • IBM MainFrame AllOther (6)
  • RPG400 (28)
  • COBOL400 (2)
  • DB400 (4)
  • COOLPLEX (1)
  • IBM AS400 AllOther (8)
  • Core Java (159)
  • Advanced Java (20)
  • Swing (5)
  • EJB (4)
  • Servlets (20)
  • Struts (31)
  • JDBC (11)
  • SunOne (1)
  • J2EE (7)
  • Weblogic (28)
  • Java Networking (2)
  • Java J2EE AllOther (3)
  • J2ME (3)
  • Java Related AllOther (8)
  • Orbix (1)
  • MQSeries (1)
  • Middleware AllOther (2)
  • HTML DHTML (2)
  • XML XSLT RSS (1)
  • SOAP (3)
  • Web Related AllOther (2)
  • Teradata (23)
  • Business Objects (129)
  • Cognos (83)
  • Informatica (273)
  • Actuate (5)
  • Ab Initio (17)
  • Data Stage (90)
  • SAS (38)
  • Micro Strategy (5)
  • ETL (6)
  • Data Warehouse General (22)
  • HR Questions (117)
  • Design Patterns (5)
  • UML (6)
  • OOAD (3)
  • Software Design Tools (1)
  • Requirements Management (2)
  • Project Planning (1)
  • Project Management (3)
  • Software Design AllOther (1)
  • CTC (1)
  • Debugging AllOther (1)
  • Clear Case (2)
  • Version Control AllOther (1)
  • Telecom Routers Switches (2)
  • Telecom Protocols (1)
  • VoIP IP Telephony (1)
  • GSM (2)
  • BlueTooth (2)
  • Telecom General (4)
  • SAP Basis (55)
  • SAP ABAP (165)
  • SAPScript (9)
  • SAP SD (126)
  • SAP MM (23)
  • SAP QM (1)
  • SAP PP (7)
  • SAP PM (2)
  • SAP PS (1)
  • SAP FI CO (111)
  • SAP HR (55)
  • SAP CRM (67)
  • SAP SRM (1)
  • SAP APO (1)
  • SAP Business Warehouse (48)
  • SAP Security (30)
  • SAP Netweaver (1)
  • SAP ALE IDocs (7)
  • SAP B1 (9)
  • SAP Business Objects BO BOBJ (1)
  • SAP AllOther (3)
  • Siebel (10)
  • ERP General (2)
  • Oracle Apps Technical (49)
  • Oracle Apps Financial (68)
  • Oracle Apps Manufacturing (3)
  • Oracle Apps HRMS (3)
  • Oracle Apps SCM (5)
  • 86 Family (3)
  • VLSI (1)
  • Embedded Systems AllOther (2)
  • Client Server Architecture (1)
  • Client Server General (3)
  • Client Server AllOther (2)
  • AI Algorithms (1)
  • AI Neural Networks (1)
  • AI AllOther (1)
  • Cryptography Algorithms (13)
  • Digital Certificates (2)
  • Encryption Decryption (7)
  • Cryptography Protocols (1)
  • Cryptography General (58)
  • WebMethods (17)
  • TIBCO (8)
  • EAI AllOther (1)
  • 3D Animation (2)
  • Requirement Management (4)
  • Estimation Analysis (1)
  • Software Quality Analysis (3)
  • Change Request Management (1)
  • Quality Analysis (3)
  • Program Management (2)
  • Configuration Management (1)
  • Cloud Computing General (1)
  • Micro Biology (1)
  • Bio Technology (1)
  • Bio Informatics (2)
  • Botany (1)
  • Nuclear Physics (1)
  • Organic Chemistry (1)
  • General Chemistry (2)
  • Chemistry AllOther (1)
  • Pharmacy (1)
  • Health Pharma AllOther (1)
  • Cardiology (1)
  • Mathematics (1)
  • General Science (2)
  • Sciences AllOther (3)
  • Civil Engineering (16)
  • Mechanical Engineering (34)
  • Electrical Engineering (138)
  • Electronics Communications (137)
  • Chemical Engineering (3)
  • Aeronautical Engineering (1)
  • Industrial Engineering (4)
  • Instrumentation (12)
  • Automobile Engineering (1)
  • Power Plant Engineering (1)
  • Engineering AllOther (70)
  • Business Administration (8)
  • Marketing Sales (18)
  • Banking Finance (22)
  • Human Resources (31)
  • Personnel Management (1)
  • Industrial Management (2)
  • IT Management (2)
  • Non Technical (5)
  • Business Management AllOther (4)
  • Audit (6)
  • CompanyAffairs CS (2)
  • Taxation (35)
  • Accounting General (37)
  • Accounting AllOther (45)
  • Advertising Media AllOther (1)
  • Call Centre AllOther (80)
  • Fashion Modelling AllOther (1)
  • UPSC General Studies (3)
  • UPSC AllOther (5)
  • SSC Political Science (1)
  • SSC General Science (1)
  • SSC General Studies (4)
  • SSC AllOther (1)
  • RRB (3)
  • CDS (2)
  • NDA (2)
  • POs (2)
  • BSRB Clerical (5)
  • BSRB AllOther (1)
  • Group I (5)
  • Group II History (1)
  • Group II AllOther (2)
  • APPSC AllOther (14)
  • General Knowledge_Current Affairs (47)
  • Government AllOther (7)
  • Law AllOther (5)
  • Tourism Hotel AllOther (1)
  • Funny Interview Questions (5)
  • Everything Else AllOther (14)
  • English (21)
  • General Aptitude (303)
  • Puzzles (41)
  • Placement Papers (67)
  • CCNA (14)
  • Microsoft Certifications (13)
  • Sun Certifications (3)
  • Oracle Certifications (3)
  • ISTQB Certification (2)
  • Certifications AllOther (8)
  • H1B Visa (18)
  • USA Student Visa F1 Visa (6)
  • L1 Visa (17)
  • USA Visitor Visa B2 Visa (1)
  • USA Business Visa B1 Visa (2)
  • USA Dependent Visa H4 Visa (3)
  • UK Visa (5)
  • Germany Visa (1)
  • C Code (20)
  • C++ Code (8)
  • J2SE Code (2)
  • J2EE Code (2)
  • ASP.NET Code (7)
  • VB.NET Code (1)
  • C Sharp Code (2)
  • PHP Code (2)
  • JavaScript Code (7)
  • GATE (7)
  • CAT (2)
  • MAT (1)
  • GMAT (4)
  • OPENMAT (4)
  • C C++ Errors (6)
  • DotNet Errors (2)
  • Oracle Errors (10)
  • SQLServer Errors (4)
  • Scripts Errors (4)