TCS SQL PLSQL Interview Questions Answers, TCS Placement Papers, TCS Technical, HR Interview Questions, TCS Aptitude Test Questions, TCS Campus Placements Exam Questions

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 8847

Main diff between varray and nested tablea

3 10183

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

1 2626

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

6 20167

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

4 18352

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 9041

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 8525

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

1 8875

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

4 10919

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

1 3522

How did you export data from database to excel file.

1 5736

Difference between global and parameter variables?

1 2040

What is extent clause in table space?

1 3769

What is the use of time stamp in select statement?

1 3959

Which data type doesn't allow null data type?

6 9681

Post New TCS SQL PLSQL Interview Questions

TCS SQL PLSQL Interview Questions

TCS SQL PLSQL Interview Questions (108)

Un-Answered Questions

How many successful erp installations have you performed?

1101

pls send me the e-book for verbal and non verbal reasoning of R S aggarwall

2301

Have you completed the cps exam? Which one?

1036

Hi i am attended catholic Syrian bank preliminary interview for MBA Specialist office post..if anybody selected pls tel me ur final round interview experience

2551

Tell us the current Repo Rate and Reverse Repo Rate?

1182

sir, give me placement papers and interview quistion of birla group company of copper.

2909

Explain how RDDs work with Scala in Spark

378

Can anyone please send me solution document for US payroll . My mail id is rishisharma29@rediffmail.com. Thanks

2543

How can I extract the formated word(bold,italic,underline,font,color etc) from the msword file.?

1102

present salary with all benefits (ctc) please give breakup it possible ?

2593

i am an i.t.i holder in electronics i need those questions and their which have been asked in aircraft company for the post of technician

5463

hi i would like to know is there any training institue for Calabash,robotium and ui automator in hyderabad...urgent

3134

Draw a simple diagram of PeopleSoft three tire architecture?

1425

Who is the Governor of Reserve bank of India (RBI)?

1132

tell something about latest public sector bank in india.

1135