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

Zensar SQL PLSQL Interview Questions
Questions Answers Views Company eMail

how to find the second highest salary from emp table?

 211 376309

How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra

 2 7512

what is difference b/w pravite procedures and public procedures?

 3 20475

define sql

3 6678

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

 3 8352

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 5182

how can stop the sequence with mention the max value and with out mention the max value

 1 6567

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

 9 12608

pl/sql testing means what ...... explain process how to find pl/sql bugs

1 5726

have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.

 8 14907

Post New Zensar SQL PLSQL Interview Questions


Zensar SQL PLSQL Interview Questions


Un-Answered Questions

Why Black Rock?

1208

PLEASE SEND ME THE DOCUMENTS IF ANY ONE HAVE REGARDING THE IMPACT ANALYSYS,REVIEWS

2476

Is primary key clustered index?

1018

Are you smart?

1252

How to create a base64 decoder in java8?

1133

What is Generative AI, and how does it differ from traditional AI models?

113

Were you involved in any data conversion, which one?

57

sir/madam, i've applied for the post of section engineer. i shall highly be obliged if you could help me out with some sample papers.

1935

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2276

What are you passionate about?

1330

What is current GDP of India?

1625

Where did you travelled last time

3187

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1045

Please Provide me the link to download Testing Category questions and answers If some body has downloaded it pleae send it to me Pavan : Email pavan_cd@yahoo.com Quetion2 : Can any body Explain me about Testing thumb rules

2200

HI..!! I THINK THIS SITE IS AN EXCELLENT SOURCE FOR YOUNG ENGINEERS, I READ THE POSTS REGARDING DIFFERENT PLACEMENT PAPERS IT WAS INDEED HELPUFL...BUT FRM WHR CAN I GET THE WHOLE APTITUTE PAPER FOR REFERENCE??

2142