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 5960

Main diff between varray and nested tablea

3 6502

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

1389

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

6 13457

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

4 11808





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 5776

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 4809

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

1 6841

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

3 6644

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

1 1480

How did you export data from database to excel file.

1 3205

Difference between global and parameter variables?

756

What is extent clause in table space?

1 1365

What is the use of time stamp in select statement?

1 1814

Which data type doesn't allow null data type?

6 4576

Post New TCS SQL PLSQL Interview Questions



Un-Answered Questions

How RAL(Rotary air lock)works in cement industry?

1140


How you will determine the volume of oil in a particular Distribution transformer.

724


can anyone help me with some suggestions and improvemnts for sage line 50?

1503


Which will have more strain energy 1.Spring 2.Circular disc 3.Solid square plate.

1074


pls give me some basic informations in construction of a structure?

903






Is there any standard guidelines/Criteria to design NGR/NGT.?

1666


I have given the protocol for the cyclodextrin glygosyl transferase assay: One ml of appropriately diluted enzyme sample was incubated at 60 °C for 15 min with 5 ml of 1% (w/v) gelatinized soluble starch in 50 mM, 7.0-pH Tris–HCl buffer. Reaction was terminated by boiling the reaction mixture for 3 min and reaction volume was made to 10 ml with distilled water. Two ml of above reaction mixture was withdrawn and mixed with 3 ml of Tris–HCl buffer, 5 ml of 125 mM Na2CO3, and 0.5 ml of phenolphthalein (25 mg phenolphthalein/100 ml absolute alcohol). Absorbance was measured at 550 nm. The percent decrease of sample was calculated with respect to control containing 5 ml of buffer, 5 ml of sodium carbonate and 0.5 ml of phenolphthalein. where Acontrol = absorbance of control and Atest = absorbance of sample. The amount of β-cyclodextrin (β-CD) produced was estimated from the standard graph of 0–500 μg/ml β-CD concentration against % decrease in absorbance. One unit of CGTase was defined as the amount of enzyme required to produce 1 μm of β-CD/min. Please can you suggest me the formula for the defination given in the last line

996


Trouble4 shooting , handiling issues with different level of priorties

923


Could you plz tell me in detail and with proper example that what is ROI and explain me with proper example that how will you calculate ROI of a distributor?with Example and Calculation.

1075


"WHERE THERE IS A RIGHT, THERE IS REMEDY" EXPLAIN THIS WITH REFERENCE TO BREACH OF CONTRACT.

1072


What is a bag in Pig Latin?

113


can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

732


I have 2 KW electric water heater.I am gonna use it in controlling water temp.so I needed to increase or decrease the heating capacity.is there any electrical-electronic circuit for varying the resistance & so current?

1644


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

1212


Have you ever committed a mistake at work?

2071






TCS SQL PLSQL Interview Questions
  • Software (1)
  • C (271)
  • STL (1)
  • OOPS (58)
  • 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 (8)
  • Visual Basic (14)
  • C Sharp (66)
  • ASP.NET (105)
  • VB.NET (9)
  • ADO.NET (19)
  • IIS (13)
  • Dot Net Framework (16)
  • Dot Net Remoting (10)
  • Dot Net WindowsForms (1)
  • Dot Net General (25)
  • Dot Net AllOther (6)
  • Exchange Server (2)
  • 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 (15)
  • 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 (158)
  • 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 (80)
  • 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)
  • Digital Certificates (1)
  • Encryption Decryption (1)
  • 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)
  • 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 (137)
  • 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 (282)
  • 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)