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 12420

How to find only %th Highest Sal

Infogain, Symphony,

6 12275

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

Metric Stream,

2 9824

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

CTS,

2 10624

What are the Diff B/W Cursor and REF Cursor

CTS,

3 13124

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

Doyensys,

4 15626

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 19360

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

3 9281

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 5337

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 9951

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 3808

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

when normalization is required

HCL,

3 7804

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

CGI,

4 11002

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 }

Is it possible to link two groups inside a cross products after the cross products group has been created?

1002

What are the various levels of constraints?

1125

What is the difference between subquery and correlated query?

1065

Explain clause in sql?

1032

what is sql server agent? : Sql dba

1109

what is isam? : Sql dba

1008

explain the difference between bool, tinyint and bit. : Sql dba

1001

Can I learn sql in a week?

1075

what does the t-sql command ident_incr does? : Transact sql

1077

How do I create a memory optimized filegroup?

961

How many scalar data types are supported in pl/sql?

1057

what is the difference between where clause and having clause? : Sql dba

1000

What is acid property in a database?

1035

what is the difference between myisam static and myisam dynamic? : Sql dba

1065

What is a primary key called that is made up of more than one field?

1351

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