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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

What is the Query to print out the individual total number of duplicate row in sql.

TCS,

5 11700

what is pragma ?

Polaris,

1 7062

is it necessary to write group by and order by clause together

HCL, Wipro,

3 10822

how to calcuate the second highest salary of he employee

Synechron,

13 18558

what is outer join? what is selef join? what is difference between them? what is cartecion join?

Fiserv, Herbinger, Synechron,

1 11363

i need department wise top 2 employees salary.which logic i will use

17 32208

If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??

3 7394

What are Nested Tables? How will u delete 5 rows from Nested Tables

IBM,

3 10099

What are Global Temporary tables

IBM, TCS,

3 11044

What are Anti joins

IBM,

1 10346

Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 9272

If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?

JPMorgan Chase,

9 16183

What is bulk collections?

2 7859

what is External tables? explain with examples

TCS,

2 13819

what is difference between decode and case function?

2 10145

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what is a view? : Sql dba

1092

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2084

What are the various levels of constraints?

1123

Does asenumerable execute the query?

1043

Why we use join in sql?

973

Explain character-manipulation functions?

1133

How does left join work in sql?

1001

What are the uses of merge?

1167

Can we perform dml in function?

1067

Why left join is used in sql?

979

Why do we need sharding?

988

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1003

What is the difference between sql and t sql?

1034

What is a left inner join?

1015

what are numeric data types? : Sql dba

1060

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