Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 6776

Main diff between varray and nested tablea

3 7604

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

1719

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

6 15320

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

4 13619





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 6665

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 5757

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

1 7421

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

4 8030

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

1 2164

How did you export data from database to excel file.

1 3855

Difference between global and parameter variables?

1085

What is extent clause in table space?

1 2104

What is the use of time stamp in select statement?

1 2399

Which data type doesn't allow null data type?

6 5934

Post New TCS SQL PLSQL Interview Questions




TCS SQL PLSQL Interview Questions


Un-Answered Questions

Does QTP run in any environment?

289


What is progress actional?

217


'Cannot Load IDAPI Service Library' error. What does this error mean?

1038


If a success factor is changed during the year how do you know what you will be reviewed against at the next pdr?

1


I am using vm ware In my system and I am using 2003server in vm ware ( my o.s is XP ) Now I would like to install .zip in my 2003server machine .how can I do this

1317






Define CRR? What is the current CRR?

301


What is expandoobject in c#?

200


OUR BOOKS & ITR MISMATCH FOR RS.15000/- ON ACCOUNTS OF TDS ON RECIEPTS FY-09-10 . KINDY GIVE CORRECTION ENTRY TO MATCH THE BOOKS WITHI ITR. DEVENDRASINGH086@GMAIL.COM

1122


Does wordpress require coding?

32


Explain class invariant.

261


How can you create a decorator in angular?

202


What are arguments in UiPath?

74


Is there a benchmarking tool to fine tune erp performance?

238


What is the www?

1


What are extraneous variables examples?

207