Sign Up Login


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 338784

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 6612

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

 3 19229

define sql

3 5605

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 7378

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 4566

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

 1 5890

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 11050

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

1 5145

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 12939

Post New Zensar SQL PLSQL Interview Questions


Zensar SQL PLSQL Interview Questions


Un-Answered Questions

How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC

1716

Suppose ur app server is .net server. In that connection pool is related to memory ?explain how?

2084

In an avl tree, at explain what condition the balancing is to be done?

712

What does it mean if something is static?

599

Is naive bayes a supervised or unsupervised method?

61




How do I run a .sh file on mac?

872

What is Salesforce?

286

which r the connectors used in san?

1958

What are JavaScript Data Types?

754

What are the different tcl commands in sql?

815

What are various ways of locating an element in selenium?

648

Tell the basic difference between banking and finance?

759

What are client dependant objects in abap/sap?

862

How to configure the global security?

685

write a programme to get a character and thier ASCII value

2780