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 7772

Main diff between varray and nested tablea

 3 8547

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

 2075

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

 6 17797

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

 4 16146

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 7623

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 7056

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

 1 8057

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

 4 9283

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

 1 2770

How did you export data from database to excel file.

 1 4651

Difference between global and parameter variables?

 1462

What is extent clause in table space?

 1 2785

What is the use of time stamp in select statement?

 1 3059

Which data type doesn't allow null data type?

 6 7563

Post New TCS SQL PLSQL Interview Questions


TCS SQL PLSQL Interview Questions


Un-Answered Questions

What is data type set in python and how to work with it?

448

all question of related to window 2003 server

1995

question related to table havi colspan and row span

1795

What is difference between singleton and static class in c#?

484

What are the advantage of ado.net?

527




WHAT IS DEAD END IN PROTECTION?

2015

What are the five basic elements of a c++ program?

586

What do you understand by schemardd in apache spark rdd?

2182

Explain cashing in asp.net.

530

Plz can any one say me how to get the informatica certification materials and dumps

1602

Does google have a database program?

499

What is a wage type?

601

List the advantages of webdriver over selenium server?

468

Is viewstate secure?

516

Do u know any one? how to find out in motor rated amps? formula?

1546