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 11699

what is pragma ?

Polaris,

1 7060

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 18556

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

Fiserv, Herbinger, Synechron,

1 11358

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

17 32200

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 10098

What are Global Temporary tables

IBM, TCS,

3 11037

What are Anti joins

IBM,

1 10345

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 9267

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 16172

What is bulk collections?

2 7859

what is External tables? explain with examples

TCS,

2 13817

what is difference between decode and case function?

2 10142

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the purpose of using pl/sql?

1144

Define join and name different types of joins?

1008

What is a parameter query?

1083

Which constraints we can use while creating database in sql?

1079

Why we use join in sql?

966

What is the difference between row level and statement level trigger?

1021

Is oracle sql free?

985

What are field types?

1004

Can a procedure in a package be overloaded?

1043

How subquery works in sql?

1067

What is the maximum number of rows in sql table?

1030

how to enter binary numbers in sql statements? : Sql dba

972

Define implicit and explicit cursors.

1144

Explain mutating table error.

1200

what are wild cards used in database for pattern matching ? : Sql dba

1142

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