Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

 3 5914

How to count the no of records of a table without using COUNT function?

 11 21739

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?

 4 17345

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

 9 7084

What is the difference between UNIQUE KEY and UNIQUE INDEX?

 3 6793




What is the differnce between view and materialized view

 4 6676

What is dynamic SQl and how you will create and execute dynamic sql?

 2 5654

Query for second maximum salary in each in each department

 15 31686

query to retrive the employees whose sal is greater than avg sal

 10 10581

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

13 16755

select sal from emp group by sal

 3 4428

counting the no.of characters occurs in a string by using pl/sql function

 1 4945

What is the relation b/w view and trigger

 3 12731

how to create temparary sequence

2 6143

What is the Difference between Procedure and Function.Can we call a Function in a DML?

 2 6454

Post New TCS SQL PLSQL Interview Questions




TCS SQL PLSQL Interview Questions


Un-Answered Questions

Is scala better than python?

1

How do u determine,what to be tested?

1365

Sir,In our company there are 3 caterpillar make(capacity:(1) 3.3KV,2.5MW(2)3.3KV,2.5MW & (3)3.3KV,1.9MW) & 1 deutz make (capacity:11KV,3.8MW)gas engines utilised,all are running in paralell. There are three transformer utilised,(1) 6.25MVA,3.3KV/22KV,Impedence voltage:6.7% used for two generator,both are 2.5MW(2)5.5MVA,3.3KV/22KV,Impedence voltage:7.2% used for one generator of 2.5MW & (3) 5.5MVA,11KV/22KV,Impedence voltage:7.8% used for one generator of 2.5MW.all generator breakers capacity of 1250Amps. Sir,I want the details of fault level calculation of generator,transformer individually & for whole system. If you require any information from me.feel free for contact me sir.pl.send the answer of my question as the earliest as possible.

1407

What is formula in ms excel?

164

Specify the port number for http?

28




Do you know what is linear search?

317

What do you understand by server-side validation?

308

What is intact assay method development.....?

1700

Which iodine compounds are used in antiseptics?

382

What is web framework in python?

94

What is pivot in c?

333

what steps have you taken to make sure you perform well in the new field you wish to study ?

1315

What Is The Purpose Of The "n" In The Following Calculation Specification?

392

how can we calculate steel value, depending on load

1467

What are the three edit interactions options of a visual tile in power bi desktop?

1