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 319556

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 6118

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

3 18424

define sql

3 5033

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 6681

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 4158

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

1 5489

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 9938

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

1 4799

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 11928

Post New Zensar SQL PLSQL Interview Questions


Zensar SQL PLSQL Interview Questions


Un-Answered Questions

How to set http request header in angular 4?

454


Tell me what is the use of "ksort" in php?

538


What is statement and resultset in jdbc?

476


How can we sort the DS, what facility we can get in by placing fields in Ranges?

5


What is sharepoint from a users perspective?

401






How many rows can excel 2013 have?

274


Hi,Friends, I have a simple question in my mind that I have one head office that in faridabad and other branch in delhi,i purchase material in delhi for availing the tax benefit in delhi then i transfer the same material to head office(faribabad) agianst "F" form,i purchased material in delhi basic price rs. 5 +.42 taxes it comes rs. 5.42/-,my question is on which amount i should transfer the material from delhi to faridabad i.e 5,5.42 or 5 + freight(if any).kindly please solve my problem.

1300


What is windows patch file?

394


Why use yii 2.0 framework?

3


What is a zend framework and why it is used?

128


Why node js is different from angular js?

228


Tell me what is the difference between list and tuple?

443


What is the average cost of data recovery?

489


What are predefined functions in sql?

500


What is Trigger in Oracle?

550