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 7676

Main diff between varray and nested tablea

3 8484

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

2042

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

6 17618

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

4 15967

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 7546

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 6914

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

1 8027

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

4 9169

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

1 2721

How did you export data from database to excel file.

1 4608

Difference between global and parameter variables?

1422

What is extent clause in table space?

1 2732

What is the use of time stamp in select statement?

1 3007

Which data type doesn't allow null data type?

6 7446

Post New TCS SQL PLSQL Interview Questions


TCS SQL PLSQL Interview Questions


Un-Answered Questions

I customized the tax procedures, after posting normal g&l (f-02), i got an error, error is complete lineitem display, its popup error message num, how can i find the message error, whats the t-code

1647


Can a constructor be protected?

508


What is cell value?

312


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1529


Explain what is a flask? What are its benefits?

438






Share your views on Small and Medium Enterprises?

559


What is a table alias in obiee 11g? Where and how will you create it?

491


Define standalone rowset?

386


What is pre increment and post increment in java?

481


What are examples of independent and dependent variables?

477


What is the usage of switch statement in swift language?

480


Expand s3?

96


How can you one hot encoding in tensorflow ?

5


What are the most used sensors types in IOT?

5


How does a project manager can avoid the above given ten points for the success of project.

466