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 321783

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 6177

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

 3 18503

define sql

3 5107

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 6766

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 4196

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

 1 5529

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 10072

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

1 4831

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 12041

Post New Zensar SQL PLSQL Interview Questions


Zensar SQL PLSQL Interview Questions


Un-Answered Questions

What is bidirectional firewall rule?

618

How can data class be used in Kotlin?

192

Explain the different types of data warehousing?

569

What is half duplex transmission?

590

What is pthread_mutex?

396




What are early binding and late binding.

566

Explain advantages and disadvantages of ddf?

595

please what are the required bars for a beams of 6mx6m and 450x300mm, one is continuous and the the second is discontinuous ..Its a commercial building (church)

1352

Why we use void main in c?

597

Where is the conditional formatting in excel?

284

Explain about echo command?

625

What is jdbc? Describe the steps needed to execute a sql query using jdbc.

505

What is a document type? : fi- general ledger

617

Explain the number or character entered through keyboard gets converted to equivalent ascii code & it get stored on ram in the binary form. What is the exact procedure. : Dot net architecture

530

What are the access method services used in vsam?

596