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 7738

Main diff between varray and nested tablea

 3 8519

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

 2056

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

 6 17722

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

 4 16036

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 7579

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 7003

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

 1 8043

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

 4 9215

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

 1 2751

How did you export data from database to excel file.

 1 4628

Difference between global and parameter variables?

 1448

What is extent clause in table space?

 1 2761

What is the use of time stamp in select statement?

 1 3035

Which data type doesn't allow null data type?

 6 7519

Post New TCS SQL PLSQL Interview Questions


TCS SQL PLSQL Interview Questions


Un-Answered Questions

could an induction motor be used for regenerative braking in electric-train control? in this type of application would some scheme have to be devised to obtain low synchronous speeds while braking? would induction-motor drive, therefore, be suitable for passenger service?

1582

Why are web services so fashionable?

375

What is the function of model attribute annotation?

160

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

507

Define connull()?

5




Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

496

What is node js used for?

244

How do you prevent the creation of a session in a jsp page and why? What is the difference between include directive & jsp:include action?

555

How to change from development mode to production mode in weblogic 10.3?

575

what are the new rules of central excise ?

1429

Can kotlin code be executed without jvm?

115

Explain the different steps that are involved in final inspection process?

503

what is vibration a part of proceess variable? if vibration is a part variables then how we minimize the actual vibration on machine on load,? vision of instrumentation contrl plz ans me IPGDL interview question

1505

What is machine learning example?

46

How to migrate the on-prem servers to azure?

247