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 12415

How to find only %th Highest Sal

Infogain, Symphony,

6 12270

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

Metric Stream,

2 9818

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

CTS,

2 10620

What are the Diff B/W Cursor and REF Cursor

CTS,

3 13120

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 19352

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

3 9277

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 5328

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 3803

. 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 7791

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

CGI,

4 10996

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 11673

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is sql procedures and functions?

1004

Is there any restriction on the use of union in embedded sql?

1157

how to dump a table to a file with 'mysqldump'? : Sql dba

1035

How do you update a sql procedure?

1029

What is partition in sql query?

998

What is the process of copying data from table a to table b?

1087

Can we debug stored procedure?

1023

Is sql microsoft?

1048

Is it possible to update views?

959

Is sql a backend language?

1092

List the ways to get the count of records in a table?

900

How do you use a while loop in pl sql?

1010

What is rownum in sql?

1043

What is execution plan in sql?

1042

How does rowid help in running a query faster?

1416

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