Zensar SQL PLSQL Interview Questions Answers, Zensar Placement Papers, Zensar Technical, HR Interview Questions, Zensar Aptitude Test Questions, Zensar Campus Placements Exam Questions

Zensar SQL PLSQL Interview Questions

Questions Answers Views Company eMail

how to find the second highest salary from emp table?

211 367098

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 7238

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

3 20203

define sql

3 6423

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 8116

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 5041

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

1 6386

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 12133

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

1 5590

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 14425

Post New Zensar SQL PLSQL Interview Questions

Zensar SQL PLSQL Interview Questions

Zensar SQL PLSQL Interview Questions (10)

Un-Answered Questions

Explain the mechanism of VB.NET/C# achieve polymorphism?

992

Explain the difference between static and dynamic binding in java?

1061

What is the advantage of adding “Pre or Post” images to a plug-in?

660

What are the common document types in fi?

1098

How to pass workscontract sale invoice which includes WCT & VAT.

2208

What does the jdbc resultset interface?

967

What are the complex reports you developed in Business Objects.Please tell me 3 reports you developed and the complexity you faced and the solution

5142

Explain how many number of events does the timer controls?

924

How to delete exactly duplicate records from a table?

1050

I have a dataset concat having a variable a b & c. How to rename a b to e & f?

1277

'Invalid BLOb handle' error . what does this indicates?

1599

What are the different modules of sap? : sap abap hr

1035

What is php variable?

1000

How to validate a user input using WMLScript?

1569

Where is the root directory?

943