SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

Cap Gemini, MTS,

4 12418

How to find only %th Highest Sal

Infogain, Symphony,

6 12271

How will you make performance better for application including front end and back

Metric Stream,

2 9823

Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?

CTS,

2 10623

What are the Diff B/W Cursor and REF Cursor

CTS,

3 13121

difference between table level constraint and column level and advantages of table level constraint

Doyensys,

4 15624

I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL

Doyensys, Infosys, Metric Stream,

5 19355

I have a table .in the table 100 recored is there .we have get the single row with out using clause..

3 9280

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join.

GE,

2 5330

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

GE,

4 9946

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 3805

. have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST ACC a dv b fg b bh c mk c cl c so result:- A B c dv fg mk bh cl so

3 6351

when normalization is required

HCL,

3 7792

can i create trigger on synonym is it possible or not please help me

CGI,

4 10997

I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????

Infosys,

3 11674

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what is sp_pkeys? : Transact sql

1158

What is delimiter sql?

1004

Sql technical questions

1280

what is oracle database ? : Sql dba

1027

what is timestamp in mysql? : Sql dba

1075

What is the use of stored procedures?

1053

What is sap sql anywhere?

1077

How do I order columns in sql?

1007

Why do we use sqlite?

974

Why partition by is used in sql?

1038

Is pl sql a programming language?

990

Which nosql database is best?

975

how can we know the count/number of elements of an array? : Sql dba

1060

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

997

what are the differences between char and nchar? : Sql dba

1115

For More Un-Answered { SQL PLSQL } Questions Click Here