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 8726

Main diff between varray and nested tablea

3 9971

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

2557

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

6 19852

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

4 18120

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 8881

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 8304

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

1 8778

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

4 10727

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

1 3424

How did you export data from database to excel file.

1 5631

Difference between global and parameter variables?

1970

What is extent clause in table space?

1 3639

What is the use of time stamp in select statement?

1 3853

Which data type doesn't allow null data type?

6 9452

Post New TCS SQL PLSQL Interview Questions

TCS SQL PLSQL Interview Questions

TCS SQL PLSQL Interview Questions (108)

Un-Answered Questions

What kind of training or qualifications do you have? : insurance sales

577

Explain about cursors?

1090

How b/w chaining process works in Pega ?

668

What is cementation stage?

869

The application of the should retrieve data from your user’s mobile every five minutes and also the data keep in dynamodb, later on, a daily basis at a specific time the data is extracted into s3 on a per-user basis then your application is later wont to visualize the data to the user. The user is asked to optimize the design of the backend system to lower price, what would you recommend?

231

Difference between Plug-in Vs Workflow?

642

Is html extensible?

827

Explain about the replication and multiplexing selectors in Flume?

100

What is not equal in sql?

1129

Is age a discrete variable?

983

Which is the best QTP training institute in Delhi/NCR region and what is the approximate fee for QTP course (Basics and Advanced)

1884

How do I print borders in word 2007?

604

How would you create a factor in r?

How do I truncate all tables in mysql?

985

Why concurrenthashmap is fail safe?

966