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 321291

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 6166

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

 3 18496

define sql

3 5090

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 6748

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 4191

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

 1 5521

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 10039

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

1 4825

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 12016

Post New Zensar SQL PLSQL Interview Questions


Zensar SQL PLSQL Interview Questions


Un-Answered Questions

You want to have each step in your script measured as a transaction in the controller and not shown in the replay log in vugen. How can you accomplish this?

565

Does zend support php 4? Explain

141

In which files database settings are stored in joomla cms?

69

Explain the difference between an exe and a dll?

525

What is data warehouse architecture?

578




What is the status of written journalism these days?

549

Routers are used in which layers?

606

How do I connect to a database in mysql workbench?

544

if you fix salary to some body for Rs.10000/- what are the segregations to be done and what are the deductions to be done (segregations like basic, da,ta,conveyance etc., how ? what percentage what speaks law) and deductions what are those like, pf,esi,pt, etc., what ever

1545

What does allotropic mean?

556

Name the two properties which are common in every validation control?

536

What is the value of h?

587

How do you think your experience of digital marketing will benefit our business?

185

what is different between oops and c++

1999

What is transactional in java?

514