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 8731

Main diff between varray and nested tablea

3 9975

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

2559

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

6 19854

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

4 18131

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 8886

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 8310

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

1 8782

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

4 10729

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 5635

Difference between global and parameter variables?

1972

What is extent clause in table space?

1 3644

What is the use of time stamp in select statement?

1 3857

Which data type doesn't allow null data type?

6 9457

Post New TCS SQL PLSQL Interview Questions

TCS SQL PLSQL Interview Questions

TCS SQL PLSQL Interview Questions (108)

Un-Answered Questions

Where’s database data actually stored?

976

For the following COBOL code, draw the Binary tree? 01 STUDENT_REC. 02 NAME. 03 FIRST_NAME PIC X(10). 03 LAST_NAME PIC X(10). 02 YEAR_OF_STUDY. 03 FIRST_SEM PIC XX. 03 SECOND_SEM PIC XX.

1304

What is a controller's job?

853

how to calculate the capacitor to maintain power factor?

2169

How to repair a corrupt firebird database?

1069

How do you update a table list?

569

What are encapsulation, inheritance and polymorphism?

1025

Explain what are extracts?

1102

What is use of except clause? How it differs from not in clause?

1022

How do you type in excel without deleting?

761

What is tracing?

1139

What is a server in computer terms?

948

suppose I have to take full backup on friday and then friday to thursday incremental and then full backup?

885

How can a user increase the number of pseudo-ttys? what is their use?

990

How to Calibrate Mass Flow transmitter in field

1204