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 11707

what is pragma ?

Polaris,

1 7062

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

HCL, Wipro,

3 10826

how to calcuate the second highest salary of he employee

Synechron,

13 18564

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

Fiserv, Herbinger, Synechron,

1 11366

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

17 32217

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 7396

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

IBM,

3 10101

What are Global Temporary tables

IBM, TCS,

3 11047

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 9276

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 16187

What is bulk collections?

2 7863

what is External tables? explain with examples

TCS,

2 13821

what is difference between decode and case function?

2 10148

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is using in sql?

1093

How delete all data from all tables in sql?

946

How many tables can a sql database have?

977

Why is there a need for sqlcode and sqlerrm variables?

1048

Are pl sql variables case sensitive?

1050

What is attribute indicator in pl sql?

1015

What are the basic sql commands?

1094

What do you understand by exception handling in pl/sql?

1035

how to use in conditions? : Sql dba

1013

What is data type in sql?

965

How to get list of all tables from a database?

1160

Explain ttitle and btitle.

1119

What is left join example?

949

What is the use of desc in sql?

977

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1033

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