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 8723

Main diff between varray and nested tablea

3 9962

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

2555

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

6 19840

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

4 18113

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 8876

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 8289

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

1 8775

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

4 10718

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

1 3419

How did you export data from database to excel file.

1 5628

Difference between global and parameter variables?

1966

What is extent clause in table space?

1 3637

What is the use of time stamp in select statement?

1 3853

Which data type doesn't allow null data type?

6 9440

Post New TCS SQL PLSQL Interview Questions

TCS SQL PLSQL Interview Questions

TCS SQL PLSQL Interview Questions (108)

Un-Answered Questions

What do you understand by connector? Explain connector architecture.

913

What is petroleum?

789

Which kind of application when creating with sencha touch?

936

Will upgrading from windows 7 to windows 10 delete everything?

833

Explain value expression and method expressions?

What is lookup override?

1040

What is a profit sharing plan?

1038

What are the various files that are created when you create a django project? Explain briefly.

575

What is match code? : sap abap hr

1216

What is meant by hide area?

1140

shares journal entries

2032

Differentiate call by value and call by reference?

973

under the modified cash basis of accounting, most revenues and expenses are recognized on the cash basis. Which one of the following items is an EXCEPTION to this accounting practice? a.Advertising b.Professional Fees. c.Supplies d.Rent

2122

CAN CU XLPE/PVC CABLE BE USED INPLACE OF LOW NOISE SCREENED CABLE? KINDLY GIVE REASONS

1880

How data flows from sd to copa? : co-pa

1617