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 6641

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

 11 24864

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

 4 18309

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 8772

What is the difference between UNIQUE KEY and UNIQUE INDEX?

 3 7510

What is the differnce between view and materialized view

 4 7519

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

 2 6316

Query for second maximum salary in each in each department

 15 34257

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

 10 12230

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 19720

select sal from emp group by sal

 3 5091

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

 1 5509

What is the relation b/w view and trigger

 3 14685

how to create temparary sequence

2 6766

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

 2 7027

Post New TCS SQL PLSQL Interview Questions


TCS SQL PLSQL Interview Questions


Un-Answered Questions

how would you store your query in an SSRS report or a Database server?

116

What is the difference between an interface and an abstract class?

530

What is the common branching pattern in GIT?

5

carnot cycle has maximum efficiency for ?

630

Explain the run levels that are used in solaris10?

528




What does a constructor do c#?

487

When do you use virutal keyword?

588

Can we use linq with ado net?

59

What is an xsl file?

292

What is the messaging pattern? Which messaging pattern wcf supports?

449

Is runtimebroker exe virus?

430

what is photo voltic cell,& what are the materials associated with that?and any spcifications like volts/cm etc?

1595

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1560

What is inheritance in php? How many types of inheritance supports php?

524

What is the use of BDC ?

536